NexusFi: Find Your Edge


Home Menu

 


Quotes by TradingView
Go Back   >  Search Forums  > 

Page 1 of 3 123
Showing results 1 to 25 of 73
Search: Posts Made By: Sawtooth
Forum: Sierra Chart January 3rd, 2022, 11:39 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
When sg1=sg2, it will return 0.

When sg1=sg2, it will return 0.
Forum: Sierra Chart January 3rd, 2022, 08:51 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
Since you want to return the result of a...

Since you want to return the result of a calculation, and not just a T/F, you need to use the IF function:
=IF(id0.sg1[0] > id0.sg2[0], id0.sg1[0] / id0.sg2[0], IF(id0.sg2[0] > id0.sg1[0],...
Forum: Sierra Chart March 28th, 2021, 10:53 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
For situations like this I use the Trade...

For situations like this I use the Trade Management By Study study to move stops. It would reference a price in a Formula Column (a subgraph) that a formula returns. ...
Forum: Sierra Chart March 26th, 2021, 07:32 PM
Replies: 182
Views: 65,883
Posted By Sawtooth
I assume the 15 min charts each use a different...

I assume the 15 min charts each use a different symbol.

You could use a blank cell H42 on Chart2's sheet with a formula like this:
=Sheet1!J42
Then use a Formula Column on Chart2's sheet with a...
Forum: Sierra Chart March 18th, 2021, 04:04 PM
Replies: 182
Views: 65,883
Posted By Sawtooth
Backtests will always differ from live trading to...

Backtests will always differ from live trading to some degree, but here are some things you can do to make it more accurate:...
Forum: Sierra Chart February 4th, 2021, 02:35 PM
Replies: 182
Views: 65,883
Posted By Sawtooth
First, you must use an absolute reference to J21...

First, you must use an absolute reference to J21 in formulas in Formula Columns:
=AND([email protected]@3>10*$J$21,ID0.SG4@3>ID0.SG1@3)

Also, you could shorten it by using alphanumeric cell...
Forum: Sierra Chart January 22nd, 2021, 08:09 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
Short answer: No. If there is more than one...

Short answer: No.

If there is more than one condition for a signal, you will only be able to delineate which one by manually examining the event.
IOW, if it's TRUE, it's TRUE.
Forum: Sierra Chart December 14th, 2020, 11:33 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
There is no direct way. Here are two indirect...

There is no direct way. Here are two indirect ways:

First, be sure you have saved the latest update of your Spreadsheet System for Trading study. Also, having a backup is always a good idea.
...
Forum: Sierra Chart December 11th, 2020, 08:49 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
You can use the Text Display For Study study, but...

You can use the Text Display For Study study, but the value would need to be in row 3 of a Formula Column.
Formula Columns are subgraphs that the Text Display For Study study can reference.

To...
Forum: Sierra Chart November 27th, 2020, 02:29 PM
Replies: 182
Views: 65,883
Posted By Sawtooth
If you enter a 1 when prompted for a 'Processing...

If you enter a 1 when prompted for a 'Processing Step In Seconds', instead of the default 60 seconds, you will get a slower replay speed, and IMO a more accurate test. So both. I always use 1...
Forum: Sierra Chart November 27th, 2020, 10:05 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
Same reason: the slower the replay, the more...

Same reason: the slower the replay, the more accurate the results.
This is because of processing latencies from hardware, software, and system complexity.
Forum: Sierra Chart November 16th, 2020, 03:04 PM
Replies: 182
Views: 65,883
Posted By Sawtooth
Since the 'Strict Signal Only On Bar Close...

Since the 'Strict Signal Only On Bar Close Evaluation' option is only available in the Spreadsheet System for Trading study, and that study also has the Signal Only On Bar Close (K,M) option. Set it...
Forum: Sierra Chart November 16th, 2020, 02:44 PM
Replies: 182
Views: 65,883
Posted By Sawtooth
No, but it will lag if the the speed is too fast...

No, but it will lag if the the speed is too fast for the video display to keep up.

Choose a speed that does not cause the video display to lurch.
Forum: Sierra Chart November 14th, 2020, 08:24 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
Single Chart replay has no synchronization with...

Single Chart replay has no synchronization with overlaid charts. The source charts do not join in the replay, so the overlaid values would repeatedly be from the source chart's latest bar only, so...
Forum: Sierra Chart November 14th, 2020, 07:58 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
The short answer is No. The Spreadsheet...

The short answer is No.

The Spreadsheet System for Trading study has no access to historical trade times, only the most recent.
Even if it did, you'd need a Formula Column for each entry and...
Forum: Sierra Chart October 31st, 2020, 10:33 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
I use Sierra Chart spreadsheet studies...

I use Sierra Chart spreadsheet studies extensively.
Here's a thread I started 10 years ago:
https://nexusfi.com/sierra-chart/7321-sierra-chart-worksheet-system-trading-alert-discussions.html
Some...
Forum: Sierra Chart October 8th, 2020, 09:32 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
Use something like this: ...

Use something like this:
=SUM(AB3:OFFSET(AB3,$H$1,0))
- where H1 is 7.

This will give the same result as =SUM(AB3:AB10)

Note: The OFFSET function does not include its starting cell in the...
Forum: Sierra Chart September 11th, 2020, 05:19 PM
Replies: 182
Views: 65,883
Posted By Sawtooth
Sorry, I'm not understanding what you want to do....

Sorry, I'm not understanding what you want to do.
What is in AW3?
What is 0.000012 ?
Forum: Sierra Chart September 7th, 2020, 10:17 PM
Replies: 182
Views: 65,883
Posted By Sawtooth
Signals are only generated in row 3 for intrabar...

Signals are only generated in row 3 for intrabar entries, or row 4 for close of bar entries. This choice is with the setting 'Signal Only On Bar Close (K,M)'....
Forum: Sierra Chart September 7th, 2020, 05:46 PM
Replies: 182
Views: 65,883
Posted By Sawtooth
Use INTDATE instead of DATEVALUE. And use an...

Use INTDATE instead of DATEVALUE.
And use an absolute reference to the Sheet2 cell. (You won't need ROW()=3.)
...
Forum: Sierra Chart September 6th, 2020, 08:52 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
The short answer is: You probably can't do what...

The short answer is: You probably can't do what you want with the Spreadsheet System for Trading study. At best, it would be cumbersome.

Sierra Chart spreadsheet studies are simplistic compared...
Forum: Sierra Chart September 3rd, 2020, 10:00 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
Try this: =$J$41-$J$43>3/1440 This...

Try this:
=$J$41-$J$43>3/1440

This compares the last chart update time to the last exit time.
3/1440 is 3 minutes in Serial Date Time format because there are 1440 minutes in 24 hours.
...
Forum: Sierra Chart August 21st, 2020, 08:01 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
K and M are the only columns that can trigger an...

K and M are the only columns that can trigger an entry.

As you know, it's not possible to create a persistent variable of column J values. Persistent variables can only be created in Formula...
Forum: Sierra Chart April 26th, 2020, 09:26 AM
Replies: 182
Views: 65,883
Posted By Sawtooth
Since there is no restriction to entries after...

Since there is no restriction to entries after winners, skipping an entry when you've had a loser is the only condition that needs to be limited.

I would approach this by 'Locking the State of a...
Forum: Sierra Chart February 28th, 2020, 07:17 PM
Replies: 182
Views: 65,883
Posted By Sawtooth
You would need to use this method to bring...

You would need to use this method to bring previous Zigzag values to row 3, each in their own Formula Column:...
Showing results 1 to 25 of 73
Page 1 of 3 123

What unexpected challenges have you encountered while trading on a "Funded Trader" platform?

View Results Discuss Poll
 

 
 


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top