jagomart
digital resources
picture1_Excel Sheet Download 31030 | Treasury Futures Conversion Factor Calculator


 262x       Filetype XLS       File size 0.12 MB       Source: www.cmegroup.com


File: Excel Sheet Download 31030 | Treasury Futures Conversion Factor Calculator
sheet 1 conversion factor formula sheet 2 2year notes 2year us treasury note futures conversion factor calculator dgro50 enter as decimal 1 select coupon remaining maturity from first day of ...

icon picture XLS Filetype Excel XLS | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Conversion Factor Formula


Sheet 2: 2-Year Notes
2-YEAR U.S. TREASURY NOTE FUTURES CONVERSION FACTOR CALCULATOR








DGRO50: Enter as decimal. 1.) Select Coupon
Remaining Maturity from First Day of Delivery Month (Unrounded)
Year 1



Month 11
DGRO50: Insert. 2.) Select Maturity Date

Day 29





Month
n 1
z 11



v 5
Day


a 0.975669



b 0.000625
Year
c 0.915142
d 0.010607





DGRO50: Insert. 3.) Select First Day of Delivery Month

Futures Expiry Month December 2009



Conversion Factor (6 Decimals) 0.906258
Month
Conversion Factor (4 Decimals) 0.9063







Day









Year










Sheet 3: 3-Year Notes
3-YEAR U.S. TREASURY NOTE FUTURES CONVERSION FACTOR CALCULATOR








DGRO50: Enter as decimal. 1.) Select Coupon
Remaining Maturity from First Day of Delivery Month (Unrounded)
Year 3



Month 0
DGRO50: Insert. 2.) Select Maturity Date

Day 14





Month
n 3
z 0



v 0
Day


a 1.000000



b 0.005625
Year
c 0.837484
d 0.030472





DGRO50: Insert. 3.) Select First Day of Delivery Month

Futures Expiry Month December 2009



Conversion Factor (6 Decimals) 0.867956
Month
Conversion Factor (4 Decimals) 0.8680







Day









Year










The words contained in this file might help you see if this file matches what you are looking for:

...Sheet conversion factor formula year notes us treasury note futures calculator dgro enter as decimal select coupon remaining maturity from first day of delivery month unrounded insert date n z v a b c d expiry december decimals...

no reviews yet
Please Login to review.