Recently, I've successfully been thru the exercise of setting up "FCharts" with Historical data & keeping it updated daily with EOD data for NSE. This is how I went about it:
First one needs to have the ticker symbols in place.
Method:
step 1. Save the attached file,
nsetickers.txt to the FCharts folder and
rename it as
nsetickers.csv This file contains almost all NSE equity tickers. If one wants to add to this list or reduce from this list one can save a copy of the above file with a new name e.g. "watchlist.csv", and edit it as per ones requirement and save.
step 2. Click "Import Export" button on left in the FCharts program.
step 3. Click "Import" tab ==> "Ticker Length" Min: -- enter
2 Max: -- enter
12
step 4. Click "Other" tab.
step 5. Click "Import Tickers" button.
step 6. Browse to the "FCharts" folder & Select the file,
nsetickers.csv OR
watchlist.csv (as desired) and click "Open".
NOW TICKERS ARE IMPORTED INTO FCHARTS.
Second one needs to
import historical data into FCharts.
Method:
step 1. Click "Import Export" button on left in the FCharts program.
step 2. Click "Backfill" tab.
step 3. Click "Edit URL" at the bottom -- This will highlight the download URL on top in blue.
step 4. Copy/Paste the following complete URL in its place:
http://trader.e2uhosting.com/scripts/history.php?s=@@@&sm=01&sd=01&sy=2002&em=09&ed=04&ey=2005&cl=average&f=yahoo
This will get NSE historical data from 01/01/2002 to 09/04/2005 (specified start & end dates in
mm/dd/yyyy format) from a site called trader.e2uhosting.com. One can change Start date & End date by choice.
e.g.
If one wants START date to be say:
May-07-2000, one needs to make small changes in the abpve URL b4 using it:
&sm=01&sd=01&sy=2002 should be changed to:
&sm=05&sd=07&sy=2000
(EXPLANATION -- sm = start month; sd = start date; sy = start year)
If one wants END date to be say:
Oct-07-2005, one needs to make small changes in the abpve URL b4 using it:
&em=09&ed=04&ey=2005 should be changed to:
&em=10&ed=07&ey=2005
(EXPLANATION -- em = end month; ed = end date; ey = end year)
step 5. In the box, "Start Letter" put
A. In the box, "End Letter" put
Z -- this will download historical data for all companies with names starting with
A to companies with names starting with
Z.
One can choose range as one wishes.
e.g.
If one needs companies from
M to
R, one can put those letters as first & last.
It is also possible to d/load data for even one company if required e.g. if one wants data of just RELIANCE, put the whole ticker --
RELIANCE -- in
both start letter & end letter
boxes. It will display just the first 5 letters - RELIA - but don't bother about that.
step 6. Ignore Ticker box -- If one wants to
exclude data for certain tickers (from within the specified data range) from the download, one shud enter those tickers seperated by spaces, in the "Ignore Ticker" box,
e.g. entering --
ALBK BEL ESCORTS MTNL -- will exclude data for these specified tickers from the download (one doesn't need to mention ignore tickers falling outside data range, because they are excluded any way. e.g. if one is downloading from B to G one need not mention ALBK & MTNL as these fall outside the range B to G)
step 7. Remaining boxes -- do nothing.
Step 8. Click
Start Download (
Internet shud be
connected b4 clicking.)
step 9. W..A..I..T.. for the download to complete.
Time taken will depend on the size of the data range specified and Internet connection speed. It cud take a few minutes to several hours. It makes sense to first do a
test by dloading data for
just one company. If everything goes ok, the chart of that company can be seen. If satified, one can proceed with more downloads preferably in bunches of 3 to 4 letters at a time.
NOW HISTORICAL DATA IS IMPORTED INTO FCHARTS. ONE SHUD BE ABLE TO SEE THE CHARTS.
Every evening download EOD data file, save it to a convenient location on the comp, and import it into FCharts to keep it updated.
I mostly use this source:
http://trader.e2uhosting.com/bhavcopy.php?ex=nse
One cn also d/load from NSE using this URL:
http://www.nseindia.com/bhavcopy/BhavHandler?segment=0
The columns needed for EOD data import into FCharts are:
SYMBOL DATE OPEN HIGH LOW CLOSE VOLUME
This link gives the columns exactly as required
http://trader.e2uhosting.com/bhavcopy.php?ex=nse
If u get EOD data from NSE it comes with these columns:
SYMBOL SERIES OPEN HIGH LOW CLOSE LAST PREVCLOSE TOTTRDQTY TOTTRDVAL TIMESTAMP
One needs to change 2 column heads and leave the rest as is.
CHANGE:
TOTTRDQTY to
VOLUME
TIMESTAMP to
DATE
Now the file can be used for importing EOD data into FCharts.
EOD Data Import method:
step 1. Click "Import Export" button on left in the FCharts program.
step 2. Click "Price Files" button
step 3. Select the EOD data file u want to import (usually of current day) and click "Open"
NOW FCHARTS IS UPDATED WITH CURRENT DAY'S DATA.
Once thru with the basics many more questions will arise in areas such as selecting views, using indicators, setting indicator parameters, writing queries, intraday datafeeds and scans, etc. The program has good help files and a good discussion forum on the Spacejock site. One can also write to the program developer, Simon Haynes who is a very nice and helpful man. His email address is:
[email protected]
Hope all this makes a lot of people happy.
Use at your risk.
Cheers.
pgd
