Does someone have an idea as to how to convert note prices in CQG into 64's so as to be able to decimalize them. For 108-055 (108-5.5 32's) the CQG price reads 108055. I figured that I could multiply that by .0001 to arrive at a second cell that would contain a value of 108.055. How can I get Excel to generate an even number of 108 that I could subtract from the 108.055? I tried to use the "format cells" function on the third cell to format the third cell with no decimal places, but when subtracting cell 3 from cell 2, it still gives me zero. Any suggestions? Thanks in advance. Magyar.
http://help.lockergnome.com/office/Bond-prices-convert-decimals-ftopict869175.html this might help... might not... good luck... cj... __________________ HAVE STOP - WILL TRADE If You Have The Vision We Have The Code