Login Page - Create Account

Support Board


Date/Time: Mon, 23 May 2022 23:37:05 +0000



[User Discussion] - spreadsheet for trading

View Count: 1120

[2013-06-17 07:19:54]
fxz - Posts: 32
Hi

when applying spreadsheet for trading to forex symbols like
usdtry or eurpln the ohlc 1 minute (or any timeframe) chart

become unreadable,example:
from this
http://www.sierrachart.com/image.php?l=1371453479497.png
to this after spreadsheet for trading applied to symbol
http://www.sierrachart.com/image.php?l=137145355023.png

Regards

[2013-06-17 13:10:09]
tomgilb - Posts: 3272
If the arrow is printed from any column except K-N, you must tell it where to print. If the value is TRUE/FALSE in columns O and above, it will print it at zero, not at the high/low of the bar. Here's how to correct this:

Up arrow:
IF(yourconditions,D3,0)

Down arrow:
IF(yourconditions,C3,0)


[2013-06-17 13:26:23]
fxz - Posts: 32


i don t use any arrow to be printed neither k m true false conditions, just applied the spreadsheet for trading
as it is all values to default applied --ok that s all and the chart go crazy

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account