XJO 0.86% 7,957.2 s&p/asx 200

I made an Excel spread sheet a while ago that figured out the...

  1. 5,311 Posts.
    I made an Excel spread sheet a while ago that figured out the dollar weighted value on each side of the fence and then worked out a dollar weighted strike price of each side as well. If you took the average or those two numbers you could watch where the market was going because it would move in a similar fashion to SPI discount/premium. I did plan to make it into a smallindex with the top 20 option stocks but never got that far. Not too hard if you have a little skill with excel and the appropriate data.

    I haven't used it in a while as I don't have live option data at the moment. Too busy trading futures.
 
watchlist Created with Sketch. Add XJO (ASX) to my watchlist
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.