Support Board
Date/Time: Sat, 18 Jan 2025 07:50:47 +0000
Recording Bid Price and Ask Price in a 1 Trade spreadsheet
View Count: 818
| [2018-02-03 03:24:46] |
| User202045 - Posts: 11 |
|
How do you enter the bid price and ask price in a spreadsheet generated from a 1 Trade chart? I see the prices in J12 and J14 but I don't understand how to record the value to the top row. If I just use an absolute reference to J12, of course the entire column shows the current value of J12, not the value at the time the top cell in the column was created. My ultimate goal is to create a condition where x number of consecutive bid or offer changes in the same direction trigger a trade.
|
| [2018-02-03 04:27:13] |
| |
|
You need to use the Bid and Ask Prices study: Bid & Ask Prices Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [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)) |
| [2018-02-03 04:30:43] |
| |
|
This can be done on a 1 Trade chart. Refer to post #2 above.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: