excel file to get rt data from nse/yahoo

[Feel-me-knee]

FCharts is not downloading from yahoo site. Though this at times in a month or two happened once but it would be o.k. by changing the y a h u dnld site name which is as follows:

1. in.finance.yahoo.com
2. download.finance.yahoo.com
3. finance.yahoo.com

Yahoo frequently changes its download URL. (Like they delete email addresses that aren't used for a few months!)

You need to go to their finance page, search for a known scrip and copy the URL into FCharts.

 

[angshuman1348]

I use QuoteTracker (QT) for RT data and there is no delay. I have cross verified the data with NSE site for every 5seconds for abt an hour (painful job though ) before implementing QuoteTracker with Fcharts. But, your system should be good enough to balance the load, else Fcharts (FC) will be bit unresponsive while updating.

Here is how to do it.

1. Add all the scripts for which u need RT into QT portfolio, use F3 key to search script in QT.

2. Goto Preference menu in QT, navigate to misc. tab and enable API server settings and Default HTTP port is 16239 and socket port is 16240.

3. Save the settings and test the API service by typing the below address and also note down the offset period in QT.

http://127.0.0.1:16239/req?getLastQuote(*)

or

http://localhost:16239/req?getLastQuote(*)

check whether you get OK and the scripts that you have added in plain text.

4. Go to Fcharts click Intraday, select source as QuoteTracker and set the offset period based on your settings per QT. mostly it is 10.5 but it differs for different QT version.

5.Then click start to grab the RT data. you can cross check it on the intraday charts for the add scripts in Fcharts.

Let me know if this helps.

Thanks!

Regards,
Prazy

Hi Prazy ,

i searched in vain every bit of info for intraday using quotetracker with fcharts untill i stumbled into this thread , your info really helped me , thank you very much .

What i noticed is QT prices are not matching with my nest terminal , is it because of QT default settings or because my internet connection or slow processing by my pc.

thanks , bye.

 

[vgswift]

after enabling the webupdate from quote tracker, for intraday volume data, my observation is that intra day volume data is visibile, but my daily,weekly volume data is not visible, it just shows few long bars.

but which is not captured from quote tracker i can view all the volume data.

can some help.

 

[subir_dutta]

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?

 

[Feel-me-knee]

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.