BSE EOD Downloader

hi folks,

I have developed a worksheet, which downloads BSE EOD quotes since 1991.

hope fellow member will find it useful.

the documentation is in the worksheet itself.

15.09.2006
new feature includes:
can download 50 scripts at one go.

the data will be in ASCII Text format, thus almost all major software like Metastock, Amibroker, FCharts etc can import the same with ease.

cheers,
jdm.

Hi Jdm
Nice sheet.
Will it be possible to have a symbol translation page(a one time effort) and some loops that will download all the data for all the symbols for the specfied period. And then formatted output for Fcharts, Amibroker, etc...This will be great help to those starting now and want to dig for the BSE scrip data.

I could have peeped in the code to look for it but

Best Regards
Coool.

Hi! jdm,

Thanks for the worksheet.

Feedback : The Volume shows as "0" for all the dates.
Query : Is it possible to have a silimar worksheet that downloads the history for all the scrips of BSE at one go

Thanks & regards,
Amit

hi coool and amit,
thanks for trying out the worksheet.

its a hell of a job. the bse bhavcopy may lead us but ............ basically since i developed it for my own use and i track certain perticular script anly, the need for the comprehensive script code never arose. a lot of yahoo codes for both nse and bse do circulate in the web but for bse script code i am not sure.

the final data is compatible with FChars. just save the new excel sheet in CSV format. while it is compatible with metastock also. save it in excel and put use of the downloader. i am not sure of amibroker, but amiborker supports metastock format.

look i do believe in open source. but since the data source is the bse site itself and bse does not provides you with data unlike nse, i deliberately desisted from putting it in public. privately may be...........

well with software nothing is immposible. but as i already mentioned in the worksheet that i am not a programmer. in fact, i never had any formal computer training.

there are many software which do downloads at one go but i have not come accross that backfill way back since 1991 and with such speed.


the problem lies not with the worksheet. but with the data source itself. and its limited for the first few years only. the volumes comes to live after 1994.

and of course good to hear the worksheet working fine at other computers as well.

cheers,
jdm.

Cheers ...

Hi JDM
Yes man, its the speed that interests me, and when u say you are using the webpage itself as the datasource, the interest grows. I would like to explore this further. If its just some webquery getting the data, then I know that but some other way, well... I would like to learn. there are unlimited possibilites to using this. The simple webquery, I find it boring and slow.
I will check the sites you have mentioned in the spreadsheet. If I am stuck hope you will help me out.

Best Regards
Coool.

well its simple webquary thats imports the data.

sure man. i always believe in the power of synergy.

the link for the excel file at gummy-stuff.org was not working, the last time i checked in. so i am uploading the same.

cheers,
jdm.

Hi jdm

I have to thank you for your excellent excel sheet. I was always suspicious about Charting module of BSE and how thay are collecting data in temporary storage. I was able to trap the data but it never occured me to examine the query and that includes intraday.All the time concentrated on bhav copies. What a possiblity you have thrown open. Same is true for NSE. But for want of time and energy I was not implementing it. Now you have pointed a way so with your permission I will incorporate in my software. BSE never said they don't permit this anyway.

I think I will implement those intradays also

Thanks a lot

Pankaj

ps: I have not given url as you have not indicated it. Though there is noting wrong abt it.

Hi JDM
Yes, could find that it was a webquery. But the link you are using for the webquery is a very good one. And since it is a webpage without any images, so we have that great speed. Thanks a lot for the link.

Do you have something similar for NSE too??

Best Regards
Coool.

JDM - Lovely utility you have created and amazed at the speed. Can you share the password privately? Would like to peek into the code..

Regards
Satish