This tool allows you to upload a portfolio as a CSV or Excel file, or manually type in a portfolio to analyze it and test out ideas.
Disclaimer: All results are based on approximate historical data and are for informational purposes only. No guarantee is made as to the accuracy, completeness, or applicability of the results. Use at your own risk. This is not financial advice and is not guaranteed to be accurate.
This does not currently account for tax impact.
Use one of the following two options to input your portfolio:
Option 1: Use the "Choose File" button to select a CSV or Excel file from your computer (wait until its filename appears to the right of "Choose File").
Data must start in cell A1.
The file must have at least one of the following column sets:
"Symbol", "Current Value", "Total Gain/Loss Dollar" (such as from a Fidelity Positions download),
OR "ticker" and "amount".
Extra columns can be left in place; column names are case-sensitive.
Click "Read Excel" immediately after choosing the file to populate the table with the "Ticker", "Current", and "Proposed" columns. These values are percentages, and the total is shown at the bottom. The "Current Value $" - Total Portfolio Value - is displayed in a box above.
Option 2: Manually type in tickers and their "Proposed" weights, ensuring the weights add up to 100. Then enter the Total value of portfolio as "Current Value $" in the box above the buttons.
You can edit the "Proposed" column to change allocations, and add new tickers at the bottom of the table with their proposed percentages. Ensure that the total remains close to 100%.
The "Compare Ticker" field (default "SPY") allows you to compare your portfolio to another symbol.
The "Default Ticker" field (default "SHY") is used when data is missing for any given ticker (for cash holdings, a 1-month Treasury is substituted).
The "Years" field (default "3") controls how far back the analysis will go.
Clicking "Plot" will generate a graph and display a table summarizing key portfolio metrics and recommended trades.
The "Show Var" option displays a 21-day daily moving Value-at-Risk at 95% confidence, serving as an approximation for the worst monthly percent loss with 95% probability.
The "CPI Adjusted" option shows returns adjusted for inflation.
The "Bar Chart" toggle changes the graph to a bar chart (the "Show Var" option is ignored in this case).
You can repeat the process as needed. Clicking "Save to Excel" saves the proposed portfolio and results in an Excel file. Clicking "Results as PDF" downloads the results as a PDF file.
Other ways to specify years are:
Year - eg: 2022 will use data from 1/1/2022 to 12/31/2022
Year range : eg: 2021-2023 or 2021-23 will use data from 1/1/2021 to 12/31/2023
YTD : year to date
Years : 2 will show data from 2 years ago, 2.3 will data from 2.3 years ago, 3.5-6 will show data from 6 years to 3.5 years ago
Months : 3M will show data from 3months ago, 3M-7M will show data from 7 months ago to 3 months ago