Excel help for formatting Bond/Notes values
Can someone tell me how I should format my Excel cells to be able to calculate the pivots myself the way mypivots does? I was fine until they added the 1/2 tick, but can't quite figure out how to figure them now... I know how to calculate the pivots -- just not sure how to "format the cell" for the number... Like 130-025...
Any ideas?
Any ideas?
onthemove: Is your problem converting a number like 130-025 (in a cell) into a decimal value that you can do calculations on?
If that's the case then the following Excel formula will work which assumes that the value is in cell A1 (top left corner cell):
=LEFT(A1,3)+RIGHT(A1,3)/320
If that's the case then the following Excel formula will work which assumes that the value is in cell A1 (top left corner cell):
=LEFT(A1,3)+RIGHT(A1,3)/320
Hi, I am also interested to understand doing pivot calculations for bonds with xxx-xxx format. I am not clear as converting xxx-xxx format to decimal can provide the pivot results in xxx-xxx format. for example if high is 130-040 and low is 129-280, how do I calculate the difference or range in excel in xxx-xxx format?
Any help would be appreciated.
Thank You
Any help would be appreciated.
Thank You
pakeez: The standard way to do this in Excel is to convert the cell to a decimal value as I showed in the previous post, do the range calculation and all pivot point calculations in decimal, and then format the cell as a bond value.
Emini Day Trading /
Daily Notes /
Forecast /
Economic Events /
Search /
Terms and Conditions /
Disclaimer /
Books /
Online Books /
Site Map /
Contact /
Privacy Policy /
Links /
About /
Day Trading Forum /
Investment Calculators /
Pivot Point Calculator /
Market Profile Generator /
Fibonacci Calculator /
Mailing List /
Advertise Here /
Articles /
Financial Terms /
Brokers /
Software /
Holidays /
Stock Split Calendar /
Mortgage Calculator /
Donate
Copyright © 2004-2023, MyPivots. All rights reserved.
Copyright © 2004-2023, MyPivots. All rights reserved.