Support Board
Date/Time: Fri, 24 Jan 2025 05:03:20 +0000
[User Discussion] - Historical Information for Column J
View Count: 827
| [2018-12-18 18:48:25] |
| User606491 - Posts: 164 |
|
Hello, When using the spreadsheets: Is there a way to plot historical values for column J? For example: Open Profit/Loss(J10) at @3, @4, @5,@6.... thank you. |
| [2018-12-18 19:29:39] |
| Sawtooth - Posts: 4162 |
|
In a word, no. To plot historical values, they need to be in a column that aligns with price bar data. IOW, historical values are only in rows 3 and below, where row 3 is the current bar, and earlier bars are in rows below. There are several Trading:... studies that can be used to do this, but none of them output the Open P/L. Maybe SC could add one. |
| [2018-12-18 19:56:03] |
| User606491 - Posts: 164 |
|
Thanks as always, Tom. I think many would find a use for this. |
| [2018-12-18 20:07:59] |
| |
|
The problem with the Open Profit/Loss is that there is no stable value for it. It is not something that can reasonably be provided historically.
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-12-18 21:07:13] |
| User606491 - Posts: 164 |
|
The following formula works fine for my purposes: =(id0.sg4@3-$J$9)*$J$56/$J$21*$J$5 where: J9 = Position avg price J56 = $/tick J21 = tick size J5 = position quantity ideally, I would revise this formula to include a "getcorrespondingmatch" modifier that hides all values prior to my entry date-time...perhaps later. |
| [2018-12-18 22:11:19] |
| Sawtooth - Posts: 4162 |
|
User606491, thanks for the formula. I don't think it would work for scaling in/out, however. Here's a way to zero the values in bars previous to the entry bar: Put this in a formula column, e.g. P3: =IF(ROW()=3,0,OR(P2=1,AND($J$42>A2,$J$42<A1))) Put this in another formula column: =IF(P3=0,(E3-$J$9)*$J$56/$J$21*$J$5,0) |
| [2018-12-19 03:39:29] |
| User606491 - Posts: 164 |
|
Wonderful, as always, Tom. Thank you. Agreed, on scaling in/out, would require a formula adjustment. |
To post a message in this thread, you need to log in with your Sierra Chart account: