Excel Sheet

[chand]

I have a query in ms excel.

I am downloading the data through web query NAV from AMFI india the data gets download in one single col. then i use Data > Text to col. to sepreate the data, it is done, but when it gets refresh it is again in the same col.

what shall i do.

Regards,
Chand

 

[aca_trader]

I have a query in ms excel.

I am downloading the data through web query NAV from AMFI india the data gets download in one single col. then i use Data > Text to col. to sepreate the data, it is done, but when it gets refresh it is again in the same col.

what shall i do.

Regards,
Chand

Design a macro to do the "Text to column" job automatically at specified intervals.

Best Regards,
--Ashish

 

[chand]

Thnks for reply.

But can you throw more light on that.

Chand

 

[instaalert]

hello friends in trade,
can any one enlighten me on excel sheet, its use, formation, etc.,?
enquiringly yours,
instaalert.

 

[ger06]

Dear Instaalert

Please get the excel file from 4shared.com link

http://www.4shared.com/file/15056057/c1f01c06/Amfi-Nav.html

After opening the file right click a cell & click refresh button.
he data will be updated. Be patient as it takes some time to download data.


Regards.

 

[instaalert]

hi ger06,
thanks for your reply.
i downloaded the file, which shows the nav of all mf-s.
the xl sheet is only to findout the nav or what are the other uses?
can you pl enlighten me?

 

[ger06]

Dear

Save it as csv file & then u can import it in Amibroker or any other charting software.

Regards....

 

[sdebu_2000]

Dear

Save it as csv file & then u can import it in Amibroker or any other charting software.

Regards....

GER06,
Great Excell sheet man! it really amazing !! Thanx for your post.
Would u plz tell me how we can plot chart with this data? As I know to plot a chart u have at least 4 fields (Open, high,Low,close) for each day but here no such fileds are there. Is it possible to plot line chart in amibroker with the latest NAV of every day(ie. equivalent to closing price???).Do u have the Historical Data for those Funds? Please reply me .
I am very much eager to have the chart of those funds in Metastock and Amibroker. Please Help!!!!!!!!!
thanx once again.

Debdulal Bhattacharyya
Kolkata

 

[ger06]

Dear Debudulal

Pl. find herewith txt file. Copy & save them as .afl file in format folder of Amibroker ( give any name as u like). This is for importing of csv file.
Import the amfi.csv using this format file. If u have more than 3 files u will get the charts.
I hope u know hoe to creat new data base & import the data. If not please search in software section of traderji. U will get lot of information posted by our senior & valued members.

Regards.

 

[sdebu_2000]

Dear Debudulal

Pl. find herewith txt file. Copy & save them as .afl file in format folder of Amibroker ( give any name as u like). This is for importing of csv file.
Import the amfi.csv using this format file. If u have more than 3 files u will get the charts.
I hope u know hoe to creat new data base & import the data. If not please search in software section of traderji. U will get lot of information posted by our senior & valued members.

Regards.

Dear Ger06,
Thanx again for your help.I have done already all those job what you have told.The afl you posted is good.But My question is that those data of amfi ca't plot bar or candle chart as it has only closing price, is not it?
Any way, do u have the historical database of amfi data format? otherwise I have to wait for another three days to get charts and I have to wait another 2months(atleast) to get a readable chart in Amibroker.
Can I get it from you?
Plz reply.
Debdulal Bhattacharyya