tomgilb 

Yes, you can scale in using the Spreadsheet System for Trading study. ln:12 would need to be Yes. You will need a formula in J26 that returns the correct entry quantity for the initial and subsequent entries. The K3/M3 formulas will need to be able to trigger the initial entry and subsequent entries. There might be other settings and formulas to consider, depending on your specific system.

Thanks a lot Tom, appreciate your help.
I think it's clear, but I think I'm missing something as it doesn't enter a second trade.
Here's what I did for order quantity...

K3: =AND(ID5.SG19@4>0, ID5.SG1@3>25)
J26: =IF(J10>10, 2,1) ***if profit/loss >10, enter another order.

It's not adding a scale in. Not sure if it references J26 again once in a trade...
Not quite sure how to modify K3 for 2nd entry...

Quoting 

Not sure if it references J26 again once in a trade

When K3/M3 goes TRUE, the value in J26 will be used, regardless if you're flat or not.

Quoting 

Not quite sure how to modify K3 for 2nd entry

The K3/M3 formula will have an OR statement because there are two conditions for entries, 1st and 2nd.
Something like this, where the two conditions are exclusive:
K3: =OR(AND(ID5.SG19@4>0, ID5.SG1@3>25),AND($J$10>10,$J$8>0))

Note: this J26 formula: =IF(J10>10, 2,1) will only be true when there is an open profit, not loss.

Hi @tomgilb
Using the Zig Zag and spreadsheet study, how would I populate a column containing certain basic calculations such as:
Average of the last 10 printed swing sizes
Difference between the last 2 high swings
Difference between the last 2 low swings

etc..

I really just want to populate a single cell with a formula and then place the results as text on the chart. The worksheet formulas seem to copy down the entire column and the problem with the zig zag study is that the numbers are constantly changing until a swing has been firmly established.This means the text indicator constantly changes.

Thanks.

tomgilb 

When K3/M3 goes TRUE, the value in J26 will be used, regardless if you're flat or not. The K3/M3 formula will have an OR statement because there are two conditions for entries, 1st and 2nd. Something like this, where the two conditions are exclusive: K3: =OR(AND(ID5.SG19@4>0, ID5.SG1@3>25),AND($J$10>10,$J$8>0)) Note: this J26 formula: =IF(J10>10, 2,1) will only be true when there is an open profit, not loss.

I have everything entered like above.
Once I'm on a trade and profit is more than 10ticks, it still does not scale in. Thinking I screwed up the settings. Is there anything here that sticks out that is completely wrong?

Quoting 

Is there anything here that sticks out that is completely wrong?

Based on your J26 formula, Maximum Position Allowed (ln:20) would need to be 3 or larger.

Also, 30000 rows is huge. You might see some lag with this setting. 1000 rows is recommended, and is usually sufficient.

Grantx 

Hi @tomgilb Using the Zig Zag and spreadsheet study, how would I populate a column containing certain basic calculations such as: Average of the last 10 printed swing sizes Difference between the last 2 high swings Difference between the last 2 low swings etc.. I really just want to populate a single cell with a formula and then place the results as text on the chart. The worksheet formulas seem to copy down the entire column and the problem with the zig zag study is that the numbers are constantly changing until a swing has been firmly established.This means the text indicator constantly changes. Thanks.

You would need to use this method to bring previous Zigzag values to row 3, each in their own Formula Column:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetExampleFormulasAndUsage.php

No wonder my Sierra started to slow down a bit I was testing and forgot to put it back to 1000

Thanks a lot Tom, it's working now...

tomgilb 

Based on your J26 formula, Maximum Position Allowed (ln:20) would need to be 3 or larger. Also, 30000 rows is huge. You might see some lag with this setting. 1000 rows is recommended, and is usually sufficient.

Sent using the NexusFi mobile app

Hi,
Am trying to figure out how to code around pivot points and want the logic to follow:

If no trade is open and first attempt at pp1
If crossfromabove pp1-- buy
If crossfrombelow pp1 -- sell

If no trade is open and previous trade at pp1 was a winner
If crossfromabove pp1-- buy
If crossfrom below pp1 -- sell

If no trade is open and previous trade at pp1 was a loser
-skip this trade
-reset attempt counter so thrid attempt can be true...i.e. doesnt remember the 1st loser

Hope this makes sense
Thanks in advance

bxman 

Hi, Am trying to figure out how to code around pivot points and want the logic to follow: If no trade is open and first attempt at pp1 If crossfromabove pp1-- buy If crossfrombelow pp1 -- sell If no trade is open and previous trade at pp1 was a winner If crossfromabove pp1-- buy If crossfrom below pp1 -- sell If no trade is open and previous trade at pp1 was a loser -skip this trade -reset attempt counter so thrid attempt can be true...i.e. doesnt remember the 1st loser Hope this makes sense Thanks in advance

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 One Time Condition'
https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudiesSpecialTasks.php
Here is another example of its use:
https://www.sawtoothtrade.com/example-9.html

Add the Trading: Losing Trades study and lock a TRUE/1 when it changes value. Then release it one bar after the next entry signal.
Its reference must be FALSE/0 in your K3/M3 entry formulas.

Arriving at the actual formula to do this automatically will probably require some trial and error. And it can be difficult to get it to work the way you want.

Hi, see you have moved to Nashville, Tom

Have received help earlier on how to find lowest volumes of a session
=IF(OR(INT(A3)>INT(A4),AND(FRACTIME(A4)<$H$10,FRACTIME(A3)>=$H$10)),10000,IF(F3<S4,F3,S4))
(using start time in $H$10, with formula put in S column)

but not sure on how to calculate a running average of all values
from an opening bell.
Any help appreciated