This morning, upon logging in to review my Stock Portfolio Tracker, I noticed a present surprise.
For those who are new to this site, Stock Portfolio Tracker helps investors keep track of their long term dividend stock holdings, showing buy, sells, dividends and splits by transactions. The spreadsheet is entirely free and donation funded.
You can view the spreadsheet [here] and how to use it [here]. If you wish to donate to keep it alive you can help me [here].
Google spreadsheet added a feature that exist in excel called Named and Protected Range. You can view what it does [here].
I thought it’s a great feature as it can name a range of cells and mark it for data validation.
With that I can set the Stock Name data validation to “=StockName”, Every time I change the range from cell A1:A10 ...
...