Help‎ > ‎mStocks Help‎ > ‎

Advanced Positions - Portfolios

posted Nov 22, 2015, 5:41 PM by Admin Manager   [ updated Dec 5, 2015, 6:16 PM ]
Here is where things get fun. mStocks+ has full stock portfolio support that rivals many of the portfolio management apps in the App Store.  We call this Advanced Positions.  We'll show you how how to use Advanced Positions in this help topic.

In the overview of Basic Positions you saw that you only needed to enter the number of shares and cost basis for a symbol to have mStocks+ provide position data. In the case of Advanced Positions, this gets a little more complicated but the results are so much better.

Advanced Positions requires that you tell mStocks+ about each transaction that you have made for each symbol that you have a position in. This means that you would enter all Buy, Sell, Dividends, etc... transactions.  From this, mStocks knows a great deal about your position including what has happened over time.  This allows for better charting and return results over the full time period that you have owned positions.

Advanced Positions supports the following transaction types:

 DEPOSIT Cash deposits made on a portfolio
 WITHDRAW Cash withdrawals made on a portfolios
 BUY Buy stock transactions
 SELL Sell stock transactions
 SPLIT Stock splits
 DIVIDEND Stock cash dividends
 REINVESTMENT Stock reinvestment dividends
 INTEREST Interest earned on a portfolio or stock
 EXPENSE Expenses incurred on a portfolio or stock

- - - - - 

To create an Advanced Position, click on the Portfolio Icon on the Main Window.  The Manage Portfolio and Transactions window will open as shown below.

Portfolio Management

    

Before you enter transactions, you need to create a portfolio.  Do this by clicking on the "New.." button and give the portfolio a name.  

Adding transactions is done by either right clicking on the transactions list and picking the transaction type from the popup menu or by clicking on the "New Transaction..." popup option below the transactions list. Once you pick the transaction type, the appropriate window will open allowing you to enter settings appropriate to the transaction. We go over the Buy and Sell transactions here. You'll find the other transaction's settings are pretty similar.

You can edit the name of a portfolio by double clicking on it and changing the name.

You can delete a portfolio by right clicking on it and picking the "Delete" menu option. Note that all transactions will be deleted as well.

You edit transactions by double clicking on the line or by right clicking and picking the "Edit.." menu option. Make the changes to the transaction and then press the save button.

You can delete a transaction by right clicking on it and picking the "Delete" menu option.

mStocks+ supports importing and exporting of transactions. Exporting is pretty straightforward.  There is an separate help topic on importing. 

BUY Transaction

A Buy Transaction lets mStock+ know of a position that you hold in a given symbol. The fields that you need to enter are:
  • Transaction Date - the date you bought the shares.
  • Shares - the number of shares you bought.
  • Price - the price you paid per share.
  • Transaction Fees - any brokerage fees that you paid.
  • Exchange Rate - the exchange rate to convert this symbol back to the Base Currency set in preferences. This will default for you and you should not need to change this unless you are recording a buy transaction in the past that had a different exchange rate.
  • Notes - any notes that you would like to capture for this transaction.
You can change the symbol that you are "Buying" by picking a new one in the drop down list at the top of the screen.  You can also change the portfolio on which the transaction should be added by picking a new portfolio or clicking on the portfolio icon to create a new one.

    

Click "Save" when you are done and the transaction will be added to the portfolio.

SELL Transaction

A Sell Transaction lets mStock+ know that you reduced a position in a symbol. The fields that you need to enter are:
  • Transaction Date - the date you sold the shares.
  • Shares - the number of shares you sold.
  • Price - the price you received per share.
  • Transaction Fees - any brokerage fees that you paid.
  • Exchange Rate - the exchange rate to convert this symbol back to the Base Currency. This will default for you and you should not need to change this unless you are recording a buy transaction in the past that had a different exchange rate.
  • Sales Method - the model that you want mStock+ to use to allocate this sale to existing lots.
  • Lots - the specific lots that will be updated by the sale.
  • Notes - any notes that you would like to capture for this transaction.
You can change the symbol that you are "Selling" by picking a new one in the drop down list at the top of the screen.  You can also change the portfolio in which the transaction should be added by picking a new portfolio or clicking on the portfolio icon to create a new one.

By default, a Sell transaction will use the FIFO Sales Method. This means that the Sell transaction will apply sold shares to the oldest outstanding Buy transactions.  You can also pick LIFO.  This will apply the sales to the most recent Buy transactions.  If neither of these work for you, you can pick "Specific Lots" in the Sale Method and identify specifically how the sold shares should be distributed across the outstanding Buys.

If you are using "Specific Lots", you need to edit the Sell Action column in the Lots table to specify how many shares should be sold against each lot.  Double click on the Sell Action field and edit the value.

    

Click "Save" when you are done and the transaction will be added to the portfolio.

Additional Transactions

DEPOSIT and WITHDRAW - Use these transactions to add or remove cash to/from your portfolio. Enter the date of the transaction and the amount of cash and press Save to record the transaction.

REINVESTMENT - this transaction is very similar to a BUY and the same field are entered. Use a Reinvestment Transaction to record a dividend in which additional shares were purchased.

DIVIDEND - records a transaction that recognizes a cash dividend for a particular symbol. Enter the date of the dividend and the amount received. Dividend transactions change your cash position.

EXPENSE - records a transaction to acknowledge an expense you incurred against a specific symbol or in general. For general expenses, don't select a symbol in the symbol drop down. Instead, select "No Symbol - Portfolio Based". Enter the date and amount. Expense transactions change your cash position.

INTEREST - records a transaction to acknowledge interest you received for a specific symbol or in general. For general expenses, don't select a symbol in the symbol drop down. Instead, select "No Symbol - Portfolio Based". Enter the data and amount. Interest transactions change your cash position.
Comments