Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 16:27:57 +0000

How to Post a Message for Support

Using Spreadsheet to create Cumulative Open Profit/Loss and having it to be displayed onto a Sub

View Count: 1403

[2015-01-02 01:52:15] #1 [Go To First Post]
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] #2 [Go To First Post]
Sawtooth - Posts: 3992
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] #3 [Go To First Post]
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] #4 [Go To First Post]
Sawtooth - Posts: 3992
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] #5 [Go To First Post]
Riche - Posts: 20
Hi Tomgilb, Any private msg, watsapp, email, fb where we can talk?

[2015-01-11 02:22:42] #6 [Go To First Post]
Sawtooth - Posts: 3992
http://sawtoothtrade.com/contact/

To post a message in this thread, you need to log in with your Sierra Chart account: