Investments

Helps you with managing your investments:

• Portfolio rebalancing: instructs you which orders you have to submit to make your portfolio in order with your asset allocation.
• Stock selling simulation: calculates revenue, profit, taxes and real profit percent which considers taxes into account.
• Automatic tax statement generation: reads broker statements and alters *.dcX file (created by Russian tax program named Декларация) by adding all required information about income from stock selling, paid dividends and idle cash interest.
• Analysis: calculates average rate of return from cash investments by comparing portfolio performance to performance of a bank deposit in USD and RUB currency with exactly the same investments and monthly capitalization. Considers taxes, commissions, dividends and tax deductions when calculates portfolio performance.
• Bank deposits control: view opened bank deposits all in one place and get notified about upcoming deposit closures.

Targeted for Russian investors who use Interactive Brokers, Открытие Брокер or БКС.

Installation

1. Install Rust - https://www.rust-lang.org/tools/install
2. Install build dependencies:

macOS:

No action required.

Ubuntu:

$ sudo apt install libsqlite3-dev

3. Compile the project:

$ git clone https://github.com/KonishchevDmitry/investments.git
$ cd investments
$ cargo install --path . --bin investments

Use the following command to recompile the project after update to a new version:

cargo install --path . --bin investments --force

Configuration

Create ~/.investments/config.yaml configuration file (example). Don't forget to obtain API token for Alpha Vantage (see the comments in example config).

Usage

Stocks

Investments is designed to work with your broker statements - there is no need to enter all trades and transactions manually, but it requires you to have all broker statements starting from account opening day. It may be either one broker statement or many - it doesn't matter, but what matters is that the first statement must be with zero starting assets and statements' periods mustn't overlap or have missing days in between.

For now only the following broker statements are supported:

• Interactive Brokers (*.csv)
• Открытие Брокер (ИИС, basic support) (*.xml)
• БКС (basic support) (*.xls)

Investments keeps some data in local database located at ~/.investments/db.sqlite and supports a number of commands which can be grouped as:

• Analyse commands (analyse, simulate-sell, tax-statement) that read your broker statements and produce some results.
• sync command that reads your broker statements and stores your current positions to the local database.
• Portfolio rebalancing commands (show, rebalance, cash, buy, sell) that work only with local database.

Local database is required for portfolio rebalancing because during rebalancing you submit buy/sell orders to your broker that modify your portfolio (free assets, open positions) and this information have to be saved somewhere until at least tomorrow when you'll be able to download a new broker statement which will include the changes.

Here is an example of main commands output:

The screenshots are blurred for privacy reasons since they require a real broker statement, but I can emulate sync command by executing the following commands with a random fake data to provide a full example of show and rebalance commands:

$ investments buy ib 100 VTI 4000
$ investments buy ib 30 VXUS 4000
$ investments buy ib 40 BND 4000
$ investments buy ib 60 BNDX 4000

With these commands executed and provided example config we'll get the following results for show and rebalance commands:

Rebalancing actions in this case are assumed to be the following:

1. View the instructions: investments rebalance
2. Buy 50 VXUS using broker's terminal, got $current_assets left on your account
3. Commit the results: investments buy ib 50 VXUS $current_assets
4. View the instructions: investments rebalance
5. Buy 12 BNDX using broker's terminal, got $current_assets left on your account
6. Commit the results: investments buy ib 12 BNDX $current_assets
7. View the instructions: investments rebalance
8. Buy 9 BND using broker's terminal, got $current_assets left on your account
9. Commit the results: investments buy ib 9 BND $current_assets
10. View the result: investments show

This iterative trading is not required - you can look at the results of investments rebalance and submit all orders at once, but it leaves a chance to spend more than you supposed to in case of highly volatile market. In practice, the simplest strategy here in case of relatively small price of all stocks - submit all orders except the last (one / two / few), commit the current result, execute investments rebalance and submit the rest.

Deposits

Deposits are controlled via deposits command. You register your opened deposits in the configuration file and then execute investments deposits to view them all in one place:

$ investments deposits

                            Open deposits

 Open date   Close date    Name     Amount   Interest  Current amount
 19.06.2019  19.03.2020  Тинькофф  465,000₽         7     473,343.49₽
 21.06.2019  21.06.2020  Тинькофф  200,000₽       7.5     203,763.08₽
                                   665,000₽               677,106.57₽

This command has a cron mode (investments deposits --cron) which you can use in combination with notify_deposit_closing_days configuration option. For example, if you create a cron job and configure it to send the command output to your email, then on 11.06.2020 having notify_deposit_closing_days: 10 you get an email with the following contents:

The following deposits are about to close:
* 21.06.2020 Тинькофф: 200,000₽ -> 215,570.51₽

The following deposits are closed:
* 19.03.2020 Тинькофф: 465,000₽ -> 490,013.27₽

Recommendations

Download broker statements periodically and run the tool against them to be sure that it's still able to parse them and won't fail when you'll need it.

Generate tax statement in the beginning of March. Interactive Brokers sometimes adds corrections to their mid-February statements and if you generate tax statement earlier, it may contain inaccurate data.

Unsupported features

The program supports only those cases which I saw in my broker statements (or statements sent to me by my friends), which I assured to be handled properly and wrote regression tests for. For example, the following aren't supported yet:

• Bonds
• Futures
• Stock split
• Currencies other than USD and RUB

Denial of responsibility

The project is developed as a pet project, mainly for my personal use. The code is written in a way that if it finds something unusual in broker statement it returns an error and doesn't try to pass through the error to avoid the case when it will get you to misleading results, so there are many cases that it's not able to handle yet and I can't guarantee that I'll find a free time to support your specific case.