Login Page - Create Account

Support Board

Date/Time: Thu, 09 Apr 2020 20:44:37 +0000

6E spreadsheet B, C, D, E columns

[2014-01-09 16:41:55]
User60591 - Posts: 39 | Ending Date: 2017-11-12 [Expired]
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

Pls help me with this.

thank you

Date Time Of Last Edit: 2014-01-09 16:45:45
[2014-01-09 17:13:26]
tomgilb - Posts: 2441 | Ending Date: 2020-04-30
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:

Date Time Of Last Edit: 2015-08-14 01:51:34
[2014-01-09 17:44:34]
User60591 - Posts: 39 | Ending Date: 2017-11-12 [Expired]
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]
tomgilb - Posts: 2441 | Ending Date: 2020-04-30
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 login with your Sierra Chart account:


Login Page - Create Account