BSE multiple scrips EOD Data Downloader V1.0 (Year 1991 to Current Date)

S

satish_goteti

Member
#1
#1
Dear friends,

Here is a small utility I created based on jdm's tool which I am sure will help most of us in not paying for EOD data of BSE to multiple sellers. Just pick the stocks you want to download data from the BSE symbol list file and enter them in the downloader and hit Go and watch the files being created one by one. This will download data of multiple scrips at one shot and creates individual files in a format which can be used by many trading softwares I hope.


Help : (Also available in the first page of the software)

About the Downloader :

What does it do ?
Downloads historical data from BSE site and creates scrip wise files in the same directory.

How can I use it?
Enter multiple stocks in Download sheet, and download EOD data from 1991 till date

What is format of data extracted?
The format of the data is Stock Code, OPEN, HIGH, LOW, CLOSE, VOLUME. Most trading softwares have this format. If you want a custom format, please let me know, I will try.

Can I configure the dates?
Not yet. Will come in the next versions. Comon you have data from 1991. You can delete unwanted data can't you?

Will I get password for the source code?
Not yet as per request from jdm to maintain privacy. If 15 people say its not a problem and jdm agrees I am willing to share the password.

How many stocks can I download at one time?
Actually no limit. I have tested for 50 symbols and it took 2 minutes. I would not want to test for 100 stocks but you could. Please don't enter 1500 stocks and expect it to do download in 60 minutes. Afterall it depends on your PC power and internet connection also.

Have you tested it?
Yes to some extent but not on all versions and absolutely no responsibilities for any adverse effects. Use at own risk.

Are the macro's safe?

Yes and I can vouch for it.

Can we ask changes/requests?

Yes and No. No guarantee they will be implemented and no guarantee on the timelines, but I will do my best.

What is the data source ?

BSE India website.

Can I use the PC while this is downloading?

Yes ofcourse. But please do not open new excel files or open created excel files while the macro is running.

I have a MAC or Linux OS can I use it?
I am not sure and please let me know if you used it and it was successful.


STEPS TO USE.

Refer the first sheet.


Please shoot your comments back.


Regards
Satish
 
G

gobatman2001

Active Member
#2
#2
satish_goteti said:
Dear friends,

Here is a small utility I created based on jdm's tool which I am sure will help most of us in not paying for EOD data of BSE to multiple sellers. Just pick the stocks you want to download data from the BSE symbol list file and enter them in the downloader and hit Go and watch the files being created one by one. This will download data of multiple scrips at one shot and creates individual files in a format which can be used by many trading softwares I hope.


Help : (Also available in the first page of the software)

About the Downloader :

What does it do ?
Downloads historical data from BSE site and creates scrip wise files in the same directory.

How can I use it?
Enter multiple stocks in Download sheet, and download EOD data from 1991 till date

What is format of data extracted?
The format of the data is Stock Code, OPEN, HIGH, LOW, CLOSE, VOLUME. Most trading softwares have this format. If you want a custom format, please let me know, I will try.

Can I configure the dates?
Not yet. Will come in the next versions. Comon you have data from 1991. You can delete unwanted data can't you?

Will I get password for the source code?
Not yet as per request from jdm to maintain privacy. If 15 people say its not a problem and jdm agrees I am willing to share the password.

How many stocks can I download at one time?
Actually no limit. I have tested for 50 symbols and it took 2 minutes. I would not want to test for 100 stocks but you could. Please don't enter 1500 stocks and expect it to do download in 60 minutes. Afterall it depends on your PC power and internet connection also.

Have you tested it?
Yes to some extent but not on all versions and absolutely no responsibilities for any adverse effects. Use at own risk.

Are the macro's safe?

Yes and I can vouch for it.

Can we ask changes/requests?

Yes and No. No guarantee they will be implemented and no guarantee on the timelines, but I will do my best.

What is the data source ?

BSE India website.

Can I use the PC while this is downloading?

Yes ofcourse. But please do not open new excel files or open created excel files while the macro is running.

I have a MAC or Linux OS can I use it?
I am not sure and please let me know if you used it and it was successful.


STEPS TO USE.

Refer the first sheet.


Please shoot your comments back.


Regards
Satish
Click to expand...
Hi! Satish,

The spreadsheet works like a dream.

Just one request ...

