Support Board
Date/Time: Mon, 23 Dec 2024 02:11:54 +0000
Using Spreadsheet to create Cumulative Open Profit/Loss and having it to be displayed onto a Sub
View Count: 1500
| [2015-01-02 01:52:15] |
| Riche - Posts: 20 |
|
Hi Sierra, Do u know how to use Spreadsheet to create a Cumulative Open Profit/Loss? For example, i have Long open position for ES, E6, & DY. Now I want to know my current Cumulative Open Profit/Loss on these 3 positions. How can I do that using Spreadsheet? Also, once these 3 positions reached a certain amount of Loss, let's say $1000 loss, i want to flatten all my position automatically. How can I do that using Spreadsheet? Also, I want this Cumulative Open Profit/Loss to be displayed in a Subgraph. How can I do that? Thanks lots !!! |
| [2015-01-02 19:00:40] |
| Sawtooth - Posts: 4141 |
|
You could do this with the Spreadsheet System for Trading study applied to each chart. This assumes all charts are in the same chartbook. |
| [2015-01-04 02:55:04] |
| Riche - Posts: 20 |
|
Hi Tomgilb, Nice to hear from you. I remember seeing a related post by you somewhere. I downloaded your Spreadsheet but there is no chart that appears in my Subgraph that linked to that Spreadsheet. Now, I tried to search for that post but can't find it anymore. I am using Version 1220 (Old Spreadsheet). Do u know why? Thank you very much Tomgilb ! |
| [2015-01-04 03:51:54] |
| Sawtooth - Posts: 4141 |
|
Hi Riche, I don't understand your question. Is this the post you are looking for?: Total P&L Based on Bid/Ask BTW, Sierra now has the option to calculate P/L based on Bid/Ask. Creating what you want would require some familiarity with spreadsheet studies, formulas and functions. It's more complex than can be described in a forum post, but it seems entirely possible. If you get stuck, I'd be glad to answer your questions. |
| [2015-01-11 01:53:19] |
| Riche - Posts: 20 |
|
Hi Tomgilb, Any private msg, watsapp, email, fb where we can talk? |
| [2015-01-11 02:22:42] |
| Sawtooth - Posts: 4141 |
|
http://sawtoothtrade.com/contact/
|
To post a message in this thread, you need to log in with your Sierra Chart account: