Real Time Data Now / Nest Trader to Amibroker, Fcharts

S

Silentshadow

Well-Known Member
#882
#882
Screenshot from which are you ask for bud? - Had posted most of the relevant ones earlier. Please let know if you are looking for anything specific

I did check the troubleshooting guide which states multiple instances of the excel must be open. Well in my case I have none open, also check the processes running on the system couldn't find anything related to MS Office excel running.

Any other step I could carry out to trouble shoot this problem?

josh1 said:
Screenshot required. Error 1004 is explained in Troubleshooting in help file
Click to expand...
 
LOVEENAJYOTHI

LOVEENAJYOTHI

Well-Known Member
#887
#887
sr114 said:
Data from the NEST Plus data


format file definition for Nest Plus data import



go thru the images specially the 2nd image and define ur format file for ascii import

rgds
Click to expand...

sir SR114,

Its NOT abt Nest+ DataTable --> CSV files frm Nest DataTable are imported smoothly thru RTD.format ---> NO problem there.

Its abt VWAP Stats Table --->but its my bad coz as i noticed today during market hours, the problem is not with the format(except a small fix, $ NoQuotes 1)

The problem is in the VWAP table itself---> values therein r so weird---> pls read my next post

Thnk u Regards
 
LOVEENAJYOTHI

LOVEENAJYOTHI

Well-Known Member
#888
#888
josh1 said:
@LOVEENJYOTI,

You are mixing everything. Do your homework first. Read the help files for RTD1.30 and also Amibroker guide
Click to expand...

Sir Josh,Sir Sr, Sir TB,

Abt Mixing,

RT data thru Excel Utility -----> more Control
------------------------- + ------------------------
Backfill thru RTD 1.25/1.30 -->CSV files --->Import ASCII -->RTD-Renamed.format--->more Convenient & Control

Abt homework----> Yes it was my bad, problem has nothing to do with the format.

Abt Read Help/Guide files---->Read n ReRead ---> but not relevant here coz the focus of the problem has shifted now.

THE PROBLEM :
when sir TB suggested that VWAP stats Table is more reliable, tried to BackFill from VWAP Table, BUT The Table/CSV Values r so weird it totally upset my DB.
Posted here sample table contents (17:30:00 to 17:38:00) for ur kind advice.

