Support Board
Date/Time: Sun, 22 Dec 2024 10:03:43 +0000
Entering Fractional Prices in New Spreadsheets
View Count: 893
| [2015-08-02 14:54:24] |
| Acro - Posts: 441 |
|
Hi, I'm struggling with the format one uses for entering fractional prices into a spreadsheet. I'm using a spreadsheet study for horizontal lines and I would like to display it on a chart of the ten year treasury notes. In the new spreadsheets how do you enter a price of 127 and 23/32 ? Thank you |
| [2015-08-02 17:43:03] |
| Sawtooth - Posts: 4141 |
|
Try this: =127+23/32 |
| [2015-08-02 21:21:16] |
| |
|
The answer given in post #2 is correct.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-08-03 00:20:05] |
| Acro - Posts: 441 |
|
Thank You. I appreciate that after you have set up a spreadsheet study for multiple horizontal lines it has become easy to update it daily and therefore may be more useful than the Horizontal Lines study. I'm making sure I use the New Spreadsheets and will monitor CPU Usage, which I hope will not be high with only 160 rows |
| [2015-08-03 04:21:37] |
| |
|
If the Spreadsheet does not contain any formulas and just values only, this will reduce CPU usage significantly. The formulas you are using for the fractional values, are formulas, but they are very simple. We will see if we can automatically detect those types of numbers with fractions and treat them as numbers when entered. So a formula does not have to be used. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: