Stock Share Price Analysis Access Help Subscribe

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 4-traders.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 (googles 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 (recommended) or making a Copy of Stock Share Price Analysis.

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. This is the recommended access method.

or

google drive Copy Stock Share Price Analysis
Requires manual updating, will not reflect current functionality and features.

Access is not pre-verified by google and will display a This app isn't verified warning. To proceed with authorization select Advanced and Go to Stock Share Price Analysis.

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. If initiation / authorization is required the only Stock Share Price Analysis menu item will be Start, select Start to initiate the application and commence the authorization process allowing access to external data sources and google sheets to enable the application.

Once initiated from the Google Sheets Stock Share Price Analysis menu click 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. In the built Portfolio input a stock code in the last blue cell in the Code column.

After installation the Stock Share Price Analysis menu will be available under Google Sheets Add-ons. If initiation is required the only menu item will be Start, select Start to initiate the application and access the authorization process. Once initiated 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. On the Portfolio sheet 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 4-traders.com url for the code 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. If authorization is required the only menu item will be Start, select Start to access the authorization process. The Welcome display runs on open/refresh.

Portfolio

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

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.

Update all

Fetches estimate data for each portfolio stock code from 4-traders.com

Update row

Fetches estimate data for the currently selected portfolio stock code row from 4-traders.com

Delete row

Deletes the currently selected portfolio stock code row.

Back up

Saves the portfolio settings, codes, exchanges, 4-traders urls, and held data.

Restore

Replaces portfolio settings, codes, exchanges, 4-traders 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.

Top of Page

Exchange

Select or Input Google Finance Stock Exchange.

Top of Page

Cur Price

Current Code Price from Google Finance.

Top of Page

Change%

Change % from previous close from Google Finance.

Top of Page

EPS Act

Actual Current Earnings per Share from Google Finance.

Top of Page

Value Act

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

Top of Page

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.

Top of Page

4-traders.com

Input 4-traders.com Stock Url. Search http://www.4-traders.com/ and input the url for the stock.

Top of Page

DPS Est

Dividend per Share Estimated from 4-Traders.com.

Top of Page

DPS% Est

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

Top of Page

Payout Ratio

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

Top of Page

EPS Est

Earnings per Share Estimated from 4-Traders.com.

Top of Page

EPS% Est

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

Top of Page

Value Est

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

Top of Page

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.

Top of Page

Trade Price

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

Top of Page

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.

Top of Page

Sparkline Chart

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

Top of Page

Trend Price

Current Trend Price for the Days History from Google Finance.

Top of Page

Trend Range

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

Top of Page

Range%

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

Top of Page

Trend Low

Current Trend Low.

Top of Page

Cur% to Low

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

Top of Page

Trend High

Current Trend High.

Top of Page

Cur% to High

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

Top of Page

Trend pa%

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

Top of Page

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.

Top of Page

Held #

Input Number of Held Shares.

Top of Page

Pur Price

Input Purchase Price per share.

Top of Page

Div Est

Dividend Estimate next 12 months from Google Finance.

Top of Page

Div Est%

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

Top of Page

Cap Gain

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

Top of Page

Cap Gain%

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

Top of Page

Return

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

Top of Page

Return%

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

Top of Page

Price History

Price History from Google Finance.

Top of Page

Conditions of Use

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: $55.00 (USD)
Download Stock Share Price Analysis
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

bizpep
<
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 a brilliant and easy to use tax system, you have literally saved me hours and hours of work with simple clicks and drag from my accounting software to BAS-I.C my bas is done.Lisa Groundwater 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 the software has really simplified my tax and therefore my life! Thanks so much!Gail Tagarro Thanks very much for putting the BAS-I-C software 'out there' - so far it seems terrific and perfect for what I need.Chris Hargreaves 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 Thanks your program it was great for me starting out in my small business, definitely recommend it for startups.Jayne Bachelor I was greatly impressed...Michelle Lamont Great Software...Art Vedner I'm just starting to use this system for BAS reporting and am enjoying the simplicity and ease of use....I give you guys 5 stars.Jodie Maurer 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 to begin my third year with your excellent system ... How lucky I am to have bought your software. Thank youZoe Harrison 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 Just started playing with your software and I like it!Roger Loweth 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 I have loved your BAS Business Accounts Software and think it's ideal for sole traders (which was the reason I purchased it).Nicole Cornish 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 Am really enjoying working with this programme, I am sure within the next week I will be putting an order in. I have found it so easy to use, wish I had known about it years ago, life would have been much easier.Lyn Laycock 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 think it is a very useful spreadsheet and I'm using it and I haven't found anything better and have stopped looking.Antoine Matarasso 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