Tried many softwares, free sites, but hicups never ended.
I have found a way out to self dependent for EOD Data.
The following steps are involved.
1. Download Bhavcopy from NSE site.
2. Unzip, you get data in EXCEL.
3. Goto Data>Filter>AutoFilter
4. Click the drop down box on "Series". Choose "Custom"
5. Give criteria "EQ" or "BE". Click OK.
6. Now, select entire data copy and paste into another Worksheet and save.
7. Save the new file as CSV delimited.
Now, the data is ready to append using File>Import Wizard
Choose the columns as required and append.
Enjoy! Free EOD.
I welcome suggestions to shorten the procedure to save time and effort.
I have found a way out to self dependent for EOD Data.
The following steps are involved.
1. Download Bhavcopy from NSE site.
2. Unzip, you get data in EXCEL.
3. Goto Data>Filter>AutoFilter
4. Click the drop down box on "Series". Choose "Custom"
5. Give criteria "EQ" or "BE". Click OK.
6. Now, select entire data copy and paste into another Worksheet and save.
7. Save the new file as CSV delimited.
Now, the data is ready to append using File>Import Wizard
Choose the columns as required and append.
Enjoy! Free EOD.
I welcome suggestions to shorten the procedure to save time and effort.