CRUDEOIL1,20160215,17:30:00,2268.00,2270.00,2268.00,2268.00,8200,
CRUDEOIL1,20160215,17:31:00,2268.00,2270.00,2268.00,2269.00,10600,
CRUDEOIL1,20160215,17:32:00,2269.00,2274.00,2269.00,2274.00,30200,
CRUDEOIL1,20160215,17:33:00,2274.00,2276.00,2273.00,2273.00,30700,
CRUDEOIL1,20160215,17:34:00,2273.00,2275.00,2273.00,2273.00,10800,
CRUDEOIL1,20160215,17:35:00,2274.00,2276.00,2273.00,2276.00,21200,
CRUDEOIL1,20160215,17:36:00,2276.00,2276.00,2273.00,2275.00,8600,
CRUDEOIL1,20160215,17:37:00,2275.00,2276.00,2274.00,2274.00,9100,
CRUDEOIL1,20160215,17:38:00,2274.00,2276.00,2273.00,2276.00,15000,
CRUDEOIL1,20160215,17:30:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:31:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:32:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:33:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:34:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:35:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:36:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:37:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:38:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:30:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:31:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:32:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:33:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:34:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:35:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:36:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:37:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:38:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:30:00,2252.00,2252.00,2250.00,2251.00,43100,
CRUDEOIL1,20160215,17:31:00,2251.00,2255.00,2250.00,2254.00,95200,
CRUDEOIL1,20160215,17:32:00,2254.00,2256.00,2253.00,2254.00,22000,
CRUDEOIL1,20160215,17:33:00,2254.00,2254.00,2252.00,2252.00,18600,
CRUDEOIL1,20160215,17:34:00,2252.00,2253.00,2251.00,2253.00,14700,
CRUDEOIL1,20160215,17:35:00,2253.00,2253.00,2246.00,2246.00,80200,
CRUDEOIL1,20160215,17:36:00,2246.00,2247.00,2245.00,2246.00,69100,
CRUDEOIL1,20160215,17:37:00,2246.00,2247.00,2239.00,2241.00,131000,
CRUDEOIL1,20160215,17:38:00,2241.00,2242.00,2238.00,2239.00,50700,
CRUDEOIL1,20160215,17:30:00,2090.00,2090.00,2086.00,2087.00,37000,
CRUDEOIL1,20160215,17:31:00,2087.00,2088.00,2084.00,2085.00,40000,
CRUDEOIL1,20160215,17:32:00,2085.00,2085.00,2083.00,2085.00,46200,
CRUDEOIL1,20160215,17:33:00,2085.00,2086.00,2083.00,2085.00,21300,
CRUDEOIL1,20160215,17:34:00,2085.00,2086.00,2084.00,2086.00,15900,
CRUDEOIL1,20160215,17:35:00,2086.00,2090.00,2086.00,2088.00,41700,
CRUDEOIL1,20160215,17:36:00,2089.00,2090.00,2088.00,2089.00,19500,
CRUDEOIL1,20160215,17:37:00,2088.00,2091.00,2088.00,2091.00,15600,
CRUDEOIL1,20160215,17:38:00,2091.00,2091.00,2090.00,2090.00,27000,
CRUDEOIL1,20160215,17:30:00,2086.00,2086.00,2084.00,2085.00,8500,
CRUDEOIL1,20160215,17:31:00,2085.00,2085.00,2083.00,2083.00,4700,
CRUDEOIL1,20160215,17:32:00,2083.00,2083.00,2081.00,2082.00,10600,
CRUDEOIL1,20160215,17:33:00,2083.00,2084.00,2082.00,2084.00,6900,
CRUDEOIL1,20160215,17:34:00,2084.00,2092.00,2084.00,2090.00,65100,
CRUDEOIL1,20160215,17:35:00,2090.00,2093.00,2090.00,2092.00,22800,
CRUDEOIL1,20160215,17:36:00,2092.00,2094.00,2091.00,2093.00,43700,
CRUDEOIL1,20160215,17:37:00,2093.00,2099.00,2093.00,2096.00,181300,
CRUDEOIL1,20160215,17:38:00,2096.00,2098.00,2095.00,2096.00,39500,
CRUDEOIL1,20160215,17:30:00,2194.00,2196.00,2194.00,2196.00,20800,
CRUDEOIL1,20160215,17:31:00,2196.00,2199.00,2195.00,2197.00,36700,
CRUDEOIL1,20160215,17:32:00,2197.00,2203.00,2196.00,2201.00,60000,
CRUDEOIL1,20160215,17:33:00,2201.00,2202.00,2199.00,2202.00,16900,
CRUDEOIL1,20160215,17:34:00,2202.00,2204.00,2201.00,2204.00,24400,
CRUDEOIL1,20160215,17:35:00,2204.00,2206.00,2203.00,2203.00,33000,
CRUDEOIL1,20160215,17:36:00,2203.00,2206.00,2203.00,2204.00,25600,
CRUDEOIL1,20160215,17:37:00,2204.00,2206.00,2203.00,2204.00,24500,
CRUDEOIL1,20160215,17:38:00,2204.00,2205.00,2203.00,2203.00,13300,
CRUDEOIL1,20160215,17:30:00,2174.00,2174.00,2172.00,2174.00,15900,
CRUDEOIL1,20160215,17:31:00,2174.00,2175.00,2173.00,2174.00,14300,
CRUDEOIL1,20160215,17:32:00,2174.00,2175.00,2172.00,2173.00,8200,
CRUDEOIL1,20160215,17:33:00,2173.00,2174.00,2171.00,2173.00,23300,
CRUDEOIL1,20160215,17:34:00,2173.00,2176.00,2171.00,2175.00,24000,
CRUDEOIL1,20160215,17:35:00,2175.00,2177.00,2175.00,2177.00,11300,
CRUDEOIL1,20160215,17:36:00,2177.00,2177.00,2175.00,2175.00,12300,
CRUDEOIL1,20160215,17:37:00,2175.00,2176.00,2174.00,2175.00,11400,
CRUDEOIL1,20160215,17:38:00,2175.00,2177.00,2174.00,2176.00,4400,
CRUDEOIL1,20160215,17:30:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:31:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:32:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:33:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:34:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:35:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:36:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:37:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:38:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:30:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:31:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:32:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:33:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:34:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:35:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:36:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:37:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:38:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:30:00,2063.00,2063.00,2060.00,2062.00,12500,
CRUDEOIL1,20160215,17:31:00,2062.00,2062.00,2059.00,2059.00,16500,
CRUDEOIL1,20160215,17:32:00,2059.00,2060.00,2058.00,2060.00,14300,
CRUDEOIL1,20160215,17:33:00,2060.00,2061.00,2058.00,2058.00,13800,
CRUDEOIL1,20160215,17:34:00,2058.00,2058.00,2055.00,2056.00,46100,
CRUDEOIL1,20160215,17:35:00,2056.00,2058.00,2055.00,2058.00,23700,
CRUDEOIL1,20160215,17:36:00,2057.00,2057.00,2054.00,2055.00,58900,
CRUDEOIL1,20160215,17:37:00,2055.00,2056.00,2054.00,2054.00,32900,
CRUDEOIL1,20160215,17:38:00,2054.00,2055.00,2052.00,2053.00,87600,
CRUDEOIL1,20160215,17:30:00,2065.00,2067.00,2064.00,2066.00,8700,
CRUDEOIL1,20160215,17:31:00,2066.00,2067.00,2065.00,2066.00,7400,
CRUDEOIL1,20160215,17:32:00,2066.00,2068.00,2065.00,2067.00,10900,
CRUDEOIL1,20160215,17:33:00,2067.00,2068.00,2064.00,2064.00,14800,
CRUDEOIL1,20160215,17:34:00,2064.00,2066.00,2064.00,2064.00,7800,
CRUDEOIL1,20160215,17:35:00,2064.00,2065.00,2063.00,2064.00,9100,
CRUDEOIL1,20160215,17:36:00,2064.00,2065.00,2060.00,2061.00,23500,
CRUDEOIL1,20160215,17:37:00,2061.00,2062.00,2060.00,2061.00,13300,
CRUDEOIL1,20160215,17:38:00,2061.00,2062.00,2057.00,2058.00,54100,
CRUDEOIL1,20160215,17:30:00,1937.00,1939.00,1935.00,1935.00,17400,
CRUDEOIL1,20160215,17:31:00,1935.00,1937.00,1935.00,1935.00,25200,
CRUDEOIL1,20160215,17:32:00,1936.00,1938.00,1935.00,1937.00,23900,
CRUDEOIL1,20160215,17:33:00,1937.00,1941.00,1935.00,1941.00,60700,
CRUDEOIL1,20160215,17:34:00,1940.00,1942.00,1939.00,1941.00,40000,
CRUDEOIL1,20160215,17:35:00,1941.00,1946.00,1940.00,1944.00,33500,
CRUDEOIL1,20160215,17:36:00,1944.00,1944.00,1942.00,1944.00,17200,
CRUDEOIL1,20160215,17:37:00,1944.00,1944.00,1943.00,1944.00,8900,
CRUDEOIL1,20160215,17:38:00,1944.00,1945.00,1943.00,1943.00,11000,
CRUDEOIL1,20160215,17:30:00,1816.00,1818.00,1814.00,1815.00,24000,
CRUDEOIL1,20160215,17:31:00,1815.00,1816.00,1813.00,1815.00,14700,
CRUDEOIL1,20160215,17:32:00,1815.00,1815.00,1811.00,1814.00,43500,
CRUDEOIL1,20160215,17:33:00,1814.00,1816.00,1813.00,1815.00,34100,
CRUDEOIL1,20160215,17:34:00,1815.00,1816.00,1813.00,1814.00,13700,
CRUDEOIL1,20160215,17:35:00,1814.00,1815.00,1813.00,1815.00,16100,
CRUDEOIL1,20160215,17:36:00,1815.00,1818.00,1814.00,1817.00,19900,
CRUDEOIL1,20160215,17:37:00,1817.00,1820.00,1816.00,1819.00,24800,
CRUDEOIL1,20160215,17:38:00,1819.00,1821.00,1818.00,1819.00,36300,
CRUDEOIL1,20160215,17:30:00,1887.00,1888.00,1886.00,1886.00,11000,
CRUDEOIL1,20160215,17:31:00,1886.00,1887.00,1883.00,1884.00,20800,
CRUDEOIL1,20160215,17:32:00,1884.00,1885.00,1881.00,1881.00,31900,
CRUDEOIL1,20160215,17:33:00,1881.00,1884.00,1881.00,1881.00,34300,
CRUDEOIL1,20160215,17:34:00,1881.00,1883.00,1880.00,1883.00,23300,
CRUDEOIL1,20160215,17:35:00,1883.00,1885.00,1883.00,1884.00,9300,
CRUDEOIL1,20160215,17:36:00,1884.00,1885.00,1883.00,1885.00,4400,
CRUDEOIL1,20160215,17:37:00,1885.00,1886.00,1884.00,1885.00,13200,
CRUDEOIL1,20160215,17:38:00,1885.00,1885.00,1883.00,1883.00,9900,
CRUDEOIL1,20160215,17:30:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:31:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:32:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:33:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:34:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:35:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:36:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:37:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:38:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:30:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:31:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:32:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:33:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:34:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:35:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:36:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:37:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:38:00,0.00,0.00,0.00,0.00,0,
CRUDEOIL1,20160215,17:30:00,2039.00,2040.00,2038.00,2038.00,7600,
CRUDEOIL1,20160215,17:31:00,2038.00,2040.00,2037.00,2040.00,21700,
CRUDEOIL1,20160215,17:32:00,2040.00,2041.00,2039.00,2040.00,8000,
CRUDEOIL1,20160215,17:33:00,2040.00,2040.00,2038.00,2039.00,5800,
CRUDEOIL1,20160215,17:34:00,2038.00,2039.00,2038.00,2039.00,9000,
CRUDEOIL1,20160215,17:35:00,2038.00,2039.00,2038.00,2039.00,4200,
CRUDEOIL1,20160215,17:36:00,2039.00,2040.00,2037.00,2039.00,12500,
CRUDEOIL1,20160215,17:37:00,2039.00,2039.00,2037.00,2038.00,9100,
CRUDEOIL1,20160215,17:38:00,2038.00,2039.00,2037.00,2039.00,13000,

