Hi. Ive searched far and wide for an answer to this, but I cant find it.
I am trying to call up the XJO options in Hoadleys excell sheet.
The only way I can call up the actual index price is with the code ^AXJO. However I dont really care about the price, as I can put that in manually. What Im after is the correct code to call up the index options chain and insert it into the sheet.
I dont have an IB account (though seriously thinking about setting one up), so the only feed I have access to is the ASX.
I fear that the probelm might be the ASX site itself. You cant even call up the index itself ('XJO not found'), without going through the menus - hopeless.
Does anyone know the correct code I should use to get the index options into Hoadley. It should work - even OptionsOracle works pulls in the chain and correct index level, using ^XJO - and thats free, unlike Hoadleys !
Thanks for any help