A Trader Life
  • Introduction
  • Strategies
    • TOTUS
    • DOMINUS
    • One tool to rule them all
    • Scalper Crypto
      • Pair list 06/02/21
    • Swinger Crypto
    • CALCULUS
    • ETH V
    • BTC Correlation
    • IPSIMUS
    • VWAP Stock
    • MTF Stock
  • Courses
    • Anton Kreil – Professional Trading Masterclass
    • Introduction to Stocks
      • List of brokers for stock
      • Selling options for profits
      • Introduction to Stocks and Technical Analysis
    • Psychology
      • Some psychology
      • Inside a traders mind
      • 20 Trading rules
      • Do you want to be a professional trader?
      • Psychological Mindset
      • The defining decade and why your twenties matter and how to make the most of them now by Meg Jay sum
      • How to win friends and influence people by Dale Carnegie summary
      • Curious by Ian Leslie summary
      • A Mind For Numbers | Barbara Oakley summary
    • Excel Tips
      • Risk of ruining your account
      • How to make use of the peg ratio
      • How to combine a spread trade with PMI
      • How to calculate ATR
      • How to calculate implied volatility with excel
      • How to make use of distribution in financial markets using excel
Powered by GitBook
On this page

Was this helpful?

  1. Courses
  2. Excel Tips

How to make use of distribution in financial markets using excel

PreviousHow to calculate implied volatility with excel

Last updated 3 years ago

Was this helpful?

In this example I am going to make a resume for the last 20 years approx in S&P 500

Here we have the average return with the different percentages, some descriptive details, the distribution of the data, the standard deviation, the average profits and so on.

For this first I used the data from financial yahoo.

Also if you are interested in the file I added it as well to use it as an example.

For more details and questions feel free to message me.

1007KB
spy-my-example.xls
Download - SPY500 Example