Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 23 Apr 2024 21:02:40 +0000
6E spreadsheet B, C, D, E columns
View Count: 1308
| [2014-01-09 16:41:55] |
| User60591 - Posts: 39 |
|
Pls tell me why do I have in a spreadsheet the value of 6E on 15 decimals, instead of 4 (Open, High, Low , Last? i.e 1,35909998416901 (double clicking the cell) instead of just 13510, and then the first number is rounded up to get 13510. Namely I use formula =AND(B3=D3;E3=C3;E3>B3;B3<=E4) as a part of a buying signal I have following on 2014/1/8 @ 11:55:32 (GMT+1) open B = 1.3578999 high C = 1.35829997062683 low D = 1.35790002346039 last E = 1.35829997062683 so I have FALSE because Open and Low does not match. Rounded up it would be TRUE 1.3579 1.3583 1.3579 1.3583 Pls help me with this. thank you Date Time Of Last Edit: 2014-01-09 16:45:45
|
| [2014-01-09 17:13:26] |
| Sawtooth - Posts: 3976 |
|
When comparing prices that are supposedly equal, you will frequently need to round them to the tick size. And sometimes you also need to round the tick size. This is what I do: http://www.sawtoothtrade.com/example-3.html Date Time Of Last Edit: 2015-08-14 01:51:34
|
| [2014-01-09 17:44:34] |
| User60591 - Posts: 39 |
|
thank you tom, i was looking at the site yesterday and it helped me with some things. I didn't rememebr to look it again for this issue. it's nice to have there examples for common problems with spreadsheets. I see that I need to use 4 more columns for that. Is there any way to add more columns for calculation into the existing spreadsheet and not mess up the formulas in Row 3? thnx again Date Time Of Last Edit: 2014-01-09 17:47:54
|
| [2014-01-09 17:59:53] |
| Sawtooth - Posts: 3976 |
|
You can set Number of Formula Columns up to 60, but it will also move all of your study outputs to higher columns, so all of your formulas that reference studies will have to be edited. I usually use AB to AE if I need to round prices, simply because it tracks with B to E. Easier for me to quickly reference. But if you are short of spare columns, you can include the MROUND in the formula instead of referencing a MROUNDed column. |
To post a message in this thread, you need to log in with your Sierra Chart account: