Excel Trading and Investing Models | ExcelTradingModels.com
  • FREE STUFF
    • Free Trading Model
    • Free Getting Started Guide
    • 5 Free Technical Indicators in Excel
    • Free Spread Trading Contract Calculator in Excel
    • Free Yahoo Finance Stock Split Adjuster
  • Trading Models
    • Free Trading Model
    • Four Trading Models in Excel
    • Trend Trading Model in Excel
    • Breakout Trading Model in Excel
  • Courses
    • Build an Automated Trading System in Excel
    • Build a Sector Fund Investing System in Excel
  • Analysis & Data
    • Excel Technical Indicators Library
    • AnalyzerXL Pro
    • DownloaderXL Pro
    • BacktestingXL Pro
  • Articles
    • Excel Models
    • Data
    • Backtesting
    • Portfolio Analysis
    • VBA Code
    • FAQs
      • Stock Model FAQs
      • Fund Model FAQs
  • Shop
Select Page

FAQ: The VBA code Sheets(ticker).Select is highlighted. What do I do?

Data, FAQs, Stock Model FAQs, VBA Code

The code isn’t broken. The error you’re getting can mean one of 4 things: 1/ you did not save the .csv files you downloaded with TICKER.csv in ALLCAPS (replace TICKER with your desired symbols) 2/ your list of ticker symbols in the Controls worksheet are not in...

How to Calculate Spread Trading Contract Legs: Case 3 Contracts Denominated in Different Currencies

Articles, Data, Spread Model FAQs, Spread Trading Model

< Back to Case 2 How to Equalize Spread Legs When the Securities are Denominated in Different Currencies This is the base case where both securities are denominated in different currencies and a currency transformation is required in addition to a Contract...

How to Calculate Spread Trading Contract Legs: Case 2 Contracts with Different Quote Units

Articles, Data, Spread Model FAQs, Spread Trading Model

< Back to Case 1 How to Equalize Spread Legs When the Securities Have Different Quote Units This is the base case where both securities are in the same currency and no currency transformation is required, but the two Quote Units are different.  You cannot equalize...

How to Calculate Spread Trading Contract Legs

Articles, Data, Spread Model FAQs, Spread Trading Model

When spread trading futures, stocks, ETFs or other securities, it is important to equalize the dollar value of each side of the spread. The short position in Security #1 should be offset as closely as possible by a long position in Security #2.  This series of case...

How to Calculate Spread Trading Contract Legs: Case 1 Simple Spread Equalization

Articles, Data, Spread Model FAQs, Spread Trading Model

< Back to Intro How to Equalize Spread Legs When Both Securities Are in the Same Currency and Have the Same Quote Units This is the base case where both securities are in the same currency, no currency transformation is required and the Quote Units of the two...

CRASH! Excel Chart of the U.S. Dollar (USD) vs Swiss Franc (CHF) January 2015

Articles, Data

Here’s a good Excel chart of the USD vs. CHF exchange rate crash after the Swiss National Bank decided to lift the cap on the CHF vs. EUR.  Free currency data downloaded...
« Older Entries

.

Free Trading Model 10 Steps to Create a Profitable Trading System in Excel - Free Getting Started Guide 5 Free Technical Indicators in Excel FREE Yahoo Finance Stock Split Adjuster in Excel FREE Spread Trading Contract Calculator in Excel
  • Home
  • Refund Policy
  • CFTC Rule 4.41
  • Facebook
  • Twitter
Copyright © 2021 ExcelTradingModels.com and FunnelProfit, LLC