One for All - the complete finance package

5 Sheets and 2 Programs

by Markus Polzer
IT-Consultant in FinanceFollow 20

2 reviews894 views|Start the discussion!|Bookmark Add to cart - $80.00

Description
(1) Stock valuation
It enables you to carry out a stock valuation according to various criteria (price, fundamental, dividends) within a few minutes and to determine the fair price using different methods (P / E, DCF, Estimation, Ten Cap, Payback Time).

The shares are valued according to 3 criteria:
1) Price
2) Fundamental
3) Dividends

Stock valuation key figures including fair value in less than 10 minutes:
https://www.youtube.com/watch?v=4JYur2CUy2k

Stock valuation metrics - update quarterly numbers in less than 3 minutes
https://www.youtube.com/watch?v=yW1LjLSCWfo


(2) Levermann Score
With the Excel tool "Share valuation according to Levermann" you are able to carry out a share valuation within a few minutes using the so-called Levermann method.
https://www.youtube.com/watch?v=tGHsQVce1RI


(3) Levermann Score Program
It enables you to do a automatic stock valuation using the so-called Levermann method within less than 2 minutes.
https://youtu.be/dLlrqcuXDeE


(4) Piotroski Score
With the Excel tool "Piotroski share valuation" you are able to determine the Piotroski F-Score for any share within a few minutes.
https://www.youtube.com/watch?v=TWhFzyGY0lk&t=56s


(5) Fair Value Program
It enables you to do a automatic Fair-Value calculation according the DCF- and PE-Method within less than 2 minutes for over 5000 stock titles
https://youtu.be/V9-catPdHzo


(6) Stock Valuation - US Stock Market
Here you can find everything you need to know about the US Stock Market.

More than 500 indiviudal stocks with 100 ratios and historical prices for up to 30 years back.
Perfect for backtesting and analyzing your individual strategy.
Values ​​are from the company reports in USD - the stock prices are based on the informations from different stock exchanges (NYSE, Nasdaq)

It consists of 2 Excel Sheets -
1) Stock Data
2) Stock Prices
In every Excel-Sheet you have an Index-Overview, where you can jump directly to the indiviudal stock you are interested in - and also have a "Back to INDEX" field in every Stock Worksheet.

See the following video for a explenation for the handling:
https://youtu.be/oyscNEdV6vY


(7) Currency Backtesting in Excel
This Excel Sheets enables you to do a fully backtesting for all currency-deviations after different economic-events for the past 20 events. For every event you can see the currency-changes after different time periods (1 minute, over 1 hour to 24 hours).

You can filter the events by all possible information:
- Date / Time
- Country
- Relevance of the event (1 to 3)
- Expectations Before / Expectation Forecast / Actual Result
- Differences (between Actual / Forecast and Actual / Before)
- Deviations after every timeperiod between 1 minute and 24 hours

See the following video for a brief overview of the functionality:
https://youtu.be/4Gz2Rf1_uTY

(8) IPO Tracker
This program enables you to tracke ipo-stocks or any other stock title for up to 30 days.

See the following video for a brief overview of the functionality:
https://youtu.be/kK9xs7436TY

This Best Practice includes
5 Excel Sheets, 2 Programs, 68 Excel Sheets for currency backtesting