Why are there so many illegit values ?
wht am i doing wrong

Ur kind guidance is humbly solicited.

Thnk u Regards
 
josh1

josh1

Well-Known Member
#889
#889
@loveenajyoti

What you have shown is not the data from Vwap. How did crude oil become crudeoil1?
Select any scrip and press ctrl+shift+H. Vwap table will open.

Rtd1.30 does it automatically and directly imports data from Vwap into Amibroker. Read help files that came with excel app to understand better
 
LOVEENAJYOTHI

LOVEENAJYOTHI

Well-Known Member
#890
#890
josh1 said:
@loveenajyoti

What you have shown is not the data from Vwap. How did crude oil become crudeoil1?
Select any scrip and press ctrl+shift+H. Vwap table will open.

Rtd1.30 does it automatically and directly imports data from Vwap into Amibroker. Read help files that came with excel app to understand better
Click to expand...

It was the content of CSV file Generated frm VWAP Table thru RTD1.25.

Posted below the image of VWAP table ----Pls note the values --they r NOT LEGIT

 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
A Real time data feed software with bacfill from Nest trader Software 2
E need realtime datafeed from nest to mt4 Intraday 6
test123 GUi-Based Free RealTime Data NOW NEST 2 AmiBroker, Fcharts Intraday 49
G How to Transfer realtime data from Now/Nestrader to Amiboker ? Introductions 4
josh1 Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts MS Intraday 2305

Similar threads