Free stock charting software

#21
pkjha30 said:
Hi

I have used srisara's downloader to download data for 5 years for all stocks and it took some time to do it (about 88 MB).It is an excellent tool. There is one software called Aptistock available at http://www.aptistock.com/download.htm .Total download size is 3.1 MB and latest version is AptiStock-1.01. It can download data from NSE and give technical analysis.Various opyions are given. It is totally free of cost.It needs some improvement. Feedback can be posted to their website. I found it quite useful and may be other members can also evaluate it and post their experience.

Thanks
Pankaj
thanks for the compliments.. it encourages me more... :)

Satya
 

rpc

Active Member
#22
hi pgd
I tried downloading data the way you described it.But could not see charts.When I clicked download button I could see company name adnd segment 1,2,3... etc on screen but after clicking exit button no chart could be seen though I saw company name open,high, low etc on top in green color but no chart.Pls Help
Thanx
RPC
 
#23
Re: FCharts setup with HISTORICAL & EOD data

Hi..
i have followed all your steps and sucessfully done eveything but still ....the charts are not showing up in the screen...it only shows the respective opening and closing prices of the stock...there are no charts on display...

What do i do???

Awaiting your reply
Thanks
Anshul
 
#25
Re: FCharts setup with HISTORICAL & EOD data

hi,

i am working from behind a firewall and i really dont understand this technology stuff, it is not allowing me to download the ticker file, if u can plz just send across the attachment to [email protected] i'll be greatful.


thanks
chirag.
 
#26
Re: FCharts setup with HISTORICAL & EOD data

pgd said:
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
dear PGD
than u for sending important information for charting. i have done whatever u have described as per the instruction. but on clicking the show botton i m not getting the charts only thing i m getting is the one day price movement bar. moreover the link http://trader.e2uhosting.com/bhavcopy.php?ex=nse shows only 29 nov 05 bhav on requesting for 30 nov 05 it gives regeret msg. pl. help
thanking u . bhattu
 
#27
Re: FCharts setup with HISTORICAL & EOD data

pgd said:
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
sir
bhattu once agiain
alternativelly u can talk to me on [email protected] or [email protected]
waiting for your early reply.
pl help.
thanks
 
#28
Re: FCharts setup with HISTORICAL & EOD data

pgd said:
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

Hi PGD,

Thanks a lot for the info.

I am facing some problems though.

The existing link that you have mentioned has changed to http://trader.e2uhosting.net/scripts/historical.php?&ex=nse&s=@@@&sm=01&sd=01&sy=2002&em=09&ed=04&ey=2005&cl=average&f=yahoo i.e. .COM has become .NET, HISTORY HAS BEOME HISTORICAL and one needs to put exchange name as nse.

Now whenever I am using the link in f-charts to import data I am only able to import the header only and nothing else.

I tried to do some trial and error and found that with the above mentioned link if I replace @@@ in f-charts to with some specific ticker say, ABB I am not able to download anything and I get an error (like this http://trader.e2uhosting.net/scripts/historical.php?&ex=nse&s=ABB&sm=01&sd=01&sy=2002&em=09&ed=04&ey=2005&cl=average&f=yahoo ) , which is quite understandable considering the progarmming of f-charts but when I am using this link in my browser I do get data for the specific periods for the mentioned script. The problem is that practically it would be very difficult to do the same for say 250-300 stocks at least (to do some analysis by oneself).

Is there any other way possible to import the data to f-charts?

Help would really be appreciated.

Regards,
Sanjoy
 
#29
Re: FCharts setup with HISTORICAL & EOD data

Hi,
I am able to download the data but import fails as data download filse does not have SYMBOL filed....

Date,Open,High,Low,Close,Volume
8-Dec-05,417.15,425.00,417.15,420.05,4124

Also the download takes place with url :
http://trader.e2uhosting.net/script...=2000&em=12&ed=31&ey=2005&f=metastock&cl=last


a little deviation from one you said.

Neways can you please help me in back fill import. I have downloaded data since 1st Jan 2005.

I am attaching a file for you to see the downloaded data.


Thx

Rajesh

pgd said:
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
 

Similar threads