Hi ALL,
I have configured to get Realtime data from Yahoo to Excel Sheet, now i need to convert from excel to Metastock Format.
Can anyone guide me how to convert excel to metastock format. This will help to complete my task.
Also I need below information :
Where to get all NSE Scripts in one place at yahoo finance ?
Please guide me................
Thanks in Advance
SRIRAM..........
s.sriraam
Good ! you are interestet excel,very good.
I have done this,but now I have not this excel file with me.
I have deleted it after converting it into VB.
Make text file anywhere in hard disk and overwrite it during every tick.
File should be like this.
<TICKER>,<DTYYYYMMDD>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>
^NSEI,20100326,15:10:00,5290.75,5291.65,5290.75,5291.15,
AEGISCHEM,20100326,15:10:00,223.4,224.5,223.4,224.5,2604
BALAJITELE,20100326,15:10:00,52.1,52.1,52.1,52.1,20
BHEL,20100326,15:10:00,2373.65,2374.3,2373.3,2373.5,5764
I have remove .NS ext. You can keep it.
Feed txt file to asc2ms.exe every time,using shell command
asc2ms.exe will create metastock data.
This utility is free utility create by Mohammed Illyas Mansoor
You can get if from Mansoor's site or my programe's folder.
You can do anything in excel.
Check my vb programe and see what is power of excel.
This programe is copy of my excel workbook.Nothing more
or less.
Get it from this link.
http://www.4shared.com/file/244983792/b55fdb78/NDC_Data_Downloader_for_Indian.html
Where to get all NSE Scripts in one place at yahoo finance ?
Are you asking about symbol list ?
Not available in yahoo.NSE's symbol is yahoo's symbol
just add .NS
