Realtime data NOW,ODIN,TradeTiger,Google,Yahoo > AmiBroker, Fcharts, Qtstalker

[josh1]

I am very much felt sweet in the mouth, upon your quick and prompt response.

in nest itself means, in the market watch when right clicked a popup menu opens, in that menu there is a link to excel sheet just like open link to excel to view data into nest excel sheet as it is in market watch. can we use this one for all linkings to view charts in other charting softwares.

Yes. Link to Excel is to be used for linking stocks to Nest sheet in RTNest. You are asking this question because you have not read the Readme file,

 

[shahss71]

thank you for your reply sir, yesterday i have added new scrip in RTD sheet , I have installed ramdisk and working fine , today i have checked only fewer scrips are updating in mycsvnest


View attachment 18570

View attachment 18571


nifty-f1 usdinr-f1 is not updating in amibroker today, though it is placed at A8,A9 in excel sheet , following scrips are updating after some time
please help

13/02/2013,ADANIENT_F1,10:27:05,230,0,7030000,ADANIENT,
13/02/2013,AXISBANK_F1,10:27:27,1484.35,0,5037000,AXISBANK,
13/02/2013,BANKINDIA_F1,10:27:25,344.7,0,3757000,BANKINDIA,
13/02/2013,BIOCON_F1,10:26:49,287.7,0,3154000,BIOCON,
13/02/2013,BPCL_F1,10:27:37,411,0,4735000,BPCL,
13/02/2013,CAIRN_F1,10:27:44,319.75,0,12991000,CAIRN,
13/02/2013,CANBK_F1,10:27:34,453.55,0,2349000,CANBK,
13/02/2013,COALINDIA_F1,10:27:11,344.15,0,4511000,COALINDIA,
13/02/2013,GAIL_F1,10:25:01,331.5,0,2414000,GAIL,
13/02/2013,GUJFLUORO_F1,10:26:28,277.9,0,2344000,GUJFLUORO,
13/02/2013,HINDPETRO_F1,10:27:24,325.45,0,8894000,HINDPETRO,
13/02/2013,HINDUNILVR_F1,10:27:44,458,0,6201000,HINDUNILVR,
13/02/2013,IOC_F1,10:27:53,322.25,0,3083000,IOC,
13/02/2013,JINDALSTEL_F1,10:27:55,390.2,1000,6129000,JINDALSTEL,
13/02/2013,KOTAKBANK_F1,10:27:50,672.3,0,2070000,KOTAKBANK,
13/02/2013,LUPIN_F1,10:27:33,603.4,0,1898000,LUPIN,
13/02/2013,ONGC_F1,10:27:55,324.8,2000,9699000,ONGC,
13/02/2013,ORIENTBANK_F1,10:27:06,310.1,0,1909000,ORIENTBANK,
13/02/2013,PNB_F1,10:27:40,870.7,0,4080000,PNB,
13/02/2013,RANBAXY_F1,10:27:57,429.15,500,6891000,RANBAXY,
13/02/2013,RAYMOND_F1,10:27:56,367.3,1000,5662000,RAYMOND,
13/02/2013,RELINFRA_F1,10:27:38,495.45,0,5475000,RELINFRA,
13/02/2013,SIEMENS_F1,10:22:54,620.1,0,963000,SIEMENS,
13/02/2013,SUNPHARMA_F1,10:27:50,776.45,0,2535500,SUNPHARMA,
13/02/2013,TITAN_F1,10:26:52,273.7,0,4056000,TITAN,
13/02/2013,UNIONBANK_F1,10:27:55,238.4,2000,3910000,UNIONBANK,
13/02/2013,YESBANK_F1,10:27:51,524.2,0,5920000,YESBANK,
13/02/2013,GRAPHITE-EQ,10:25:50,84,0,0,GRAPHITE,

 

[josh1]

thank you for your reply sir, yesterday i have added new scrip in RTD sheet , I have installed ramdisk and working fine , today i have checked only fewer scrips are updating in mycsvnest

nifty-f1 usdinr-f1 is not updating in amibroker today, though it is placed at A8,A9 in excel sheet , following scrips are updating after some time
please help

Shahss

Pl. Check messages in Nest. Update for some scrips may not happen if you get messages like this.
13-02-2013,09:12:07 -- Subscription Failed for NHPC13FEB30CE from Satish-MarketWatchView. Reason:No of Subscription Exceed 100

Your Nifty spot is getting split into two lines, even that will not be updated. Though you seem to have configured properly. I will have to check that through Teamviewer.

 

[shahss71]

no such message rates are updating in diff. interval in diff scrips and some scrips are not updating at all,team viewer id : 217 311 113 please tell me at what time u will be available

 

[josh1]

team viewer id : 217 311 113 please tell me at what time u will be available

I am online. PM your PWD

 

[shahss71]

yes sir : 3710

 

[nareshb1]

Dear Josh1

Thank u . Now quotes are updating in AB. The only change I made in RTg3.format file is changing DMY to MDY .This is same format as csv file updating in the RT folder.

 

[josh1]

Dear Josh1

Thank u . Now quotes are updating in AB. The only change I made in RTg3.format file is changing DMY to MDY .This is same format as csv file updating in the RT folder.

:thumb: Happy Trading.
Actually I had taken care of Date format in RTNest. It should have been in DMY format in CSV file.

 

[shahss71]

hello joshji, rtnest working perfect thanx again,
I found very easy way for backfill, I have made some modification in rtnest excel sheet for excact symbol for NSE ,
if i link nest link the symbol will be RELIANCE-EQ, I used following formula :
=IF(RIGHT(RTD!A13,3)="FUT",RTD!F13&"_F1",IF(RIGHT(RTD!A13,3)="-EQ",RTD!F13&"",RTD!A13))
and now the symbol will exact match of NSE symbol i.e. RELIANCE,
after that using Joydeep Mitra DataDownloader,
1.> format the intraday download as per nest column along with date i.e. dd/MM/yyyy , 2.> edit google intraday.txt add the scrips [symbol will be exact as per NSE along with ,NSE i.e. reliance,nse ,
3.> download intraday data from ->INTRADAY->GOOGLE ,
4.> import all txt files in amibroker using import wizard
BINGO all scrips backfill done in seconds,

thanx again for this wonderful excel sheets.

 

[shahss71]

Only one query left joshji,
following are screenshots , In datasheet1 rates are updating exact one minute data
but using RTNEST, In datasheet2 rates are updating every five second.
problem with 5 sec updating is , it gives frequent buy/sale signal even in 15 min chart. The query is, can i feed the data for exact one min. like datasheet1 ????