Mrs Bee,
thanks for clarifying that it's a Bill.
May I again ask which exchange rate that you will be wanting the members to use?
The Bid/MidMarket/Ask?
Which closing agency as well? Reuters, Bloomberg, Bank closing etc
Which closing time? 3pm Tokyo, 10am NY etc.
I apologize in advance for all the questions as without these, the 'right' answer can be dependent on what you will like the participants to use.
LOL you are trying to get an Excel up and at least price in the pull to redemption factor, aren't you? Yeah right that you are financial illiterate especially when you know that there is a spread on these things (the number is going to be the bid price), LOL! Only investment bankers and fund managers are proficient at putting together an Excel model to price it!
Actually you are right that it is not a Bill by US definition because it is more than one year old and is not a zero coupon discounted issue but it's a UK definition with anything less than 2 years on it regardless of whether it is a zero coupon discounted or coupon issue. I am going by Reuters London market close which is 4.30pm GMT (which is a flaw on my part because the competition closes at 11pm GMT ).
And currency is also Reuters but as you know forex market opens 24 hours a day so you can't look up your Reuters terminal to find that because the newspaper I am getting the numbers off probably don't have a fixed timing for it! In any case I can guarantee you are not going to be able to price the spot currency moves (at least accurately to the nearest 2 pips which can cause potentially at least 4% variance on the guess number) because UK current account deficit number is coming out this Wednesday!