Need eod equity data from nse-any tool or simple process?

#1
Hi friends

A friend of mine with not much computer exposure wanted eod stock data from nse.

Can somebody give some hints please
I heard the hemen s tool is giving trouble and data goes missing etc.

Suppose I plan to tell my friend
1 download bhavcopy
2.unzip
3 how can he import the data into Amibroker daily?
any software tool is ok to pay reasonable fees.

I wanted to recommend manshirt but they never respond.
my friend tried manshirt phones. all silent.


please suggest a simple process.

regards
ford
 

pakatil

Well-Known Member
#2
I do it manually every day. That download Bhav copy from NSE, import it to a Access DataBase and export days data to a CSV file. And import in to Ami from that CSV file.

Takes abt 5 mins max. :D
 
#3
hi pakatil

Thank you for the hints.
you said as it looks pretty simple.
--------------------------------------------
That download Bhav copy from NSE,
import it to a Access DataBase and
export days data to a CSV file. And import in to Ami from that CSV file.

Takes abt 5 mins max.
---------------------------------

I can find bhavcopy and download from nse website under reports area under equity

http://www.nseindia.com/products/content/equities/equities/homepage_eq.htm

there we find bhavcopy pr,bhavcopy csv, bhavcopy dbf
which file to pick up.
import the bhav copy to an access database
this is not clear

is this amibroker file?
export to a csv file-step is not clear to me

next import from csv to amibroker


If you can give a bit more detail i will try it.
regards
my doubt is
if nse is giving csv format is it better to use it?
or it becomes more complicated?
 

pakatil

Well-Known Member
#4
The csv file from NSE has lots of unwanted data. I wanted to prune and filter it. Hence I am using Access DB route.

Hope you can manage straight import to Ami......:D
 

Biswajit Das

Well-Known Member
#7
Hi friends

A friend of mine with not much computer exposure wanted eod stock data from nse.

Can somebody give some hints please
I heard the hemen s tool is giving trouble and data goes missing etc.

Suppose I plan to tell my friend
1 download bhavcopy
2.unzip
3 how can he import the data into Amibroker daily?
any software tool is ok to pay reasonable fees.

I wanted to recommend manshirt but they never respond.
my friend tried manshirt phones. all silent.


please suggest a simple process.

regards
ford
try this.....
http://www.volumedigger.com/Software/Data_Downloader.aspx
How to Import the data?
Follow the simple steps shown below the first time. Make sure that your current data base where you want to import the data is active, by checking the File-Database Settings options. Use the File Menu option to invoke the Import Wizard. Thereafter pick the file that you want to import as shown below (click any image to see in a larger size):
The very fist time, save the settings you are creating to the ASCII importer definitions as shown below. Next, choose the columns as shown below for creating the format definition. Amibroker automatically is prompting the data that it has found at the bottom of the window. Note that the Skip first lines is shown as 0. Change that to 1, as there is a header row in all the data files on this site. Click Next, and the data will get imported into your current database.




:clap::clap:
 

Similar threads