CANNAINVESTOR Magazine August / September 2017 | Page 52

52

Google-Docs is a free application that can be run on virtually any operating system with ease since it is cloud based. That also means you can share the file with anyone you choose. The spreadsheet can be saved in several formats such as an excel file but once done it may lose that live feed functionality. One could create a form with pop down menus and date selection options etc. Once you have it set up you can customize it yourself and there are countless free online tutorials to assist. This is an excellent source for needed commands and prompts.

I created such an Investment Analysis Form spreadsheet for you to use as an example learning tool only and selected companies from past and current issues of CannaInvestor Magazine. The companies selected are that there is live data to be seen and used only and it not an investment recommendation of any kind. It is read-only so you will need to copy it or save it into your own Google Drive first. There is a lead sheet with some notes and instructions and a final page that tracks the currency rates of the examples stocks included. There is one page that looks like a standard spreadsheet and is a good summary and several other pages that have been formatted to resemble Investment Analysis Forms if printed. Not all are the same as some track foreign exchange conversions and others have more manual entry information fields (management, growing market share, etc). Some of the TA graphs contain more information than others etc. Each form feeds primarily from that lead sheet so all you need do is replace the symbols and exchanges where warranted. Some fields on each form do require manual input (stock symbols on foreign exchanges, judgement factors, financial statement data, etc). These forms are not for commercial use or any form of non-personal use whatsoever. Again, these forms are not intended as an inferred investment decision and the stocks used were selected because they have been referenced at one time or another in CannaInvestor Magazine and/or reflect referenced strategies.