Investing Process and Tools
The process below is iterative and feeds back on itself.
- Do research to identify trends – long, medium, short term – then prospects that fit the trends;
- Make investments based on investment criteria;
- Learn from successes and failures and document;
- Adjust investment criteria, then invest again based on research.
Some links below are open and do not require login.
This process is for all levels of investing that I do, from early-stage startups to later-stage VC/PE backed pre-IPO and public companies.
- Info Sources Dataset (login required). Where research and data comes from. This dataset includes many free and paid sources, which I maintain and I cross-reference with most of the items below.
- Data Lake (login required). Structured and unstructured data where all base research gets deposited.
- Company/Investment Dataset (login required). Structured data on companies and specific investments, which contains structured info on them and links to that info in the Data Lake.
- Business ideas Dataset (login required). Business ideas I come across or think up on my own.
- Trends Dataset (login required). From research, trends roll into this dataset as a master overview. These are long-term trends.
- Focus Dataset (login required). Based on long-term trends (Trends Dataset), this dataset helps to narrow focus where I think I should be in terms of sectors, industries and specific markets for investment.
- Current Investment Themes. From my research in the Trends and Focus datasets, I create high level investment themes to help guide investment decisions. Investment Sub-Themes here.
- Future Planning (login required). Short-term outlook (less than 1-yr) that attempts to put the information contained in the Trends and Focus datasets along with possibilities and events (known or anticipated) to a calendar that affects me and requires action from me. This helps me think through and list actions to do ahead of time based on upcoming potential outcomes. This is a graphic like a Gant chart. While trends and focus datasets help narrow the where and why, this Gant chart attempts to layer on timing, or when to do the where/why.
- Q & A/Discussion Board (login required). Add Q&A and provide comments and discussion around any research in the datasets above.
- Unclassified Dataset. This dataset is where I compile information that I want to keep but which either does not necessarily fit anywhere else in my organizational structure, or is information that is likely to become obsolete in the future.
Investment Principles and Criteria
- Securities Investment Principles (login required). A dataset of timeless principles to help with securities investing that I add to and maintain.
- Investment Criteria and SOP’s. This details my investment criteria, including style, trading strategies and screens. I also include my standard operating procedures on what to do and when in terms of researching prospects, making and managing investments.
- Current Investment Strategy (login required). I roll up all my research into a summary document that defines my current investment strategy, including the specific investment themes I am targeting, the upside and downside risks, and how much I allocate to each theme.
- Decision Analysis (login required). This dataset includes investment prospects to choose from based on investment themes and risk/return calculations and projections. I also include fields to record results and analysis if successful or not and why.
- Investments Tracker (see template below). This spreadsheet tracks positions and near real-time results.
- Current investments. My current list of investment prospects from which to choose.
- Investments Tracker. When I sell an investment, its row data gets copied into the transactions list, as well as in the net income sheet to track overall profits and losses.
- Decision Analysis (login required). Once exited from an investment, I try to include why sold, outcome, and analysis. For long-term holds that not yet exited, I might update each prospect’s record entry with results to date and learnings.
- Focus Dataset (login required). Items get archived in same dataset where they live when they are no longer relevant.
- Investing Log. A Google doc that includes daily updates on what I do, learn, and what happens. Keeping a daily log helps me track the minutia of what I am doing, which I roll up as needed into the above datasets. See past weeks archives here (login required).
- Info Sources Report (login required). I track where all my information originates. This report counts the number of times an info source is referenced in my datasets. This helps me see which info sources are most valuable to track and keep my attention.
- Dataset/Database Documentation. Database architecture for the objects listed on this page.
- Soehnel Family Trust (login required). See this page for a link to the data lake for all trust administration folders and files.
- Investments Tracker. This link is the template for the Google Sheets/Excel file.
Sector/Industry Specific Research
- Healthcare Research (login required).
- Digital Assets Research (login required).