Core Position Trading Buy Low Sell High Stock Trading ETF Trading | AIM for Stocks and ETFs Position Overview Spreadsheet User Document

Introduction and Background
To Screenshot Link
Spreadsheet Cell Contents Information
    Sheet 1
    Sheet 2

Additional AIM Information Sources

(to User Doc for old S/S)

This spreadsheet is where you can summarize your AIM Account (AC) holdings and other AIM information, price information, and your next AIM BUY and SELL trigger prices, etc.  It does not "tell" you what to do; it is for your record keeping, including seeing how you are doing.  It does not replace the running transaction histories and calculations spreadsheets/worksheets you keep for each AC (whatever you use similar to those shown in the Lichello book).

This version of the User Document is for version 3.0 or later of the spreadsheet "aim_position_overview-v3d0.ods and .xls", which is provided free with your AIM Buy-Sell Transaction Calculator Program Purchase.

I update my copy of the spreadsheet after each AC transaction with new values of cash, shares held, transaction price, next BUY and SELL price, Portfolio Control (PoCo), etc., for the particular AC.  Weekly, I update the recent prices (usually Friday's closing prices) and the 52-week highs and lows.

An AIM Account (AC) is ONE stock, Exchange Traded Fund (ETF), or other mutual fund.  Each AC has its own column in the spreadsheet.  In a brand new copy of the spreadsheet, these columns are labeled BBB, CCC, DDD, etc.  Replace any or all of those with the symbol(s) for your ACs, e.g., HL, HMY, SSRI, whatever.

The spreadsheet is protected, so you cannot type letters or numbers into any cell containing a formula or some headings.  You can unprotect the sheet if you wish.  If you don't know how to unprotect the sheet (no password is required), you shouldn't be thinking about doing that anyway.

The leftmost column contains the row titles, which are referred to in the details below.

Sheet 1 is for current information.
Sheet 2 is for if you are curious as to what your gain (or loss) would be, after various transactions, if the price returned (up or down) to the price of your original AC establishing transaction(s).

Position Overview spreadsheet -- Click here for screenshot

Sheet 1

Symbol:
You should replace BBB, CCC, DDD, etc., with your AC symbols.  Make any unused cells blank.

Note Ref:
DON'T CHANGE THESE.
They refer to any notes you may care to make at the bottom of the table.

Trade Method:
You can change these cells or make them blank.  If you use different variations of AIM for different ACs, you might change some cells to, e.g., AIM1, AIM2, or whatever.

Next Sell Price:
These are the prices for your next AIM SELL as you have calculated.  Make any unused cells zero (0).

Next Sell Qty:
These are the quantities for your next AIM SELL as you have calculated.  Make any unused cells zero (0).

Net Proceeds:
CALCULATED -- DO NOT CHANGE.
Uses Next Sell Price and Next Sell Qty.  Does not include commissions.

Next Buy Price:
These are the prices for your next AIM BUY as you have calculated.  Make any unused cells zero (0).

Next Buy Qty:
These are the quantities for your next AIM BUY as you have calculated.  Make any unused cells zero (0).

Net Cost:
CALCULATED -- DO NOT CHANGE.
Uses Next Buy Price and Next Buy Qty.  Does not include commissions.

52 Week Hi:
High price for the last year, as found on Yahoo, your broker site, etc.  Optional.  Make any unused cells zero (0).

Recent Price:
The price "right now", at the end of the day, the end of the week, whatever.  Used in formulas in other cells.  Make any unused cells zero (0).

52 Week Lo:
Low price for the last year, as found on Yahoo, your broker site, etc.  Optional.  Make any unused cells zero (0).

Recent Stock Value:
CALCULATED -- DO NOT CHANGE.
Uses the Recent Price and Shares Total.

Cash:
After each transaction, you will have spent or received some cash.  Update the current total with the transaction amount, including commission.  Make any unused cells zero (0).

Total Value:
CALCULATED -- DO NOT CHANGE.
Uses the Recent Stock Value and Cash.

Capital:
Capital is the money you set up a particular AC with.  Make any unused cells zero (0).
Capital is not the same as Cash.  Capital is what you set up an AC with.  Some of that capital goes into your initial stock position in the AC.  Some remains in the Cash Reserve (Cash) for that AC.  BUY and SELL transactions in an AC do NOT affect the Capital.  BUY and SELL transaction in an AC do, naturally, effect the Cash.  If you add money from "outside" the AC to the Cash or take money out of the AC Cash to "outside", that amount is added to or subtracted from the AC Capital.

$ Gain / Loss:
CALCULATED -- DO NOT CHANGE.
Uses the Total Value and Capital.

% Gain / Loss:
CALCULATED -- DO NOT CHANGE.
Uses the Total Value and Capital.  Expressed as a percentage.

% G / L Annualized:
CALCULATED -- DO NOT CHANGE.
Uses the Total Value and Capital, and the Initial Date vs "Today's Date".  Expressed as a percentage.

AIM PoCo:
This is the latest Portfolio Control value you have calculated for the AC.  Optional.  Make any unused cells zero (0).

Shares (Broker 1):
Shares in the AC held by Broker 1.  Make any unused cells zero (0).
The Heading "Shares (Broker 1):" can be changed to "Shares ([your broker name]):"

Shares (Broker 2):
Shares in the AC held by Broker 2.  Make any unused cells zero (0).
The Heading "Shares (Broker 2):" can be changed to "Shares ([your broker name]):"

Shares Total:
CALCULATED -- DO NOT CHANGE.
Total of Shares (Broker 1) and Shares (Broker 2).

Cost / Sh:
CALCULATED -- DO NOT CHANGE.
Uses Cash, Capital, and Shares Total.

Cash / Total Val:
CALCULATED -- DO NOT CHANGE.
Uses Cash and Total Value expressed as a percentage.  Some AIMsters use this in deciding whether or not to adjust PoCo if there is "too much" cash in a particular AC.  I am investigating the appropriate use of this factor, if any.  Cell color turns yellow if value is greater than 30%.  Cell color turns red if value is negative.

Note X:  (XXX)
Any notes you care to make about a particular AC.

Sheet 2

Date Order:
CALCULATED -- DO NOT CHANGE.
Rank of Initial Dates of ACs, oldest to newest.  Any unused cells will be filled automatically as "#N/A".

Initial Date:
Enter the date of the original AC establishing transaction.  In unused cells, put a date earlier than any of the used cells (e.g., "1998-01-01")

Initial Price (IP):
Enter the price of the original AC establishing transaction, or the average price if more than one transaction was made in establishing the AC.  Make any unused cells zero (0).

All Other Cells:
CALCULATED -- DO NOT CHANGE.
The calculated values correspond to those on Sheet 1, except these values on Sheet 2 are based on the Initial Price instead of the Recent (Current) Price.

Robert Lichello's "Automatic Investment Management" (AIM) ground-breaking book
How to Make $1,000,000 in the Stock Market -- Automatically!

Tom Veale's AIM Users Website

Investors Hub AIM Forums

Tags:   AIM users,  Automatic Investment Management (AIM),  buy low sell high,  Core Position Trading (CPT),  PoCo,  Portfolio Control (PoCo),  Robert Lichello,  Tom Veale, 

Core Position Trading
Main Page

Core Position Trading

Core Position Trading Overview
Core Position Trading Alternative to Technical Analysis

Automatic Investment Management (AIM) Basics

Automatic Investment Management (AIM) Basics
Volatility is Your Friend™
Fixed Commissions Effects and AIM
AIM Anomalies
SAFE and Quantity to Sell at Various Prices (chart)
SAFE, PoCo, Prices, and Minimum Orders (charts)

AIM Stock & ETF Trading Transaction Calculator

AIM Stock & ETF Transaction Calculator Description
* ORDER Stock & ETF Transaction Calculator *

AIM Transaction Calculator User Document
AIM Stock & ETF Trading Account Setup
Price Move Required for AIM Stock or ETF Transaction
Commission Effects on Transaction Prices and Amounts
AIM Transaction Calculator Price Range Calculation
Price Range Calculation for Desired Percent Price Move
VEALIES - Adjusting AIM Account Portfolio Control
Indexing Portfolio Control for Inflation (Cost of Living)

AIM Stock & ETF Position Overview Spreadsheet
Position Overview Spreadsheet User Document (old)
Position Overview Spreadsheet User Document (new)

Lichello's 'By the Book' Trade History Spreadsheets

AIM 'By the Book' Trade Spreadsheets Description
* ORDER AIM Trade History Spreadsheets *

AIM e-gold Trading Transaction Calculator

Because of actions by the increasingly out-of-control fascist U.S. Government, the AIM e-gold transaction software is no longer usable.  Regardless, you may be interested in some of the information about gold, money, and government fiat currency debasement that robs you of capital and purchasing power on those pages linked to from this section, especially in the User Document.

AIM e-gold Trading Transaction Calculator Description
* ORDER e-gold Transaction Calculator *

AIM e-gold Transaction Calculator User Document

All

All,  AIM account,  AIM users,  asset allocation,  Automatic Investment Management (AIM),  bid-ask spread,  buy and hold,  buy and hope,  buy low sell high,  cash reserve,  commission costs,  commissions,  Consumer Price Index,  Core Position Trading (CPT),  CPI,  depreciating asset,  e-gold,  ETF,  ETF commissions,  ETF trading,  exchange traded funds (ETFs),  fascism,  fascist U.S. government,  Federal Reserve,  fiat money,  fundamental analysis,  gold,  government harassment,  GTC limit orders,  GTC orders,  hold zone,  inflation,  inflation indexing,  Jekyll Island,  limit orders,  market orders,  net transaction price,  New World Order (NWO),  platinum,  PoCo,  Portfolio Control (PoCo),  precious metals,  price range calculation,  Robert Lichello,  SAFE,  silver,  spreadsheet studies,  square root volatility,  SRV,  stock price moves,  stock price range,  stock trading,  stock trading commissions,  stock transaction price,  stock value,  support and resistance,  technical analysis,  Tom Veale,  trading range,  trend lines,  VEALIE, 

NOTICE!
Since the 1st Amendment to the U.S. Constitution is null and void,
except as still permitted by law by out-of-control U.S. federal, state, and local governments, the following disclaimer is provided:

This web page or web site is not to be construed as providing investment advice.  This material is provided for informational, amusement, and educational purposes only.  Consult a duly (dully) trained, authorized, credentialed, licensed, and brainwashed establishment professional or government lackey before engaging in any financial transactions relying on this or any other information.