Importing Data into Spacejock Fcharts.
- Thread starter shrees
- Start date
firework123 said:
Thanks Shree. But I am not able to understand 5 a "backfill url". Would u pl help me?
Further, yahoo data download is a problem of late. So I would advice you to check out othere methods suggested here, by our other members.
Shrees.
vijaynair said:
HEllo,
I am using FCharts for last 4 months. This is an excellant software (much better than Wall Street Analyzer). However, the free version lack some good features of upgrades version i.e. PRO. The cost is very less and I am sure it is affordable.
About data,
There is a yahoo group (I am a member of this group) which puts EOD data fro BSE and NSE equities and futures and options on daily basis. You can download this EOD data (this is csv file format) and change the first line <date> to <DTMM/DD/YYYY> and load data using Import/import file option. This works well for me.
I have eod data for NSE and BSE for 2001 onwards loaded into FCharts. Also, a full list of symbols for BSE and NSE. (some latest entrants name need to be added, though symbol is there).
IF anyone need data from 1/1/2001 till June 2005 (Only equity data, NO FUTURES or OPTIONS), let me know. The data is not adjusted for Bonus/Splits etc. There is a provision in FCharts to do this as well as changing of the Ticker.
Happy investing.
Regards,
Vijay Nair
I am using FCharts for last 4 months. This is an excellant software (much better than Wall Street Analyzer). However, the free version lack some good features of upgrades version i.e. PRO. The cost is very less and I am sure it is affordable.
About data,
There is a yahoo group (I am a member of this group) which puts EOD data fro BSE and NSE equities and futures and options on daily basis. You can download this EOD data (this is csv file format) and change the first line <date> to <DTMM/DD/YYYY> and load data using Import/import file option. This works well for me.
I have eod data for NSE and BSE for 2001 onwards loaded into FCharts. Also, a full list of symbols for BSE and NSE. (some latest entrants name need to be added, though symbol is there).
IF anyone need data from 1/1/2001 till June 2005 (Only equity data, NO FUTURES or OPTIONS), let me know. The data is not adjusted for Bonus/Splits etc. There is a provision in FCharts to do this as well as changing of the Ticker.
Happy investing.
Regards,
Vijay Nair
I would be interested in the data. My email ID is [email protected]. Also can you give the name of the yahoo group?
Thanks
Shrees.
srisara said:
friends,
Please confirm can you all get the data from Yahoo! Otherwise there is an alternative which I am coming up with. In 4-5 days, I will give that a final shape as such it works with FCharts.
FCharts is a very good software, but provides only few indicators. Thats enough for a free Software isn't it?
Please confirm can you all get the data from Yahoo! Otherwise there is an alternative which I am coming up with. In 4-5 days, I will give that a final shape as such it works with FCharts.
FCharts is a very good software, but provides only few indicators. Thats enough for a free Software isn't it?
Hi!
I am not able to get the data from Yahoo! Please help!
when I give the URL
http://ichart.finance.yahoo.com/table.csv?s=@@@.NS&d=eMM&e=eDD&f=eYYYY&g=d&a=sMM&b=sDD&c=sYYYY&ignore=.csv
in explorer window it gives the error "The requested URL /table.csv was not found on this server."
I was through the step 7 but got stuck at step 8 ...........
[8.On the top big window, Right-click...this will give a pop-up with "Data" as one of the options. Click on it,and then on.."Download 12 months using back refill Url". Thats it. You are done. Repeat 7 & 8 for as many stocks as you want.]
When I right-click and get "data", it does not show this option of download 12 months.... at all??
what should I do ?
Hi shri
Thanks to your valuable posting.I think FCHART has made some changes
after your posting.They have moved download url and backfill url from settings
to export/import menu.But still there is a down load url at settings.If u can give any more explantion about this it will be helpfull.With the default url
EOD data for same day is downloading from yahoo.But historical data is not dowloading
thanking you
ashik1001
Thanks to your valuable posting.I think FCHART has made some changes
after your posting.They have moved download url and backfill url from settings
to export/import menu.But still there is a down load url at settings.If u can give any more explantion about this it will be helpfull.With the default url
EOD data for same day is downloading from yahoo.But historical data is not dowloading
thanking you
ashik1001
Finally, I managed to import data into FCharts. The URL in the FC built-in downloader connects to yahoo and data was not coming in from there any more. So I used another source recommended in this forum (http://trader.e2uhosting.net) and rebuilt the Backfill link to get data from there.
I am describing below the method I used successfully for NSE data:
First -- ticker symbols have to be 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 need 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 required 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 -- 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.net/scripts/historical.php?ex=nse&s=@@@&sm=01&sd=01&sy=2003&em=01&ed=19&ey=2006&f=yahoo&cl=average
- (make sure there are no blank spaces in the above url string after u paste it.)
This will get NSE historical data from 01/01/2003 to 01/19/2006 (specified start & end dates in mm/dd/yyyy format) from a site called trader.e2uhosting.net. Can change Start date & End date by choice.
e.g.
If need START date to be say: May-07-2003, need to make small changes in the abpve URL b4 using it:
&sm=01&sd=01&sy=2003 should be changed to:
&sm=05&sd=07&sy=2003
(EXPLANATION: sm = start month; sd = start date; sy = start year)
If need END date to be say: Oct-07-2005, u need to make small changes in the abpve URL b4 using it:
&em=01&ed=19&ey=2006 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 tickers with names starting with A to tickers with names starting with Z.
One can choose range as required.
e.g.
If one needs tickers from M to R, one can put those letters as first & last.
It is also possible to d/load data for even one company
e.g.
if data of just RELIANCE required, enter the ticker RELIANCE in both start letter & end letter boxes. These boxes will take max. 5 letters. RELIANCE will show as RELIA. That's fine.
step 6. "Ignore Ticker" box -- If need to exclude data for certain companies (from within the specified data range) from the download, u shud enter those tickers sepetated by spaces, in the "Ignore Ticker" box,
e.g. entering --
ALBK BEL ESCORTS MTNL-- will exclude data for these specified tickers from the download (u don't need to mention ignore tickers falling outside data range, because they are excluded any way.
e.g. if u r dloading from B to G no need to mention ALBK & MTNL)
step 7. Remaining boxes -- do nothing, ignore the dates as they are already built into the Backfill URL.
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 u hv specified and your 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 went ok, one can see the chart of that company. If satified one can proceed with more downloads.
NOW HISTORICAL DATA IS IMPORTED INTO FCHARTS. ONE CAN SEE THE CHARTS.
Every evening need to 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
Can also d/load from NSE using this URL:
http://www.nseindia.com/bhavcopy/BhavHandler?segment=0
The columns needed for import into FCharts are:
SYMBOL DATE OPEN HIGH LOW CLOSE VOLUME
This link gives the columns exactly as required:
http://trader.e2uhosting.net/bhavcopy.php?ex=nse
EOD data from NSE comes with these colomns:
SYMBOL SERIES OPEN HIGH LOW CLOSE LAST PREVCLOSE TOTTRDQTY TOTTRDVAL TIMESTAMP
Need 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 "Import Price Files" button (on "Import" tab)
step 3. Select the EOD data file to be imported (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. The programme has good help files and there's a good discussion forum on the Spacejock site. One can also write to the programme developer, Simon Haynes who is a very nice and helpful man. His email address is: [email protected]
Cheers.
I am describing below the method I used successfully for NSE data:
First -- ticker symbols have to be 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 need 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 required 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 -- 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.net/scripts/historical.php?ex=nse&s=@@@&sm=01&sd=01&sy=2003&em=01&ed=19&ey=2006&f=yahoo&cl=average
- (make sure there are no blank spaces in the above url string after u paste it.)
This will get NSE historical data from 01/01/2003 to 01/19/2006 (specified start & end dates in mm/dd/yyyy format) from a site called trader.e2uhosting.net. Can change Start date & End date by choice.
e.g.
If need START date to be say: May-07-2003, need to make small changes in the abpve URL b4 using it:
&sm=01&sd=01&sy=2003 should be changed to:
&sm=05&sd=07&sy=2003
(EXPLANATION: sm = start month; sd = start date; sy = start year)
If need END date to be say: Oct-07-2005, u need to make small changes in the abpve URL b4 using it:
&em=01&ed=19&ey=2006 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 tickers with names starting with A to tickers with names starting with Z.
One can choose range as required.
e.g.
If one needs tickers from M to R, one can put those letters as first & last.
It is also possible to d/load data for even one company
e.g.
if data of just RELIANCE required, enter the ticker RELIANCE in both start letter & end letter boxes. These boxes will take max. 5 letters. RELIANCE will show as RELIA. That's fine.
step 6. "Ignore Ticker" box -- If need to exclude data for certain companies (from within the specified data range) from the download, u shud enter those tickers sepetated by spaces, in the "Ignore Ticker" box,
e.g. entering --
ALBK BEL ESCORTS MTNL-- will exclude data for these specified tickers from the download (u don't need to mention ignore tickers falling outside data range, because they are excluded any way.
e.g. if u r dloading from B to G no need to mention ALBK & MTNL)
step 7. Remaining boxes -- do nothing, ignore the dates as they are already built into the Backfill URL.
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 u hv specified and your 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 went ok, one can see the chart of that company. If satified one can proceed with more downloads.
NOW HISTORICAL DATA IS IMPORTED INTO FCHARTS. ONE CAN SEE THE CHARTS.
Every evening need to 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
Can also d/load from NSE using this URL:
http://www.nseindia.com/bhavcopy/BhavHandler?segment=0
The columns needed for import into FCharts are:
SYMBOL DATE OPEN HIGH LOW CLOSE VOLUME
This link gives the columns exactly as required:
http://trader.e2uhosting.net/bhavcopy.php?ex=nse
EOD data from NSE comes with these colomns:
SYMBOL SERIES OPEN HIGH LOW CLOSE LAST PREVCLOSE TOTTRDQTY TOTTRDVAL TIMESTAMP
Need 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 "Import Price Files" button (on "Import" tab)
step 3. Select the EOD data file to be imported (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. The programme has good help files and there's a good discussion forum on the Spacejock site. One can also write to the programme developer, Simon Haynes who is a very nice and helpful man. His email address is: [email protected]
Cheers.
Last edited:
i m using Fcharts pro.i m not able to import the things.first i have downloaded nsetickers.txt and saved it as .csv files.
then went to import and export button->other->import company titles.
but i could not find company titles on Fcharts
then i could no t find backfil on import export tab.
i went to settings and pasted the above link on the other urls.
how can i download the datas pse help me
then went to import and export button->other->import company titles.
but i could not find company titles on Fcharts
then i could no t find backfil on import export tab.
i went to settings and pasted the above link on the other urls.
how can i download the datas pse help me
ksvelusamy said:
i m using Fcharts pro.i m not able to import the things.first i have downloaded nsetickers.txt and saved it as .csv files.
then went to import and export button->other->import company titles.
but i could not find company titles on Fcharts
then i could no t find backfil on import export tab.
i went to settings and pasted the above link on the other urls.
how can i download the datas pse help me
then went to import and export button->other->import company titles.
but i could not find company titles on Fcharts
then i could no t find backfil on import export tab.
i went to settings and pasted the above link on the other urls.
how can i download the datas pse help me
if u don't change the default url also it works. provided u do it by nameswise.
only problem is whether u trust yahoo data. many on this forum are not comfy with yahoo data. of course there is a matter of u r internet connection also.
ksvelusamy,
This is where u made a mistake:
"then went to import and export button->other->import company titles."
U SHUD DO:
Import Export button->Other->Import Tickers (NOT COMPANY TITLES)
If u have no Backfill tab, u probably have an older version of FCharts. Pl d/load the latest version from spacejock site. U shud then see all the right tabs.
Cheers.
This is where u made a mistake:
"then went to import and export button->other->import company titles."
U SHUD DO:
Import Export button->Other->Import Tickers (NOT COMPANY TITLES)
If u have no Backfill tab, u probably have an older version of FCharts. Pl d/load the latest version from spacejock site. U shud then see all the right tabs.
Cheers.
Last edited:
| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
| C | Data Importing Troubles | AmiBroker | 5 | |
| S | **URGENT Regarding importing the data of portfolio | Mutual Funds Discussion Forum | 5 | |
| A | Importing Google data into MT4 | Equities | 4 | |
| A | Error while importing IEOD Data in Ami.. | AmiBroker | 10 | |
|
Importing Data to MT4, any solution? | MetaTrader | 6 |
Similar threads
-
-
**URGENT Regarding importing the data of portfolio
- Started by shk161
- Replies: 5
-
-
-