M1 Finance allows you to utilize long-term focused investment management. To ensure the proper investments are selected and intelligently allocated, I export my holdings, using excel and google spreadsheet to analyze each holdings. Below are the steps.
- Locate the “Holdings Page”
2. Filter Useful Information
From the holdings page, I drag the holdings (the entire page) to my automated excel sheet. M1 only allows you to drag an ‘image’ of the page so a mess is produced when dropped into excel, and automatically cleaned up by my sheet.
Explanation of Local Spreadsheet:
- Left: the dragged and dropped mess from M1 Finance
- Middle: simple filtering to remove the images and pull relevant data
- Right: final filtering to get the ticker, shares, and average price
- key code sample:
- =IFERROR(INDEX($J$2:$N$443, 1+(CELL(“row”, Q1))*4, 2), “”)
- key code sample:
3. Copy the Right column to a Google Spreadsheet and Analyze
The google sheets are a convenient way of gathering financial attributes of each ticker. This data can be obtained through GOOGLEFINANCE itself or, through formulas, be pulled from other websites.
Below is a sample analysis from 9/22/2019.
Column P, Q, and R from the excel spreadsheet is copied to column A, B, and C — then the spreadsheet does the rest automatically. The only subjective input currently is column N.
Today was not wasted. Moving forward, what used to be a gut-wrenching manual process is now automated. Now, I drag and drop my holdings as can make a decision when needed.
Next Steps:
- Pull in other key inputs to help make a more informed decision (example: Tipranks “Smart Score”; Fair /Intrinsic Value”, etc.)
- Continue organizing with your feedback, of course!
Please share your thoughts!
3/29/2020 Update!
Below are a few updates to the columns tracked.
Within the same workbook, I added a aggregate data on how each sector in my portfolio is performing…
Google sheets allows for streamlined portfolio management. Feel free to reach out if you wish to obtain a copy of the spreadsheet or see fully what was discovered in the above sheet, blocked by a random RStudio window, sorry.
Cheers!
