Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 11:28:06 +0000
Chart a portfolio
View Count: 78
| [2024-04-30 20:27:55] |
| stevenpaul - Posts: 9 |
|
Is there a study that can be applied to link multiple stocks and chart the performance of all the stocks (at their respective share quantities) as a single chart? Thank you. |
| [2024-04-30 21:56:38] |
| John - SC Support - Posts: 31704 |
|
There are a number of possible ways to do this, but it depends on what exactly you want to view. In particular, how are you wanting to tie the various instruments together? Do you want to view a Percent Change since some point in time? Are you just looking for a percent change for a single day? Are you not really concerned about actual changes but want to view the shape of the data? If you can give us some idea of how you want to accomplish this, then we can point you in the right direction. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-04-30 22:35:08] |
| stevenpaul - Posts: 9 |
|
Thank you for the reply. I am interested in tracking the percent change on a bar by bar basis for a small portfolio. Ideally, I could use studies on the "portfolio chart," making decisions based on the overall performance of the portfolio. In an effort to be brief, I left out specifics. Here they are, in case relevant: I have a long only portfolio of two inversely correlated ETFs, which track the same underlying index by differing multiples. I hold these ETFs at a ratio (e.g. 100 shares X, 320 shares Y.) I would like to track their overall performance in the aggregate, and apply studies to determine when to liquidate the portfolio in whole or part. I would also like to do the same for similar portfolios, different from the aforementioned only in the ratio. (I noticed the difference study, but as my goal is to track the performance of stocks added together, difference seemed the wrong choice.) |
| [2024-05-01 14:18:19] |
| John - SC Support - Posts: 31704 |
|
To view two symbols in aggregate, you would want to have the symbols open in separate charts and then use the "Sum (Bar)" study on one of the charts to add these together and display the result. This study allows for a multiplier for both charts, so you could enter multipliers of 100 and 320 for instance (or use 1 and 3.2, depending on what you prefer). Refer to the following: Sum - Bar You could then set this study to be the "Main Price Graph" so you can view it as its own chart. Refer to the following: Chart Studies: Settings and Inputs Tab >> Display As Main Price Graph If you want to have more than 2 symbols, then we recommend using the "Spreadsheet Formula (Bar)" study in combination with the Add Additional Symbol study. This will allow you to add an unlimited number of items together, you just have to define the items to add together for each of the Open/High/Low/Close. For instance, you would use the "Add Additional Symbol" study to add a second and/or third symbol to the chart. Then in the Spreadsheet Study you would enter a formula like the following to add the Opens together: =ID0.SG1 + ID1.SG1 + ID2.SG1 Where ID0 is the Main Price Graph (primary symbol of the chart) and SG1 is the Open. ID2 and ID3 are the IDs of the Add Additional Symbol studies and SG1 for each of these is the Open. If you want multipliers, then you can add those to the formula such as the following: =ID0.SG1 * 100 + ID1.SG1 * 320 + ID2.SG1 * 4 --- For the ratio, we recommend the same process as above with the Spreadsheet Formula, just changing the formula as you need for what you want. For the most reliable, advanced, and zero cost futures order routing, use 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: