Rebalance Your Portfolio
Access your Portfolio Tracker
Use the Portfolio Tracker
Need to track other metrics for your portfolio?
Maybe you’d like to make sure your equity positions don’t exceed a certain P/E Ratio threshold. Or set the technical STOP levels above or below our standard setting.
Or maybe you’d like us to compute a totally different metric for your tracker. Whatever the request might be, we’ll do our best to accommodate it. If it can be derived from price or fundamental data, then we can display this for you. Use the form below to let us know what your particular needs are!
Scope
Knowing your portfolio’s correlations to the main investment themes and the dollar risk associated with various scenarios is essential in managing your positioning
Duration
5 minutes
Prerequisites
Your own Gmail account
Deliverables
At the end of this activity you will be the owner of a custom Google Sheet, connected to the Signal Sigma database. It will allow you to set stock and ETF positions in a simulated portfolio (which may or may not mirror your own).
By default, the sheet will reveal the portfolio’s risk, correlations to major Sector & Factor ETFs and screen for vulnerable positions.
Research clients can activate 1 such Portfolio Tracker. PRO clients have access to unlimited trackers.
Follow the steps outlined below to access the Portfolio Tracker
2. Wait, then Click “ACTIVATE SPREADSHEET”
Wait for the spreadsheet to finish loading, then click the button. If you do it too quickly, you might get an error.
3. Complete the authorization flow
You will need to grant the code contained in the spreadsheet permission to run. It is designed as a convenience to you. Click Continue.
Choose your account from the list.
Since you are now the owner of this spreadsheet, Google thinks you are its developer. Click “Advanced” in the bottom left corner.
Click “Go to Portfolio Tracker (unsafe)”
It’s 100% safe, trust us.
Click “Allow”. You can find details for the permissions requirement at the end the video above.
1. Create a copy of the Portfolio Tracker
Click the adjoining button. This will prompt you to sign in to your Google account.
After you sign in, you will be asked to confirm the operation.
Click “Make a copy”. You can also inspect the Apps Script file that runs within the spreadsheet at this stage.
The Portfolio Sheet - Allocation and starting values
The Portfolio sheet is the only sheet that you should modify with your own values.
At the top, you will find the table containing target percentage exposures for each asset class sub-portfolio as well as the actual exposure metrics.
The Portfolio Sheet - Asset Class Sub-Portfolios
The main part of the spreadsheet is dedicated to keeping track of various instruments that can be assigned to a particular asset class sub-portfolio. This designation is really up to you and how you prefer to view your investments. Gold miner stocks can easily fit in the Gold asset class sub-portfolio, for example. You can even rename the sub-portfolios according to your own needs.
You will see this layout repeated across all of the other tabs in the spreadsheet, as we pull various metrics from our database and create visualisations and calculations pertaining to the positions.
The Equities Portfolio is the only different section, as it allows for Risk Parity position weighting. The Sectors and Factors sheets also treat this portfolio differently. All of the other sub-portfolios use equal-weight position weighting when determining “Target Amount”.
The Risk Explorer Sheet
This sheet allows you to view the risk in dollar amounts for each position as well as for the whole portfolio in different scenarios. You can also set your own Upside / Downside price targets for each stock, and see the aggregate values for those as well. Values are updated after market close.
This demo portfolio has the following risk and potential reward:
If all positions retrace to their 50-Day Moving Averages: loss of $2.494,44
If all positions reach their respective 52 week Highs: gain of $7.726,48
If all positions reach their Bollinger Bands lows: loss of $6.084,99
Scenarios calculated:
50 MA, 200 MA - a retracement to the 50-Day and 200-Day Moving Averages - this is a common technical occurrence
52wk High / Low - the stock reaches a new 1 year High or Low - another common scenario
BB High / Low - the stock touches the latest value calculated for its Bollinger Band - a 2 Standard Deviation move
M-ATR High / Low - the stock touches the latest value calculated for its Monthly Average True Range - the expected range based on the stock’s own realized volatility
Analyst PT - the stock reaches the Mean Price Target determined by analysts (where this info is available)
Profit / Stop Target - these are custom values set by you in the Portfolio sheet
The Sectors / Factors Correlation Sheets
These sheets are only designed to work with the Equities sub-portfolio. They compute the 90-day weighted average correlation that the portfolio exhibits relative to the widely used Sectors and Factors ETFs.
You could use the output metrics to judge the diversification (or concentration) of a given set of stocks and adjust positioning according to your requirements.
The Removals Sheet
This sheet allows for a quick inspection of the portfolio for potential removal candidates, according to our screening rules. It will test all positions for Technical compliance, and individual equity positions for Fundamental compliance. ETFs will always “pass” the Fundamental screening.
Positions that pass the screening rules will display an “OK” message. A “WARNING” is displayed if they fail. This prompts the user to investigate the technical or fundamental aspect of that particular position.
How to use the tracker
General Considerations
Only the “Portfolio” sheet is designed for user input. You should not modify the other sheets (unless you know what you’re doing).
Metrics designed to be changed are marked with a teal color. These are:
Net Asset Value
Percentage Allocation Targets
Ticker
Actual Amount
Profit and Stop Targets
Set your Net Asset Value and Asset Class Targets
To start using the tracker, you should input the Total Portfolio Net Asset Value in cell C2, expressed as a dollar amount.
Then, set a percentage for each asset class, according to your requirements (eg. a 60% Stocks 40% Bonds allocation).
4. Click “ACTIVATE SPREADSHEET” (again)
Now that the script has permission to run, it will actually do something:
Modify the links in formulas to point at your newly created sheet
Set our developer account as editor to this sheet
Send us an email with the link to your new sheet so that we can set the database to refresh
5. Click the #REF! cell on row 23
After running the code, the Intro sheet will "self destruct”. You should see a “Success!” banner, and a #REF! cell on row 23. Click on it, and then click “Allow access”, in order to allow the sheet to import data from itself.
After granting access, you should see a confirmation message instead of the #REF! cell.
Customize the Portfolio Tracker
Scope
Setting up your own Portfolio Tracker spreadsheet to get faster insights from our database
Duration
30-60 minutes
Prerequisites
An activated Portfolio Tracker Spreadsheet
Deliverables
At the end of this activity you will learn how to use the Portfolio Tracker Spreadsheet.
Since you are now the owner of the document, you can easily modify it in order to fit your goals. The standard setup that we are offering is a very useful starting point, but this tool has the potential to be the most important feature of the entire platform!
Usage ranges from keeping track of the risk and correlations of your positions, creating “what-if” scenarios, and screening for potential stocks due for removal.
You can further tweak the spreadsheet to pull any metric from our database and even manage multiple portfolios.
Overview
All done on your end!
You can now start using the Portfolio Tracker! However, note the message on row 10, on the Portfolio sheet.
This document is initially shared with us, in order to set the database connection to refresh daily with the latest calculations. It takes 1 business day to perform this operation.
After completing it, we will let you know that the sheet is private, and remove ourselves from viewership.
Add / Remove Positions
To remove a position, simply right-click a ticker and select “Delete row”.
To add a position to the portfolio, click the “ADD NEW POSITION” orange button. This will run a script that adds a new row below the last position, and copies all that row’s formulas.
Make sure to keep the last position in a portfolio right next to the grey line, with no empty rows in between, as shown in the image.
Set Tickers, Actual Amount, Weighting and Targets
You can simply replace the demo tickers to begin with. The “Actual Amount” column represents the number of shares currently present in the portfolio.
For the Equities sub-portfolio, you can choose the weighting method. Equal Weight will set the “Target Amount” column to evenly split values. Risk Parity will take “beta to SPY” into account for setting values (it will overweight low volatility positions and underweight high volatility ones).
Finally, at the very end of the table (rows J and K), you will be able to set a Profit Target and a Stop Target for each position. Investing without targets is like driving blind, so we strongly encourage you to set these targets.
Something looks off?
Make sure Google Sheets fetches the latest data from our server by clicking the “REFRESH ALL CELLS” button. It’s something that should work by default 100% of the time, but in practice we’ve found the service fails occasionally.
It just needs a manual “nudge”.
Access your Portfolio Tracker
Scope
Setting up your own Portfolio Tracker spreadsheet to get faster insights from our database
Duration
5 minutes
Prerequisites
Your own Gmail account
Deliverables
At the end of this activity you will be the owner of a custom Google Sheet, connected to the Signal Sigma database. It will allow you to set stock and ETF positions in a simulated portfolio (which may or may not mirror your own).
By default, the sheet will reveal the portfolio’s risk, correlations to major Sector & Factor ETFs and screen for vulnerable positions.
Research clients can activate 1 such Portfolio Tracker. PRO clients have access to unlimited trackers.
Follow the steps outlined below to access the Portfolio Tracker
1. Create a copy of the Portfolio Tracker
Click the button below. This will prompt you to sign in to your Google account.
After you sign in, you will be asked to confirm the operation.
Click “Make a copy”. You can also inspect the Apps Script file that runs within the spreadsheet at this stage.
2. Wait, then Click “ACTIVATE SPREADSHEET”
Wait for the spreadsheet to finish loading, then click the button. If you do it too quickly, you might get an error.
3. Complete the authorization flow
You will need to grant the code contained in the spreadsheet permission to run. It is designed as a convenience to you. Click Continue.
Choose your account from the list.
Since you are now the owner of this spreadsheet, Google thinks you are its developer. Click “Advanced” in the bottom left corner.
Click “Go to Portfolio Tracker (unsafe)”
It’s 100% safe, trust us.
Click “Allow”. You can find details for the permissions requirement at the end the video above.
4. Click “ACTIVATE SPREADSHEET” (again)
Now that the script has permission to run, it will actually do something:
Modify the links in formulas to point at your newly created sheet
Set our developer account as editor to this sheet
Send us an email with the link to your new sheet so that we can set the database to refresh
5. Click the #REF! cell on row 23
After running the code, the Intro sheet will "self destruct”. You should see a “Success!” banner, and a #REF! cell on row 23. Click on it, and then click “Allow access”, in order to allow the sheet to import data from itself.
After granting access, you should see a confirmation message instead of the #REF! cell.
All done on your end!
You can now start using the Portfolio Tracker! However, note the message on row 10, on the Portfolio sheet.
This document is initially shared with us, in order to set the database connection to refresh daily with the latest calculations. It takes 1 business day to perform this operation.
After completing it, we will let you know that the sheet is private, and remove ourselves from viewership.
Scope
Knowing your portfolio’s correlations to the main investment themes and the dollar risk associated with various scenarios is essential in managing your positioning
Use the Portfolio Tracker
Duration
30-60 minutes
Prerequisites
An activated Portfolio Tracker Spreadsheet
Deliverables
At the end of this activity you will learn how to use the Portfolio Tracker Spreadsheet.
Since you are now the owner of the document, you can easily modify it in order to fit your goals. The standard setup that we are offering is a very useful starting point, but this tool has the potential to be the most important feature of the entire platform!
Usage ranges from keeping track of the risk and correlations of your positions, creating “what-if” scenarios, and screening for potential stocks due for removal.
You can further tweak the spreadsheet to pull any metric from our database and even manage multiple portfolios.
Overview
The Portfolio Sheet - Allocation and starting values
The Portfolio sheet is the only sheet that you should modify with your own values.
At the top, you will find the table containing target percentage exposures for each asset class sub-portfolio as well as the actual exposure metrics.
The Portfolio Sheet - Asset Class Sub-Portfolios
The main part of the spreadsheet is dedicated to keeping track of various instruments that can be assigned to a particular asset class sub-portfolio. This designation is really up to you and how you prefer to view your investments. Gold miner stocks can easily fit in the Gold asset class sub-portfolio, for example. You can even rename the sub-portfolios according to your own needs.
You will see this layout repeated across all of the other tabs in the spreadsheet, as we pull various metrics from our database and create visualisations and calculations pertaining to the positions.
The Equities Portfolio is the only different section, as it allows for Risk Parity position weighting. The Sectors and Factors sheets also treat this portfolio differently. All of the other sub-portfolios use equal-weight position weighting when determining “Target Amount”.
The Risk Explorer Sheet
This sheet allows you to view the risk in dollar amounts for each position as well as for the whole portfolio in different scenarios. You can also set your own Upside / Downside price targets for each stock, and see the aggregate values for those as well. Values are updated after market close.
This demo portfolio has the following risk and potential reward:
If all positions retrace to their 50-Day Moving Averages: loss of $2.494,44
If all positions reach their respective 52 week Highs: gain of $7.726,48
If all positions reach their Bollinger Bands lows: loss of $6.084,99
Scenarios calculated:
50 MA, 200 MA - a retracement to the 50-Day and 200-Day Moving Averages - this is a common technical occurrence
52wk High / Low - the stock reaches a new 1 year High or Low - another common scenario
BB High / Low - the stock touches the latest value calculated for its Bollinger Band - a 2 Standard Deviation move
M-ATR High / Low - the stock touches the latest value calculated for its Monthly Average True Range - the expected range based on the stock’s own realized volatility
Analyst PT - the stock reaches the Mean Price Target determined by analysts (where this info is available)
Profit / Stop Target - these are custom values set by you in the Portfolio sheet
The Sectors / Factors Correlation Sheets
These sheets are only designed to work with the Equities sub-portfolio. They compute the 90-day weighted average correlation that the portfolio exhibits relative to the widely used Sectors and Factors ETFs.
You could use the output metrics to judge the diversification (or concentration) of a given set of stocks and adjust positioning according to your requirements.
The Removals Sheet
This sheet allows for a quick inspection of the portfolio for potential removal candidates, according to our screening rules. It will test all positions for Technical compliance, and individual equity positions for Fundamental compliance. ETFs will always “pass” the Fundamental screening.
Positions that pass the screening rules will display an “OK” message. A “WARNING” is displayed if they fail. This prompts the user to investigate the technical or fundamental aspect of that particular position.
How to use the tracker
General Considerations
Only the “Portfolio” sheet is designed for user input. You should not modify the other sheets (unless you know what you’re doing).
Metrics designed to be changed are marked with a teal color. These are:
Net Asset Value
Percentage Allocation Targets
Ticker
Actual Amount
Profit and Stop Targets
Set your Net Asset Value and Asset Class Targets
To start using the tracker, you should input the Total Portfolio Net Asset Value in cell C2, expressed as a dollar amount.
Then, set a percentage for each asset class, according to your requirements (eg. a 60% Stocks 40% Bonds allocation).
Add / Remove Positions
To remove a position, simply right-click a ticker and select “Delete row”.
To add a position to the portfolio, click the “ADD NEW POSITION” orange button. This will run a script that adds a new row below the last position, and copies all that row’s formulas.
Make sure to keep the last position in a portfolio right next to the grey line, with no empty rows in between, as shown in the image.
Set Tickers, Actual Amount, Weighting and Targets
You can simply replace the demo tickers to begin with. The “Actual Amount” column represents the number of shares currently present in the portfolio.
For the Equities sub-portfolio, you can choose the weighting method. Equal Weight will set the “Target Amount” column to evenly split values. Risk Parity will take “beta to SPY” into account for setting values (it will overweight low volatility positions and underweight high volatility ones).
Finally, at the very end of the table (rows J and K), you will be able to set a Profit Target and a Stop Target for each position. Investing without targets is like driving blind, so we strongly encourage you to set these targets.
Something looks off?
Make sure Google Sheets fetches the latest data from our server by clicking the “REFRESH ALL CELLS” button. It’s something that should work by default 100% of the time, but in practice we’ve found the service fails occasionally.
It just needs a manual “nudge”.
Customize the Portfolio Tracker
Need to track other metrics for your portfolio?
Maybe you’d like to make sure your equity positions don’t exceed a certain P/E Ratio threshold. Or set the technical STOP levels above or below our standard setting.
Or maybe you’d like us to compute a totally different metric for your tracker. Whatever the request might be, we’ll do our best to accommodate it. If it can be derived from price or fundamental data, then we can display this for you. Use the form below to let us know what your particular needs are!