Investments Workbook Tab: Estimates (Windows 365)

$25.00

The Estimates Excel spreadsheet tab is used to estimate earnings based on price per share you purchased, and the current price. It is also useful as a research tool to refer back to as necessary. Typically you keep the first 5 slots for active trades, and the remainder of the spreadsheet becomes a running record of stocks you’ve considered. Please choose your document set up option below:

  1. I have a Microsoft 365 subscription and I use Microsoft Excel: Select the Microsoft 365 option.
  2. I don’t have or want to pay for Microsoft 365, so I’ll be using FREE Google Sheets and Google provided real time pricing.
  3. I don’t have or want to pay for Microsoft 365, but I want to use Microsoft Excel and Google provided real time pricing.

Description

Your investment workbook will contain a number of tabs that help you manage your portfolio and trading.

The Estimates Excel spreadsheet tab is used to estimate earnings based on price per share you purchased, and the current price. It is also useful as a research tool to refer back to as necessary. Typically you keep the first 5 slots for active trades, and the remainder of the spreadsheet becomes a running record of stocks you’ve considered.

For Example

  • You’re worrying about selling at $34 rather than $34.50. The estimator let you enter up to 4 hypothetical prices in the “If it Hits” columns. This way you can enter both and see the difference. You may then decide that waiting for $34.50 isn’t really worth it, and you can execute the sale and take your profits. Alternately, you may decide the difference in earnings is worth waiting.
  • You have $500 to invest and want to know which stock might bring the most earnings. You can enter several symbols with $500 as the budget and determine which is the best route, based on current price movement.
  • You want to keep an eye on a particular stock, so you enter the amount you might invest, the price you want to pay in the Cost per Share field, and then you wait and see it/when it reached your original amount. “I was looking at this way back when it was $10 and now it’s $42! Or it’s $8.25 and time to buy!”
  • You want to know approximately what you will earn after taxes.
  • You have several stocks in play and want to see them all at once and estimate earnings at different price points.
  • Enter notes about symbols that help you when you’re considering entering a position.
  • You might study a stock in January and enter notes, then in June, there’s news about the stock, you can go back to your Estimate tab, search the symbol and see if you have any notes that can help with a decision to enter a position.

 

Investments Workbook Tab: Estimates (Windows 365)

Additional information

Version

Microsoft 365 paid subscription required to populate real time stock prices, must use Excel.

Reviews

There are no reviews yet.

Be the first to review “Investments Workbook Tab: Estimates (Windows 365)”

Your email address will not be published. Required fields are marked *

Scroll to top