BSE EOD Downloader

jdm · #1 2nd July 2006, 03:12 PM

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.

cooltetra · #2 2nd July 2006, 04:20 PM

Quote:

Originally Posted by jdm

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.

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.

gobatman2001 · #3 2nd July 2006, 04:40 PM

Quote:

Originally Posted by jdm

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.

cheers,
jdm.

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

jdm · #4 2nd July 2006, 06:49 PM

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

Quote:

Originally Posted by cooltetra

Will it be possible to have a symbol translation page(a one time effort)

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.

Quote:

Originally Posted by cooltetra

formatted output for Fcharts, Amibroker, etc

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.

Quote:

Originally Posted by cooltetra

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

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...........

Quote:

Originally Posted by cooltetra

and some loops that will download all the data for all the symbols for the specfied period

Quote:

Originally Posted by gobatman2001

Query : Is it possible to have a silimar worksheet that downloads the history for all the scrips of BSE at one go

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.

Quote:

Originally Posted by gobatman2001

Feedback : The Volume shows as "0" for all the dates.

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.

gobatman2001 · #5 2nd July 2006, 07:20 PM

Quote:

Originally Posted by jdm

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

cheers,
jdm.

Cheers ...

cooltetra · #6 2nd July 2006, 08:39 PM

Quote:

Originally Posted by jdm

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...........

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.

jdm.

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.

jdm · #7 2nd July 2006, 10:05 PM

Quote:

Originally Posted by cooltetra

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.

well its simple webquary thats imports the data.

Quote:

Originally Posted by cooltetra

I will check the sites you have mentioned in the spreadsheet. If I am stuck

hope you will help me out.

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.

pkjha30 · #8 2nd July 2006, 10:22 PM

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.

cooltetra · #9 2nd July 2006, 10:25 PM

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.

satish_goteti · #10 2nd July 2006, 10:30 PM

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

Similar Threads for: BSE EOD Downloader
Thread	Thread Starter	Forum	Replies	Last Post
Equis Downloader	longhai	End of Day	7	4th February 2008 01:54 PM
vendor & downloader	ofog2000	Software	3	9th July 2006 08:18 PM
Ml Downloader	Achiever	Data Feeds	19	10th November 2005 07:03 PM
quotes downloader ?	shreyadr	Data Feeds	1	7th June 2005 11:49 AM
Quote Downloader Software	sbn021	Data Feeds	0	17th January 2005 02:33 PM