Stock Share Price Analysis is a Google Sheets Add-on that offers automatic fair value calculations for stock share prices, trend analysis, and triggers for identifying trade points. It helps users determine when to buy, sell, or trade shares based on value.

The program uses current Google Finance data to determine the actual earnings per share, calculate fair value share prices and current price discounts. This creates a direct comparison of share price value. Additionally, index trend analysis is supported.
Furthering its usefulness, Stock Share Price Analysis also factors in estimated future stock share earnings and dividends from 4-traders.com to identify the future fair value share price and current price discounts.
Trend analysis is applied to historical share price data to calculate trend range, high and low trend prices. In turn, the program plots historical and current Price, Trend, High Trend, and Low Trend lines, identifying trade trigger points using High / Low trend prices, estimated future value, and the annual trend slope.
Lastly, the program allows for the calculation of current capital profit and future estimated dividend returns based on held portfolio data. With all this information, Stock Share Price Analysis provides the user with unique individual insight and an independent trading plan, identifying potential buy sell trade points like Fair Value share price, comparative share value, price and index trend analysis, High / Low trade triggers, and trend trade triggers.
Version 1: new