Weekly maintenance every saturday 03:00 - 06:00 UTC

Welcome to Asset master website, a fast, reliable, affordable and, AFAIK, the most advanced portfolio optimization website!

The following features supported at the moment:

Stock data timeframe (period): Daily

Ability to choose the time horizon for optimization / statistics calculation

View the expected return / volatility for all stocks included in the list for optimization.

Export optimization report to XLSX.

Expected returns calculation:

- Mean historical return.
- Exponentially weighted mean historical return.
- CAPM estimate of returns.

Covariance matrix calculation:

- Fix non-positive semidefinite matrices.
- Sample covariance.
- Semicovariance.
- Exponentially weighted covariance.
- Shrunk covariance matrices:

- manual shrinkage
- Ledoit Wolf shrinkage
- Oracle Approximating shrinkage

- Black-Litterman allocation.

The optimization methods:

Mean-Variance optimization.

- minimum of volatility
- maximum of Sharpe ratio
- maximum of the quadratic utility, given some risk aversion
- maximum of return for a given target risk
- minimum of risk for a given target return

Semivariance optimization.

- minimum of semivariance
- maximum of the quadratic utility, given some risk aversion
- maximum of return for a given target risk

CVaR and CDaR optimization.

- minimum of CVaR or CDaR
- maximum of return for a given CVaR or CDaR
- minimum of CVaR or CDaR for a given target return

- All of these methods support L2 regularization also.

Quickstart:

1.
2.
Unzip the downloaded zip archive. There will be two folders - all_stock_data folder which contains the example files with all the stock prices, etc... to optimize portfolio not using the website's stock data, and universe_data folder which contains the file with list of tickers - tickers.csv to optimize portfolio using the website's stock data, and two files - viewdict.csv with view data and confidences.csv with confidence data for the Black - Litterman model. Now go to the Optimize portfolio page (the link is located at the left sidebar).
3. Optimize portfolio
Example of calculation using the internal data source:
  1. Ensure that Upload the stock data from my computer (use intrinsic stock data source if unchecked) checkbox is unchecked.
  2. Ensure that Use close prices for statistics calculation (use the adjusted close prices if unchecked) checkbox is checked. You can leave this checkbox checked if you like, but in this case you will use the adjusted close prices instead of close prices.
  3. Click button Choose File right under caption Choose stock universe file.
  4. Choose the tickers.csv file from the uploaded earlier universe_data folder.
  5. Ensure that value of Choose type of calculation of mean returns and covariance matrix control value set to Independent.
  6. Ensure that value of Choose type of mean historical return calculation control set to Mean historical return.
  7. Ensure that value of Choose type of covariance matrix calculation control set to Sample covariance.
  8. Ensure that value of Choose optimization method control set to Mean - variance optimization.
  9. Ensure that value of Choose optimization type for Mean - variance optimization control set to Minimize volatility.
  10. Click the button Optimize at the bottom of the page.
  11. After you see the message Now you can take a look at your optimization result at the log window, check if there were warnings.
  12. Click the Optimization result... button to view you optimization results. Note that you can sort or search your optimization result tables. To search table enter your search sequence in the Search field, to sort the table by column values mouse-click the corresponding column header. Click the button Export report to XLSX to export the page data to XLSX file.

Example of calculation using own data files:
It's basically the same procedure, with one difference - you have to check the checkbox Upload the stock data from my computer (use intrinsic stock data source if unchecked), click the button Choose file under the Choose stock data folder caption and choose the all_stock_data folder from the unzipped archive you uploaded earlier.
File description.
Folder all_stock_data:

- adj_clos.csv is a csv file with historical prices for stocks.
- close.csv is a csv file with close prices for stocks for previous day.
- index_prices.csv is a csv file with index prices for some index used for Black - Litterman model calculation.
- viewdict.csv is a csv file with expected return views data for Black - Litterman model calculations.
- confidences.csv is a csv file with view confidences data for Idzorek model calculations.
- mcaps.csv is a csv file with market caps data for Black - Litterman model calculations.
- sector.csv is a csv file with sector data for stocks.
- data_info.csv is a json file with version data and index symbol.

Folder universe_data:

- tickers.csv is a csv file which contains a list of tickers to use in the portfolio optimization.
- viewdict.csv and confidences.csv files have the same meaning and format as the ones for all_stock_data folder.

All the files, except the data_info.csv file, can be edited either with some XLSX editor (for example with the LibreOffice Calc) or with a text editor. The data_info.csv file can be edited with a text editor.

If you have a questions or bug reports, feel free to contact me either with contact email or redirecting by the link "Ask a question", which is located on the left sidebar (but you should register on github for this).