excel file to get rt data from nse/yahoo

#1
Hey everyone ...First of all m sorry for makin a new thread for my request..

I need sum help...about 4 months ago i came across an excel file to get rt data from nse website ...n transfer it to fcharts ....it was named live-data.xl or sumthing...

Sumhow m not able to find it anymore ....so i would b grateful if sumone could post it or any other excel/software for dat matter .... thanx in advance ...hope sumone helps me out
 
#2
You write ...
i came across an excel file to get rt data from nse website ...n transfer it to fcharts


Why bother when you can import the data from the NSE straight into FCharts with QuoteTracker? See other threads here.
 
Last edited:
#3
First of all ...Thax a lot FOR replyin...m afraid ...i might need a lil more help
"NSW straight into FCharts with QuoteTracker"?


Here is wat i did ....
got quote tracker...but cant find nethin similar to NSW in the "Select Qoute source" option..

P.S. i want to get rt data in fcharts ...dat toO free of cost:D
 
Last edited:
#5
yea ..got it ...actually had to update qoutetracker for NSE to appear in the list ...thanx for helpin ....
I read sumwhere that qoutetracker qoutes are delayed by 2-3 minutes .. is it true? ..
If u could direct me to an exel file for fetching data from nse/yahoo toh dat would b gr8...
 
#6
I'm not sure, but I suspect that most (if not all?) 'free sevices' may have a delay.

(Those who 'pay' for data probably have first look - and that allows Brokers/traders, that have automatic slgorithms for trading in place, to get maximum benefit? This may be a good enough reason for using QuoteTracker AND a trading broker with direct access to the NSE - if such exist.)

If you can find a 'tick by tick' site that actually lists the time the trades are done by the exchange, you can them compare them with your QT times?

Perhaps some of the Indian news services that provide financial information may be helpful in this? (I know of one (only) in Australia, but I don't know everything!)

On the Excel file question, why would the method of storing (or downloading) the data be any quicker?
 
#7
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 :D) 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
 
#9
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 :D) 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.

....
....


Prazy
Thank you for the useful info to extract thru QT. Actually for the last 3 years have been dnld data from ya h u o o.com into fcharts during market hours for all nse scrip.

Never tried it with quotetracker. I do not mind using QT but the problem is that i want quotes for all nse stocks in QT from nse. If you enter the scrip one by one in QT then you will have to enter more than thousand scrip nse codes. Any short cut way.

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

Tried
ichart.in.finance.yahoo.com

but none of the yahoo sites are working for dnld during mkt hours.
Will QT solve the problem

If so how can i do it with all scrips without manually entering the scrip names?:confused:

If I can get the working dnld link of yuahuo . kom then that would be ok for fcharts.

Thanks
bam
 
#10
Never tried it with quotetracker. I do not mind using QT but the problem is that i want quotes for all nse stocks in QT from nse. If you enter the scrip one by one in QT then you will have to enter more than thousand scrip nse codes. Any short cut way.
Yessiree!

RIGHT click on the code list and click 'Add', copy and paste a code column from an Excel file, and it is done.

(Note. There is a limit of around 2000(?) files. Want more? Open an second portfolio and repeat for the additional files).

Your computer wo'nt handle the volume for 60 second refreshes. Even backfilling takes a long time.