Features
Find opportunities
Real-time quotes in Excel
Options pricing
Option Profit Calculator
Historical data
Screener
Stock Ranks
Analyze and optimise portfolios
Economic Indicators
Perform technical analysis
Quotes in Google Sheets
Cryptodata in Excel
1000+ Functions
Portfolio Report Builder
Templates
Guru screens
Track & manage
Real-time quotes in Excel
Analyze and optimise portfolios
Historical data
Perform technical analysis
Quotes in Google Sheets
Cryptodata in Excel
Option Profit Calculator
Options pricing
Collaborate
Spreadsheet Builder
Share watchlists
Share Screens
Share Templates
Learn
Blog
Videos
Templates
Public screens
Functions
Templates
Pricing
Help
Questions? Call us Toll-Free
Knowledge Library
Functions
Templates
Frequently Asked Questions
Video Tutorials
Discord
Blog
Contact Us
Blog
1-877-778-8358
Login
Book Demo
← Back to Templates
Quantitative Analysis of Stocks
Created by MarketXLS
Last updated: 7/27/2022
Description
Template Screenshots
Get Access to
1 Billion
Usable Market data points
IN YOUR EXCEL SHEETS
WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work? Watch Demo
Download Template
Similar Templates
Unusual Options Activity Scanner
Template for Accessing Real-Time Data on US Stock Option Bids, Greeks, Open Interest, and Unusual Op
Options Rollover Strategy Example Template
E-Mini S&P 500 Options Template
SPXW Options
Related Formulas
ƒ(x)
Unusual Stock Options Activity
Returns the options that exhibit the highest volume to open ...
ƒ(x)
Unusual Option OI Scan EOD
Returns the underlyings with the most significant change in ...
ƒ(x)
Unusual Option Vol/OI Scan EOD
Returns the underlyings that have the highest volume to open...
ƒ(x)
Unusual Option Volume Scan EOD
Returns a list of underlyings exhibiting unusually high trad...
ƒ(x)
Extraordinary Income-Losses (Historical)
Returns the extraordinary income or losses from historical f...
ƒ(x)
Options Volume Leaders
Returns a list of options that have the highest traded volum...
ƒ(x)
Queries MarketXLS Database
ƒ(x)
Diluted EPS From Extraordinary Income (Historical)
Returns the company's diluted earnings per share figure that...
ƒ(x)
Extraordinary Income Losses (Historical)
Returns the historical extraordinary income losses, which de...
ƒ(x)
Put Call Ratio
Returns the ratio of put activity to call activity in the op...
