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

LISTED COMPANIES

Submit Post


ADVERTISE
Poll

EXCHANGE RATE PREDICTION: 2022

 
 
 
 

View results

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


CONATCT US


Send your suggestions and comments

* - required fields

Read FINANCIAL CHRONICLE™ Disclaimer



Latest topics

» POSITIVES & TARGETS BY IMTIAZ BUHARDEEN
by Gowri123 Yesterday at 4:38 pm

» When will supply chain disruptions ease?
by Gowri123 Yesterday at 4:08 pm

» We’re seeing a shift toward international and value stocks, says Schwab’s Kleintop
by target1 Yesterday at 2:40 am

» Wall Street stumbles as consumer pessimism stokes growth fears
by target1 Yesterday at 2:34 am

» Free Market Capitalism vs. Crony Capitalism
by target1 Yesterday at 2:30 am

» Sri Lankan corporations reap large profits as workers and rural toilers face poverty and starvation
by CHRONICLE™ Tue Jun 28, 2022 6:37 pm

» අද රාත්‍රියෙන් පසු, යක්ෂයාගේ හෝරාව ඇරඹේ!
by God Father Tue Jun 28, 2022 6:13 pm

» Derana 360 with Minister Dhammika Perera
by samaritan Tue Jun 28, 2022 1:07 pm

» CENTRAL INDUSTRIES PLC (CIND.N0000)
by LHW Tue Jun 28, 2022 9:24 am

» Breaking News- Kanchana to go to Qatar ; 2 more ministers off to Russia
by Beyondsenses Tue Jun 28, 2022 8:13 am

» PM thanks President Biden for assuring US support to Sri Lanka
by Beyondsenses Tue Jun 28, 2022 8:07 am

» Sri Lanka Stock Market heading toward ASPI 4500
by God Father Mon Jun 27, 2022 9:14 pm

» Why no power cuts in certain areas of Colombo?
by God Father Mon Jun 27, 2022 8:03 pm

» Expolanka to continue its winning streak
by samaritan Mon Jun 27, 2022 9:49 am

» කොළඹ රාජකීය ගොල්ෆ් සමාජය විසින් රජයේ දේපළ අවභාවිත කිරීම
by ddindika Mon Jun 27, 2022 9:33 am

» LOLC to enter the giant Indian Market
by samaritan Mon Jun 27, 2022 9:17 am

» LOLC HOLDINGS PLC (LOLC.N0000)
by CHRONICLE™ Mon Jun 27, 2022 6:46 am

» SOEs within Minimum Programme for Economic Recovery
by CHRONICLE™ Mon Jun 27, 2022 6:44 am

» COVID WAVES: Can there be another Covid-19 wave in Sri Lanka?
by CHRONICLE™ Mon Jun 27, 2022 6:36 am

» Luminex Limited lists on the Diri Savi Board after a capital raise of Rs. 250 Million
by CHRONICLE™ Mon Jun 27, 2022 6:34 am

EXPERT CHRONICLE™

MARKET CHAT


CHRONICLE™ ANALYTICS


ECONOMIC CHRONICLE

GROSS DOMESTIC PRODUCT (GDP)


CHRONICLE™ YouTube

LATEST TWEETS

You are not connected. Please login or register

FINANCIAL CHRONICLE™ » CHRONICLE™ ANALYTICS » Ami Data using DFN

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

Back to top  Message [Page 1 of 1]

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