Or to work with mutual funds, where one can buy and sell fractional shares and not pay per-transaction fees at all. * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.Like Knuckle-Dragger suggests in the comments, there are ways to get real-time quotes. Sure, slightly, just as buying one more share would always lower the per-share cost if you're being charged per transaction.
You can insert the live market price, EPS, PE, 52-week high, book value, or any other of over 80 quotes into a cell with this VBA function.
The data updates to reflect current market values when you re-open or re-calculate your spreadsheet.
The function takes the form The Yahoo Finance API offers over programmatic access to over 80 types of financial data.
The spreadsheet contains a full list of the types of financial data, and the corresponding value of the second argument.
Employing Excel’s conditional formating tools, you could highlight the cell that contains the lowest PE for a group of stocks, or filter out companies with a low dividend yield.