Instead of getting separate sheets for "each" symbol, would it be possible
to get separate sheets "date wise" for "all symbols"

Basically, like the EOD bhavcopy that we download everyday. That would be truly valuable. Or am I asking for too much?

Thanks & regards,
Amit
 
J

johnbest

Member
#3
#3
Dear satish_goteti

Gr8 job dear.....;)
Also is it possible to save the data in csv file rather than in xl workbook ? :D

Have a nice day ;)
John Best
 
J

jay.thakkar

New Member
#4
#4
hi,
great work on a great work
i mean a great hands on jdms utlity.
the sheet is great but always download all data.
my i peak it further in order to to get the data by day selection.
if you and jdm doesnt have any problem then please share the password with me. the password will be kept personal and wont be shared with anyone.
the utility may take a week of development and will be available to you first in order to check for any bugs. you and jdm may publish it. i am not intersted in publishing personaly. i need it in order to use it for personal trading.
thanking you in anticipation,
email: [email protected]
 
D

dilip_bgr

New Member
#6
#6
hi satish,

really a pretty small software with beautiful wings. i am late in knowing about the software.

Could any one, well-wisher of satish, tell me - whenever I download data of any scrip, it downloads data upto 01.01.2008 - why ?
 
P

pitar

New Member
#8
#8
thank u very much,,very useful,but it doesn't show any data after 1st Jan,2008,is there update in the software,thanks in advance
 
T

thulasee_77

New Member
#9
#9
Hi Satish,

EOD Data Downloader is very useful. But, it seems it is fetching data upto 01-01-08, which means almost 10 months outdated and all price information against the scrips are at peak. Where as you know there have been lot of changes in the prices recently.

Is there any way that we can get the data with the help of above software as of today (Upto Last Trading day).

Thanks and Regards,
Thulasee
 
P

prabhatmittal20

New Member
#10
#10
satish_goteti said:
Dear friends,

Here is a small utility I created based on jdm's tool which I am sure will help most of us in not paying for EOD data of BSE to multiple sellers. Just pick the stocks you want to download data from the BSE symbol list file and enter them in the downloader and hit Go and watch the files being created one by one. This will download data of multiple scrips at one shot and creates individual files in a format which can be used by many trading softwares I hope.


Help : (Also available in the first page of the software)

About the Downloader :

What does it do ?
Downloads historical data from BSE site and creates scrip wise files in the same directory.

How can I use it?
Enter multiple stocks in Download sheet, and download EOD data from 1991 till date

What is format of data extracted?
The format of the data is Stock Code, OPEN, HIGH, LOW, CLOSE, VOLUME. Most trading softwares have this format. If you want a custom format, please let me know, I will try.

Can I configure the dates?
Not yet. Will come in the next versions. Comon you have data from 1991. You can delete unwanted data can't you?

Will I get password for the source code?
Not yet as per request from jdm to maintain privacy. If 15 people say its not a problem and jdm agrees I am willing to share the password.

How many stocks can I download at one time?
Actually no limit. I have tested for 50 symbols and it took 2 minutes. I would not want to test for 100 stocks but you could. Please don't enter 1500 stocks and expect it to do download in 60 minutes. Afterall it depends on your PC power and internet connection also.

Have you tested it?
Yes to some extent but not on all versions and absolutely no responsibilities for any adverse effects. Use at own risk.

Are the macro's safe?

Yes and I can vouch for it.

Can we ask changes/requests?

Yes and No. No guarantee they will be implemented and no guarantee on the timelines, but I will do my best.

What is the data source ?

BSE India website.

Can I use the PC while this is downloading?

Yes ofcourse. But please do not open new excel files or open created excel files while the macro is running.

I have a MAC or Linux OS can I use it?
I am not sure and please let me know if you used it and it was successful.


STEPS TO USE.

Refer the first sheet.


Please shoot your comments back.


Regards
Satish
Click to expand...
Hi JDM,

This sheet gives quotes till 2008, can u give a updated version - or share the password so that i can see the code and modify if possible.

Thanks
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
V BSE weekly options expiry on Friday Options 2
S NSE / BSE Sector Industry Classification AmiBroker 9
A Which is better NSE or BSE? Advanced Trading Strategies 2
S Web scrapping on bseindia.com General Chit Chat 0
A Fetching NSE and BSE stock data and stock news Beginners Guide 0

Similar threads