Login Page - Create Account

Support Board


Date/Time: Sat, 18 Jan 2025 11:06:59 +0000



Post From: Recording Bid Price and Ask Price in a 1 Trade spreadsheet

[2018-02-03 04:27:18]
Sawtooth - Posts: 4154
There is no way to create a persistent variable of J12 or J14 at a certain time.

Since it's a 1 trade chart, you can create an incrementing variable of trades at ask and bid using the Number Of Trades - Ask and the Number Of Trades - Bid studies with a formula like this, e.g. in cell O3:
=IF(ID1.SG1@3=0,0,IF(ID1.SG1@3>0,O4+1,O4))