ES_FUT_200706_GLOBEX_USD YM_FUT_200706_ECBOT_USD Try those. You'll also need to enter your USERID. - Spydertrader P.S. I am no expert.
ES_FUT_200706_GLOBEX_USD YM_FUT_200706_ECBOT_USD This also works for any IB ticker: SGXNK_FUT_200706_SGX_JPY You should have already allowed for DDE and ActiveX under the Configure-API menu on TWS. I assume you do fill in cell B2 with your userid (the same as the login for TWS) and have just blanked it out for posting here? Open the worksheet with macros disabled, don't update values, make these changes then save, then reload and let the macros run and allow updates. The first time you load with new tickers leave it alone for at least 5 minutes to run through one whole bar (the next time you open it should work fine).
heads up: http://www.bloomberg.com/markets/ecalendar/index.html Consumer Confidence 10:00ET Existing Home Sales 10:00ET
And if that doesn't work (I still got the myid message), try making the changes, then cut and paste the entire sheet into a new workspace, close it and then reopen it.
I have a different question regarding Mak's tool - How does it calculate the fairvalue offset for the str/squ? It doesn't seem to correspond to the QCharts histogram ...
Hi all, I was looking at a longer trendline / channel on the ES 240 min globex all sessions. The last few moves up and down it has not quite touched the trendline. When you view it on the 240 min it looks like it is very very close but on a 5 - 15 min could be 5 points away. Does it still count as a FTT if it is very close to not touching ? ie: does an FTT have to be atleast like 25% or so away from the trendline to be considered a true FTT ? Cheers