One for All - the complete finance package
  • One for All - the complete finance package
  • One for All - the complete finance package
  • One for All - the complete finance package
  • One for All - the complete finance package
  • One for All - the complete finance package
  • One for All - the complete finance package
  • One for All - the complete finance package
  • One for All - the complete finance package
Originally published: 21/04/2020 08:40
Last version published: 26/11/2020 17:29
Publication number: ELQ-98813-7
View all versions & Certificate
certified

One for All - the complete finance package

5 Sheets and 2 Programs

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

Acquire business license for $75.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • joewest(last updated: 18/05/2020 04:16)

keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Markus Polzer

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on One For All - The Complete Finance Package?

The user community and author are here to help. Go ahead!


5.0 / 5 (1 votes)

please wait...