This product is no longer functional. It was dependant upon the YAHOO Finance API which is no longer supported. We are in the process of integrated a different API. It will be available again soon.



The Free Stock Quote Manager is an excel spreadsheet to help you manage your portfolio investments. Stock data is accessed using the Yahoo Finance excel api. All quotes are on a 20 minute delay. Here is a a snapshot fo the main worksheet. It is your stock quote manager control panel.

Free Stock Quote Manager

Microsoft Office 10 is required. Click this direct link to download the Free Stock Quote Manager Excel Spreadsheet

Upgrade to the Predictor Stock Quote Manager (PSQM)


  • Predictor sheet which offers detailed analysis of your selected stocks.
  • Predictor recommendations to enter postions for stocks baseed on PEG analysis.
  • Predictor recommendations to enter postions for stocks baseed on Moving Averages analysis.
  • Predictor recommendations to enter postions for stocks baseed on 52 Week Low analysis.
  • Selector to pick stocks based on value indicators and discount indicators pre-loaded with over 3000 stocks.
  • All data is pulled from yahoo finance and the stocks that are analyzed are automatically added to this sheet based on your portfolio stock list.
  • Online user guide can be found here.


  • Disclaimer: PSQM recommendations are based on simple technical analysis. It is a starting point to identify stocks that may be desireable for entry positions using well know formulas freely available on the internet. Due deligence should be applied by further chart analysis and market/industry analysis before making your final decision.

    • PEG Analysis

    This analysis determines if a stock is currently cheap or pricy. It applies the PEG (PE to Growth) formula which simply takes the current P/E ration to divided by growth rate (default is 15%). Any stock with a PEG greater than 2 is considered pricy. The desired growth rate is configurable in Settings.

    Predictor Stock Quote Manager - PEG Analysis

    Moving Average Analysis

    This analysis predicts entry and exit positions based on up/down trends identified using 50 Day and 200 Day moving averages. A stock is trending UP when its 50 Day is greater than its 200 Day and the current stock price is greater then the 50 Day. The desired range of current price greater than 50 Day, which determines if the stock is ready for entry, is configurable in the Settings sheet. The default is 3% higher that the 50 Day.

    Predictor Stock Quote Manager - Moving Average Analysis

    52 Week Low Analysis

    This analysis predicts entry and exit positions based the current price being close to yearly low. Which in theory may indicate it has a good chance to climb to its high again at some point. There are two levels to watch for. A BUY range which is a low range for the current price to the 1 year low price and a HOLD range which indicates a stock is currently selling closer to low than high and may be worth watching. Both of these ranges are configurable in the Settings sheet.

    Predictor Stock Quote Manager - 52 Week Analysis

    Selector

    This sheet is a stock picker. Preloaded with over 3000 stocks. Filters are used to narrow down your search based on industry and indicator selections.

    Predictor Stock Quote Manager - Selector

    How Do You Get PSQM?


    There are two ways to get the Predictor Stock Quote Manager spreadsheet:
    1. FREE with any PGDA PRO subscription. After upgrading to a paid subscription, simply logging into your account will enable you to download the PQSM spreadsheet.
    2. One-time $25 fee and the spreadsheet will be delivered to you as soon as payment is confirmed. If this is your preference, simply use the Contact Us form to let us know so we can begin the process.