# Historical Options Chains

![Image](https://upload.cafenono.com/image/slashpagePost/20241105/215221_LHi18mFGUdVCSqza5O?q=80&s=1280x180&t=outside&f=webp)

## About

These scripts was developed to scrap, download and save the daily **OPTIONS CHAINS** in SQLite in order to accumulate a historical database for backtests purposes. 

The scripts are running in a personal public repository and the new daily rows are being constantly added in the files below. 

Navicat or DBeaver are good softwares to browser data into ".db" file. 

## Links

1. **Yahoo Finance:** [https://github.com/jhvissotto/Scrap-YF-Opt-Chain/raw/refs/heads/main/Filebase.db](https://github.com/jhvissotto/Scrap-YF-Opt-Chain/raw/refs/heads/main/Filebase.db) 

2. **Market Watch: **[https://github.com/jhvissotto/Scrap-MW-Opt-Chain/raw/refs/heads/main/Filebase.db](https://github.com/jhvissotto/Scrap-MW-Opt-Chain/raw/refs/heads/main/Filebase.db) 

3. **ADVFn:**[ ](https://github.com/jhvissotto/Scrap-AF-Opt-Chain/blob/main/Filebase.db)[https://github.com/jhvissotto/Scrap-AF-Opt-Chain/raw/refs/heads/main/Filebase.db](https://github.com/jhvissotto/Scrap-AF-Opt-Chain/raw/refs/heads/main/Filebase.db)[ ](https://github.com/jhvissotto/Scrap-AF-Opt-Chain/blob/main/Filebase.db)

## SQL Browsers

1. **Navicat:** [https://www.softpedia.com/get/Internet/Servers/Database-Utils/Navicat-Premium.shtml](https://www.softpedia.com/get/Internet/Servers/Database-Utils/Navicat-Premium.shtml) 

2. **DBeaver:** [https://www.softpedia.com/get/Internet/Servers/Database-Utils/DBeaver.shtml](https://www.softpedia.com/get/Internet/Servers/Database-Utils/DBeaver.shtml) 

## Navicat Preview

![Image](https://upload.cafenono.com/image/slashpagePost/20241109/202658_98Nje64mLcJsBa7B2I?q=80&s=1280x180&t=outside&f=webp)

## Technical Variables

🆔 **Tickers:** 

- **ETF:** SPY, DIA, QQQ, XLF, XLC, XLE, XLU, XLP, XLK, XLV, XLI, XLY, XLB, XOP, XBI, XRT, XHB, XME, XLRE, IWM, IYR, NOBL, AMLP, OIH, KRE, VNQ, ITB, KBE, IBB, SMH

- **SPX:** Top 50 

🔁 **Procedures: **Downloaded via Python and automated via Github Actions

🗓️ **Frequency:** 1 time per day, at midnight

⛔ **Skip:** Weekend and US Holidays

📂 **File: **SQLite

🚩 **Started:** 2024-11-06

💿 **Providers:** Yahoo Finance, Market Watch, ADVFn

For the site tree, see the [root Markdown](https://slashpage.com/jh-analytics.md).