ManagerSheet
Welcome to ManagerSheet

ManagerSheet is an Open Source tool that analyses and presents an investment portfolio in one single page.



Link to image source
Concept

The idea with ManagerSheet is to analyse an investment portfolio and to provide a condensed, but still profound, view of a portfolio manager's investment profile on just one single sheet of paper (a one-page pdf-file), and thereof the name ManagerSheet.

Missing report example

(Open pdf-file)

On one single sheet, ManagerSheet provides an unbiased view of properties like e.g. style drift and trading contribution, which is crucial information for an investor, but also for the manager himself, but nevertheless, this kind of information is rarely covered in portfolio/fund reports.

All charts are more or less self-explanatory, but the Return Contributions chart may need some extra explanation. Here Trading is the sum of P/L of trades closed during the month, where a trade is defined as a buy/sell that is closed with a corresponding sell/buy within 63 business days, and Selection is implied by (i) Trading, and (ii) the market performance (Market), and (iii) the portfolio performance (Portfolio) during the month as follows. Selection = Portfolio - Market - Trading

Feedback is always welcome, and please note that the project currently is in alpha-state.

Download, Installation, Usage

In order to get going, please follow the steps below.

Download the file mnsh-version-[latest version].zip from Get ManagerSheet at SourceForge.net. Fast, secure and Free Open Source software downloads and extract.
Execute the Python-script run_mnsh.py which is found in the src-directory. (This assumes that all required Python modules already are installed.)

At this point data must be imported in order to create any report. The following steps will import a couple of test-files available in the src-directory. These files have only been constructed for the purpose of testing functionality. Anyway, these files are enough for creating a report, and one can inspect these files, and create corresponding files with one's own data in order to create one's own reports.

Import the file mnsh_test_instruments.csv with Instruments/Indices > Import from File
Import the file mnsh_test_market_data.csv with Data > Market Data File Import
Import the file mnsh_test_investment_styles.csv with Data > Investment Styles File Import

In order to continue with imports of portfolio specific information, such as positions and transactions, a portfolio must be created.

Create a portfolio with Portfolios > New Main and make the following selections in the dialog: Pick any name, e.g. "Test Portfolio"; Leave Key facts blank, or type in just something for the sake of it.; Set the Inception date to 2018-10-31; Select the only possible base currency, i.e. SEK; Select the only possible benchmark, i.e. URTH.
Answer "Yes" on the question whether you wish to initiate the new portfolio with positions and/or transactions.
In the Import Transactions and Positions from File dialog select the following files: Transactions file mnsh_test_transactions.csv; Positions file mnsh_test_positions.csv, and set the positions date to 2019-01-31.

Now we are set to create portfolio reports.

Create a portfolio report for Jan 2019, with Report > Create.

Now a portfolio report with the name report.pdf has been created, and can be found in the src-directory.

Disclaimer: This website (www.managersheet.org) is provided "as it is" without any warranties of any kind whatsoever.