hi i tried using Fcharts but could not set it up step by step.the main problem was how to import data.secondly some scrips show that "EOD data not available".can anyone throw light on this?in details about how to set up Fcharts?
Perhaps this is what you want?
__________________________
Q. Can you tell me the way in which importing from Excel works with live data, E.g.. Esignal in America have a facility to export live dynamic intraday data straight into Excel, so how does this work.
A. This is the procedure:
Your data must be on sequential rows in the spreadsheet. You can have anything you like above the start of the data, but once you get to the bit you want FCPro to read you will need something like this...:
TICKER, DATE, TIME, TRADE
.. repeated for as many prices as you want FCPro to read in. It will stop as soon as it comes across a 'ticker' cell with nothing in it.
e.g.
ANZ 13/09/2002 11:40 0.25 15600
ANZ 13/09/2002 11:50 0.26 15600
ANZ 13/09/2002 12:00 0.27 15600
ANZ 13/09/2002 12:10 0.28 15600
ANZ 13/09/2002 12:20 0.29 15600
ANZ 13/09/2002 12:30 0.3 15600
and so on.
With a setup like the above, you'd specify Col. A as ticker, Col. B as date, Col. C as time, Col. D as price and Col. E as volume. If the first row is on row 12 in the spreadsheet, then you'd put 12 as the first row in FCPro.
You can also have a combined date/time field (A bit hard to show, but the date and time are now in the same column):
ANZ 13/09/2002 11:40 0.25 15600
ANZ 13/09/2002 11:50 0.26 15600
ANZ 13/09/2002 12:00 0.27 15600
ANZ 13/09/2002 12:10 0.28 15600
ANZ 13/09/2002 12:20 0.29 15600
ANZ 13/09/2002 12:30 0.3 15600
Ticker is A, date is B, Time is left blank, price is C and volume is D
Every x seconds, the program will re-read the rows of data. If there are more added below, it'll read them in too. If you're typing data and you're half-way through a line when the program reads the data, ugh. Therefore it's best to type the data in but leave the ticker field empty until the very last.