Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 21:55:36 +0000

How to Post a Message for Support

[User Discussion] - Average Open Position Profit/Loss

View Count: 1469

[2016-02-08 21:50:42] #1 [Go To First Post]
User87521 - Posts: 81
In the Spreadsheet System for Trading there are a couple of cells that Show Maximum Open Position Profit (and Loss). Is it possible to have some cells that will track the Average Open Position Profit (and Loss)? I have a system where I am trying to decide if I need to cut down the number of Loss trades and knowing what that average loss might be would be helpful. As well, I am trying to reference more than one chart in a Spreadsheet. Is this possible? Think of multiple timeframe analysis. Thanks for the help.

[2016-02-09 00:18:55] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
You would have to calculate this Profit/Loss value from the data in the Spreadsheet. To reference other charts when using one of the Spreadsheet Studies, refer to: https://www.sierrachart.com/index.php?page=doc/doc_ReferencingChartsFormulas.html 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

[2016-02-09 21:52:56] #3 [Go To First Post]
User87521 - Posts: 81
OK, thank you. I have a few questions and I hope this doesn't seem to be a mess to you. First, I do not see where the profit/loss data is kept in the Spreadsheet study. Obviously it is kept somewhere as you provide a cumulative profit/loss. Second, wrt. the overlay study I am having a problem. I can get it set up to the point where it will take trades the way I want it, but I cannot backtest it. What I have done is as follows: (For an overview, I have a 15 min. chart with an indicator. I want to trade off of a 3 min. chart given the 15min. chart indicator and use the 3 min. indicator as the Buy Entry. Assume a 15 Stochastic crossover and then use a 3 min Stochastic crossover when they are both positive.) Overlay Study synchronized. Did not seem to work when I wanted to adjust the overlay to a chart time period that was different from the primary chart. I assume this is correct. Overlay study unsynchronized. This seems to work nicely and will work for auto trading but when I go to back test the system it will not pick up the overlay study indicator. I am assuming because it is not synchronized. Is this correct or am I missing something. Study/Price Overlay. This will work to synchronize nicely in time, but it will not produce an indicator. An MACD or Stochastic is jumbled and is obviously picking up bad data points. Thanks for the help.

[2016-02-10 00:39:48] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
First, I do not see where the profit/loss data is kept in the Spreadsheet study. Obviously it is kept somewhere as you provide a cumulative profit/loss. If you are using the Spreadsheet System for Trading study, then if you are not seeing the data that you are looking for it is not available on the Spreadsheet. All of the available Profit/Loss data is going to be in column I You must use the Study/Price Overlay study. It does work accurately, but you need to understand the Inputs for it and set them appropriately. They are documented here: https://www.sierrachart.com/index.php?page=doc/doc_StudyPriceOverlayStudy.php#Inputs You need to spend the time to experiment with it and understand the inputs and look at both the source and destination graphs to understand what is happening. We cannot provide much support beyond this. 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 Date Time Of Last Edit: 2016-02-10 00:40:19

[2016-02-10 01:48:18] #5 [Go To First Post]
Sawtooth - Posts: 4000
Profit/Loss data is in cells J10 and J45. You can sum them for current P/L. If your overlaid studies are not in sync in Replay, be sure to check 'For All Charts in Chartbook'.

[2016-02-10 14:42:31] #6 [Go To First Post]
User87521 - Posts: 81
Thanks Tom. I think I got the Price Overlay figured out last night. I'm still not sure how to get the average profit/loss data from the spreadsheet. This is during the back testing. I'll keep working on it.

[2016-02-10 14:47:40] #7 [Go To First Post]
Sawtooth - Posts: 4000
Please explain 'average profit/loss'. The average of what?

[2016-02-10 14:59:15] #8 [Go To First Post]
User87521 - Posts: 81
In backtesting it outputs total good trades and total bad trades but only a total cumulative profit/loss. It is easy to determine the average profit/loss of ALL trades, but I would like to know what that amount is for all good vs. all bad.

[2016-02-10 16:22:30] #9 [Go To First Post]
Sawtooth - Posts: 4000
Try this: Add the Trading: Maximum Runup study for the cumulative profit. Add the Trading: Maximum Drawdown study for the cumulative loss.

[2016-02-10 16:38:09] #10 [Go To First Post]
User87521 - Posts: 81
Geez. I can't believe the number of studies this program has. Thanks. I have more stuff to play with.

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