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 combine a spread trade with PMI

PreviousHow to make use of the peg ratioNextHow to calculate ATR

Last updated 3 years ago

Was this helpful?

In this post I am going to show an example on how you can combine data from same industry/ different industries and compare it with ISM report to see if we can find some entries. We can apply this to any equities, indices, commodities and so on.

In this case I am going to use JP Morgan and Goldman

First we acquire the data ( from yahoo finances for ex) by month

We get only the Adj Close data.

Then we divide the bigger one to the lower one and we apply the formula to all our rows.

We can apply some trends line, moving averages or other TA indicators.

Then we take the PMI data from the ISM, and we put it together with our spread trade

I uploaded the excel file as well in case you want to use it as an example

518KB
spread-trade.xlsx
Download - Spread trade example