Josh1
this things occur when i try to fetch data from Nest Trader. is is due to the fact that Now is closed and the excel sheet gives N/A in the LTP,LTQ,LTT and other columns.
is there any way to run NOW and then Nest3 after the closure of NOW(equity market)?
by the way Nest follder added in the Trusted location.
regards
sr
this things occur when i try to fetch data from Nest Trader. is is due to the fact that Now is closed and the excel sheet gives N/A in the LTP,LTQ,LTT and other columns.
is there any way to run NOW and then Nest3 after the closure of NOW(equity market)?
by the way Nest follder added in the Trusted location.
regards
sr
CellValue = Cells(r, c).Value '
You get N/A if you open excel sheet before opening NOW or Nest. Follow this order of opening 1. NOW or Nest 2. AmiBroker 3. Excel until excel starts opening AmiBroker automatically.
If you want to fetch quotes from Nest3 then you will have to link market watch of Nest3 with excel. I suppose you can link Nest the same way as you link NOW. RightClick in the Market watch of Nest and see if link to excel or snap to excel is available. If yes, keep the column order exactly the same as per excel and then paste the link into excel. You will get live quotes in excel. Do not try to get quotes from both NOW and NEST at the same time at present.. Once you get quotes in proper columns, you can click on Start to get them in AmiBroker. You can add to remove/replace scrips from original sheet.
If you are running Nest, delete the following line from the code. It is in StarTimer subroutine.
IsNOWRunning 'Check whether NOW is running. If not close down.