Stock Share Price Analysis

Stock Share Price Analysis is a Google Sheets Add-on with automatic stock share price fair value calculations, trend analysis and high/low triggers to identify value buy sell trade points.

Stock Share Price Analysis tileIt uses current Google Finance data for current share prices and actual earnings per share. From this data actual fair value share prices and current price discounts are calculated. This provides a basis for direct comparison of share price value. Index trend analysis is also supported.

Estimated future stock share earnings and dividends from marketscreener.com are also applied to identify future fair value share prices and current price discounts. This provides a basis for direct comparison of the future share price value.

Trend analysis is applied to historical share price data to calculate trend range, high and low trend prices. Chart plots historical and current Price, Trend, High Trend and Low Trend lines. Trade trigger points are identified using High / Low trend prices, estimated future value, and the annual trend slope. Trade trigger points signal potential trades. From held portfolio data current capital profit and future estimated dividend returns are calculated.

Stock Share Price Analysis Example US

Stock Share Price Analysis calculates and provides...

... to identify potential buy sell trade points.

Stock Share Price Analysis Example US Chart

Access Stock Share Price Analysis and give it a try now...

Access Stock Share Price Analysis

Stock Share Price Analysis runs as an Add-on with Google Sheets (google's free online spreadsheet application) and can easily be accessed by Installing the Stock Share Price Analysis Add-on from the Google Sheets Add-ons Store.

google add on Install Stock Share Price Analysis from Google Sheets Add-ons Store
Provides automatic application updates to ensure optimum functionality and features. Once you access the Add-on Store listing click the blue  + Free  button at the top left to install.

The specific suitability of this application must be independently assessed. It is provided as is for informational purposes only and use is entirely at the users risk.

The Stock Share Price Analysis menu is located in the Google Sheets menu. Initially the only Stock Share Price Analysis menu item will be Start, select Start to authorize and enable the application.

Once enabled the Stock Share Price Analysis menu will be fully populated and you can select Example to see a demonstration portfolio and then Portfolio to build your own. For details see Help...

Stock Share Price Analysis is saved in a Stock Share Price Analysis folder in your Google Drive. Google Drive provides free secure cloud based storage, if you do not have a Google Drive account you can create one when you access Stock Share Price Analysis.

In Free mode some Stock Share Price Analysis functionality may be restricted. Please consider supporting application development and upgrading with a subscription...

Help Stock Share Price Analysis

Quick Start

Access Stock Share Price Analysis then from the Google Sheets Add-ons Stock Share Price Analysis menu select Start to initiate and authorize the application and then Example for a demonstration portfolio and Portfolio to build your own.

After installation the Stock Share Price Analysis menu will be available under Google Sheets Add-ons. Initially the only menu item will be Start, select Start to enable the application and access the authorization process. Once enabled the Stock Share Price Analysis menu will be fully populated.

Select Example to see a demonstration portfolio. You can select a US, UK or AU example. This will automatically build an example portfolio of stock shares and indexes.

Select Portfolio to build your own, only the content of blue cells should be changed. Then select Add row and input a Google Finance Stock or Index Code in the bottom blue cell in the Code column. When you input a code a Code row is built then select the Exchange for the code and for a stock code input a marketscreener.com url for the code and select Update Row to fetch code estimates data.

Code data calculations provide:

Code inputs are provided for Held shares.

Code data calculations apply input values for:

These inputs can be adjusted in the applicable blue cells. Changes are automatically saved in the sheet.

From the menu Chart generates a price chart with close price, price, high and low trend lines.

Stock Share Price Analysis is saved in a Stock Share Price Analysis folder in your Google Drive. Google Drive provides free secure cloud based storage, if you do not have a Google Drive account you can create one when you access Stock Share Price Analysis.

In Free mode some Stock Share Price Analysis functionality may be restricted. Please consider supporting application development and upgrading with a subscription...

Full Help Index

After installation the Stock Share Price Analysis menu will be available under Google Sheets Add-ons.

Start

Start initiates the application and opens the Welcome display. Initially the only menu item will be Start, select Start to enable the application. The Welcome display runs on open/refresh.

Portfolio

Select Portfolio to build a Portfolio sheet. See Portfolio Details for details.

Add row

Adds a portfolio stock code row.

Update row

Fetches estimate data for the currently selected portfolio stock code row from marketscreener.com

Update all

Fetches estimate data for each portfolio stock code from marketscreener.com

Chart

Opens the Chart display. A plot of each portfolio code historical and trend data is available from the drop down select.

Compress/Expand

Toggles the columns displayed.

Delete row

Deletes the currently selected portfolio stock code row.

Sort

Select asc or dec from Sort at the top of a column and then from the menu click Sort to sort the column.

Back up

Saves the portfolio settings, codes, exchanges, marketscreener.com urls, and held data.

Restore

Replaces portfolio settings, codes, exchanges, marketscreener.com urls, and held data with current Back up data.

Example

Builds a demonstration portfolio. You can select a US, UK or AU example. This will automatically build an example portfolio of stock shares and indexes.

License

Displays current license details.

Portfolio Details

Portfolio inputs/selection options are in blue cells.

Portfolio Header
Portfolio Code rows
Code

Input Google Finance Stock or Index Code.

Exchange

Select or Input Google Finance Stock Exchange.

Cur Price

Current Code Price from Google Finance.

Change%

Change % from previous close from Google Finance.

EPS Act

Actual Current Earnings per Share from Google Finance.

Value Act

Fair Value Share Price based on Actual Earnings per Share and Required Return% >> Value Act = EPS Act / Required Return %.

Cur Disc% Act

Current Price Discount to Value Actual. This is a comparative value indicator. It is the percentage Current Price change required to reach Value Actual >> Cur Disc% Act = (Value Act - Cur Price) / Cur Price.

marketscreener.com

Input marketscreener.com Stock Url. Search marketscreener.com and input the url for the stock and select Update Row from the menu to fetch code data.

DPS Est

Dividend per Share Estimated from marketscreener.com.

DPS% Est

Dividend per Share Percentage Estimated >> DPS% Est = DPS Est / Cur Price.

Payout Ratio

Estimated Dividend Payout Ratio percentage >> Payout Ratio = DPS Est / EPS Est.

EPS Est

Earnings per Share Estimated from marketscreener.com.

EPS% Est

Earnings per Share Percentage Estimated >> EPS% Est = EPS Est / Cur Price.

Value Est

Fair Value Share Price based on Estimated Earnings per Share and Required Return% >> Value Est = EPS Est / Required Return %.

Cur Disc% Est

Current Price Discount to Value Estimated. This is a comparative value indicator. It is the percentage Current Price change required to reach Value Estimated >> Cur Disc% Est = (Value Est - Cur Price) / Cur Price.

Trade Price

Input a desired Trade Price or leave as the default Current Price. This a potential Buy or Sell Trade point to monitor.

Cur% to Trade

Current Price % to Trade price, This is the percentage Current Price change required to reach Trade price >> Cur% to Trade = (Trade - Cur Price) / Cur Price.

Sparkline Chart

Historical Price Sparkline Chart for the Days History from Google Finance.

Trend Price

Current Trend Price for the Days History from Google Finance.

Trend Range

Trend Range High to Low for the Days History from Google Finance.

Range%

Trend Range percentage of Trend Price for the Days History from Google Finance >> Range% = Trend Range / Trend Price.

Trend Low

Current Trend Low.

Cur% to Low

Current Price percentage to Trend Low >> Cur% to Low = (Trend Low - Cur Price) / Cur Price.

Trend High

Current Trend High.

Cur% to High

Current Price percentage to Trend High >> Cur% to High = (Trend High - Cur Price) / Cur Price.

Trend pa%

Projected annual Trend percentage based on the Days History from Google Finance.

Trigger

Trigger Status for Trend Low and Trend High based on Trigger percentage. This is a trade timing indicator. It includes 'v'alue and projected 't'rend pa slope + or - indicator.

Held #

Input Number of Held Shares.

Pur Price

Input Purchase Price per share.

Div Est

Dividend Estimate next 12 months from Google Finance.

Div Est%

Estimated annual Dividend % on Cur Price >> Div Est% = Div Est / (Held# * Cur Price).

Cap Gain

Capital Gain to date >> Cap Gain = (Cur Price - Pur Price) * Held#.

Cap Gain%

Capital Gain percentage >> Cap Gain% = Cap Gain / (Held# * Pur Price).

Return

Estimated annual Total Return >> Return = Div Est + Cap Gain.

Return%

Estimated annual Total Return percentage >> Return% = Return / (Held# * Pur Price).

Price History

Price History from Google Finance.

Terms of Service

The specific suitability of this application must be independently assessed. It is provided as is for informational purposes only and use is entirely at the users risk.

Subscribe Stock Share Price Analysis

Subscription provides priority help, removes stock, exchange and portfolio limits, enables full editing, and supports continued application development.

Secure online transaction processing is provided via PayPal.

Stock Share Price Analysis
$55.00 USD Annual License Fee 
$ 5.50 USD Monthly License Fee

Please consider supporting application development...

Subscription details are processed and confirmation sent by email as soon as your transaction is processed. When your confirmation email is received simply select License from the application menu and submit your Subscription PayPal email address to verfiy your subscription. Your subscription provides licensed use of the application on multiple devices by the individual email address holder for the duration of the subscription.

The specific suitability of this application must be independently assessed. It is provided as is for informational purposes only and use is entirely at the users risk.

Design functionality is dependent on operational mode:

ModeFreeFree - review
initial 30 day review period
Plus
subscribe to enable
Portfolios1unlimitedunlimited
Codes per Portfolio10unlimitedunlimited
Exchangesselect options
ASX, LON, NASDAQ, NYSE, INDEXASX, INDEXCBOE, INDEXDJX, INDEXFTSE, INDEXNASDAQ
unlimited inputunlimited input
Days Historyselect options
7,14,30,60,90,180,360
unlimited inputunlimited input
Actionslimited to Portfolio sheetunlimitedunlimited
Editlimitedunlimitedunlimited

Summary Stock Share Price Analysis

Stock Share Price Analysis
Developer Web Site:
Price: $0.00 (USD)

Requirements for Use: Google Sheets

Stock Share Price Analysis is a Google Sheets Add-on with automatic stock share price fair value calculations, trend analysis and high/low triggers to identify value buy sell trade points. It uses current Google Finance data for current share prices and actual earnings per share. From this data actual fair value share prices and current price discounts are calculated. This provides a basis for direct comparison of share price value.

Stock Share Price Analysis Screen Shot, click for full size

x
buy
email
search
I am very impressed with the functionality of your Business Valuation Model, the lay out and the user friendliness. Your purchasing and registration procedure is also excellent.Robert de Rooy Thank you for this great software!Cedric Franklin This is the best model I have seen in a few decades.Darren Stevenson ...a resounding '1' for excellence. I am pleased with the performance of the software, the ease of use and the overall service. I am glad that I went ahead and ordered it. I plan to make heavy use of it during the rest of my MBA program and in my work life. No doubt I will be purchasing other programs from you. You have what I need.Judy Bottita I just down loaded the excel version...awesome....thanks so muchEdward M. Rouse great model for small biz and start up!Russell Smith I have my own accounting firm and I must admit that I am very impressed ... IT IS OUTSTANDING.Robert B. Wester, Jr Excellent software program. I have already referred several folks to your site to download the demo. Hopefully, they will turn into sales for you. Good Luck!Anthony Beebe Wow...you're good. Thanks for your help...and the rapid response was greatly appreciated. I think you have a great product; I've been doing 'if/then' scenarios on future options for my company, and it is quite fascinating using your program...You guys were great...exactly what I was looking for...I was very impressed with your customer service...great follow-up and execution. The software is easy to use, as was your web site. Thanks for your software; if I need any business software, I would be happy to look at you guys first. Keep up the good work.Kevin O'Keefe I was greatly impressed...Michelle Lamont Great Software...Art Vedner I am very impressed with the model.Jozua Fokker I think you have an excellent product and I look forward to trying some more of your software. I am very pleased!Rod Butler ...the system works great.Lyslei Chirico ...works perfectly.Hendry Buter You have excellent products that have saved me several hours of time. Ease of purchase is excellent. Keep up the good work and keep coming up with improved business models. You are absolutely on the right track.Denis Cowley Now that I have purchased the program, I honestly believe the price is ridiculously low for the power, utility and results generated by the program.Martin Caplan I just purchased your software - it's wonderful.Roger Varner I have been very happy with software purchase and was going to purchase another app... Thanks again for the great software!Frank Brown The Business Valuation software that runs in Excel saved my company a lot of time in evaluating an acquisition candidate. The instructions are clear and straightforward, and the program worked flawlessly.Tom Sweet Great piece of software. It has been a real winner in presentations here already. I have more to explore with it, too.Chad Haight ...I am in the midst (or shall we say was in the midst) of selling my company for a much lower amount...your software is working wonderfully...i think i shall send you a bottle of your favorite...Sean Hawley Love this application! It certainly can improve one's comfort level, especially the small business owner, when talking to the financial people. Seems to me like you can get a quick budget snapshot as well as the business valuation. Thanks again!Stan Shaw I am impressed with your business valuation model.Peter Davies This spreadsheet has really made my life easy and I have recommended it to my colleagues.Moses Mwanjirah We are very pleased with your Business Valuation Model.Steve Geringer ...very easy to use.Karl Hayes Just purchased your great spreadsheet.Terje Larsen I am very happy with the Excel valuation model supplied. I think it constitutes good value for money and has been of great help to me in my work.Graham Ireson Well done. It proved very useful for me already.Roland Mechler The program is quite easy to use.Jackquie Grant I still love the software.Jim Dickey Received and working great... Excellent service.Kevin Long ...very user friendly...Abel Acuna I recently purchased a copy of this package and have found it to be extremely helpful as a quick valuation tool...This is a great piece of software...Jim Wendler