FINANCIAL CHRONICLE™
Dear Reader,

Registration with the Sri Lanka FINANCIAL CHRONICLE™️ would enable you to enjoy an array of other services such as Member Rankings, User Groups, Own Posts & Profile, Exclusive Research, Live Chat Box etc..

All information contained in this forum is subject to Disclaimer Notice published.


Thank You
FINANCIAL CHRONICLE™️
www.srilankachronicle.com


Join the forum, it's quick and easy

FINANCIAL CHRONICLE™
Dear Reader,

Registration with the Sri Lanka FINANCIAL CHRONICLE™️ would enable you to enjoy an array of other services such as Member Rankings, User Groups, Own Posts & Profile, Exclusive Research, Live Chat Box etc..

All information contained in this forum is subject to Disclaimer Notice published.


Thank You
FINANCIAL CHRONICLE™️
www.srilankachronicle.com
FINANCIAL CHRONICLE™
Would you like to react to this message? Create an account in a few clicks or log in to continue.
FINANCIAL CHRONICLE™

Encyclopedia of Latest news, reviews, discussions and analysis of stock market and investment opportunities in Sri Lanka

Click Link to get instant AI answers to all business queries.
Click Link to find latest Economic Outlook of Sri Lanka
Click Link to view latest Research and Analysis of the key Sectors and Industries of Sri Lanka
Worried about Paying Taxes? Click Link to find answers to all your Tax related matters
Do you have a legal issues? Find instant answers to all Sri Lanka Legal queries. Click Link
Latest images

Latest topics

» CSE to turn bullish after November 14 poll
by Rare Today at 10:13 am

» ලාභ විජ්ජාව!!
by D.G.Dayaratne Yesterday at 8:11 pm

» Banking Sector (3Q 2024)
by God Father Yesterday at 7:05 am

» Prepare to be blown away..
by cpriya Yesterday at 1:05 am

» Hotel Sigiriya (HSIG) most undervalued & huge profit making Hotel
by LAMDA Sat Nov 16, 2024 11:38 pm

» ‘Buy the Rumour, Sell the News’
by God Father Sat Nov 16, 2024 12:00 pm

» Asian stocks drift higher amid rate cut speculation; Japan lags
by Rare Sat Nov 16, 2024 9:56 am

» Oil prices fall further
by Rare Sat Nov 16, 2024 9:40 am

» Post-election winners.
by Rare Sat Nov 16, 2024 9:36 am

» Bullish about a sustainable turnaround - CSE Chairman
by Rare Sat Nov 16, 2024 9:25 am

» Plantation Companies
by Rare Sat Nov 16, 2024 9:19 am

» COMMERCIAL BANK OF CEYLON PLC (COMB.N0000)
by EPS Thu Nov 14, 2024 10:31 pm

» People's leasing VS Singer Finance IPO Analysis
by ddrperera Wed Nov 13, 2024 8:18 pm

» Insights into LOLC Advanced Technologies
by samaritan Wed Nov 13, 2024 10:41 am

» LOLC Tech's ambitious plans for global expansion
by samaritan Tue Nov 12, 2024 2:06 pm

» PLANTATION SECTOR
by God Father Sun Nov 10, 2024 8:19 pm

» People's leasing company, a hidden gem? (an analysis)
by Nandana Withanage Sun Nov 10, 2024 6:56 pm

» PEOPLE'S LEASING BUYING SIGNAL Target Price 19 ..PLEASE KEEP EYE ON THIS..
by nilantha suranga Sun Nov 10, 2024 9:16 am

» Peoples leasing technically positive Target Price Rs 20
by Shiranli Sun Nov 10, 2024 7:43 am

» Quarterly Research Updates (Sep 2024)
by God Father Sun Nov 10, 2024 7:42 am

» Peoples Leasing....!!! whts the target?
by rajithasahan Sun Nov 10, 2024 7:35 am

» PEOPLE'S LEASING & FINANCE PLC
by mafasmunaseer Sun Nov 10, 2024 12:45 am

» Will garment exports to U.S. be taxed under Trump administration?
by Quibit Sat Nov 09, 2024 4:34 pm

LISTED COMPANIES

Submit Post
ශ්‍රී ලංකා මූල්‍ය වංශකථාව - සිංහල
Submit Post


CONATCT US


Send your suggestions and comments

* - required fields

Read FINANCIAL CHRONICLE™ Disclaimer



EXPERT CHRONICLE™

ECONOMIC CHRONICLE

GROSS DOMESTIC PRODUCT (GDP)



CHRONICLE™ YouTube


You are not connected. Please login or register

Ami Data using DFN

5 posters

Go down  Message [Page 1 of 1]

1Ami Data using DFN Empty Ami Data using DFN Sun Mar 18, 2012 12:36 am

chamith

chamith
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics

If you are using Ami broker for TA, then you know what a pain it is to update ami data. Specially nowadays CSE trade data on the website contains missing information. Eg: blank HIGH

Therefore i found a much easier way to get this data using Direct FN.

1st step is to build a watch list in DirectFN with information we need to update Ami. [Only have to do this once]
Go to watchlist and click create new watchlist
[You must be registered and logged in to see this image.]

then give it a name

2,
now go to the new watch list and right click on a column and select choose columns

now remove the unwanted columns and leave only the once needed for Ami. refer bellow
[You must be registered and logged in to see this image.]

Before you close the window give a name and select apply - current window.

3,
now you can just copy these data into a excel sheet by selecting all symbols and selecting copy.

4,
#in the excel sheet make sure to add the date in a new column in YY/MM/DD right next to symbols column.

5. Save the file as a CVS file and upload it to ami in the usual way.

2Ami Data using DFN Empty Re: Ami Data using DFN Sun Mar 18, 2012 1:27 am

FXX

FXX
Senior Manager - Equity Analytics
Senior Manager - Equity Analytics

Thanks Smile

3Ami Data using DFN Empty Re: Ami Data using DFN Sun Mar 18, 2012 5:36 am

K.Haputantri

K.Haputantri
Co-Admin

Thanks Chamith.

4Ami Data using DFN Empty Re: Ami Data using DFN Sun Mar 18, 2012 8:24 am

stumpy

stumpy
Senior Manager - Equity Analytics
Senior Manager - Equity Analytics

Chami,

You can export to excel as per my knowledge rather than copy n paste!
Thanks for sharing machang!

5Ami Data using DFN Empty Re: Ami Data using DFN Sun Mar 18, 2012 8:51 am

stumpy

stumpy
Senior Manager - Equity Analytics
Senior Manager - Equity Analytics

BTW

Remember to delete "Not Traded Counters" (with 0 volume) too!
If not ur Ami will end up with funny setups! Very Happy

6Ami Data using DFN Empty Re: Ami Data using DFN Sun Mar 18, 2012 9:05 am

chamith

chamith
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics

I tried that stUm.
But for some reason my laptop get stuck whn I do that. So I just copy n paste.
Ya I forgot to mention about non trading symbols. Thanks stump. There r about 400 symbols in cse, so just make sure to delete the unwanted symbols from the watch list

7Ami Data using DFN Empty Re: Ami Data using DFN Sun Mar 18, 2012 9:17 pm

smallville

smallville
Associate Director - Equity Analytics
Associate Director - Equity Analytics

I think this exporting to Excel thing is not functioning in windows 7.. In Excel it supposed to work Wink

Sponsored content



Back to top  Message [Page 1 of 1]

Permissions in this forum:
You cannot reply to topics in this forum