Last Traded Price - Excel codes
-
Nero Tulip
- Posts: 686
- Joined: Wed Apr 15, 2009 5:29 pm
I've always wondered why the last traded price in excel changes after market settlement from the real LTPs, to what appear to be various codes (?).. The winner invariably shows a "2". But sometimes there are multiple "2"s.. then 3, some at 3.25... the others seem a bit more random higher than that, usually in the 100s.. what does it all mean? And can I use it to record results in some way ?
-
Nero Tulip
- Posts: 686
- Joined: Wed Apr 15, 2009 5:29 pm
Am I the only one to have noticed this? Just keen on knowing why or how it happens ? Why there are multiple post settlement LTPs of 2 on the sheet... so that perhaps I can find a use for it.
-
Nero Tulip
- Posts: 686
- Joined: Wed Apr 15, 2009 5:29 pm
Thanks Peter, horse racing is where I noticed it, winners market. Can't say I have definitely noticed it on other markets.