quicksheet-stocks

A QuickSheet extension that shows live stock and crypto quotes directly in your spreadsheet cells — powered by Yahoo Finance, no API key needed.

Demo

📈 Apple Inc.          (AAPL)
USD 308.82             ▲ +3.83  +1.26%
Day:  305.85 – 311.40
52W:  195.07 – 311.40
Vol:  43.61M
via Yahoo Finance · 11:03 UTC

Multi-ticker comparison table:

Ticker   Price          Change      %Change
AAPL     USD 308.82     ▲ +3.83     +1.26%
MSFT     USD 418.57     ▼ -0.52     -0.12%
BTC-USD  USD 74650.01   ▼ -799.62   -1.06%
Yahoo Finance · 11:03 UTC

Usage

In any QuickSheet cell, type:

Cell value	Output
stocks: AAPL	Detail view: price, change, day range, 52W range, volume
stocks: AAPL, MSFT, GOOGL	Comparison table with all tickers
stocks: BTC-USD, ETH-USD	Crypto quotes
stocks: AAPL, BTC-USD	Mix stocks and crypto

Any Yahoo Finance-supported symbol works: stocks, ETFs, indices (^GSPC), crypto (BTC-USD), forex (EURUSD=X).

Quotes refresh every 60 seconds (cached to avoid rate limiting).

Install

Requirements

• .NET 9 SDK or Runtime
• QuickSheet installed

Build from source

git clone https://github.com/Deskworks/quicksheet-stocks
cd quicksheet-stocks
dotnet build -c Release

Register with QuickSheet

Add to your QuickSheet Extensions/ folder or register via the extension manifest:

# Copy the manifest to QuickSheet's Extensions directory
cp quicksheet-extension.json /path/to/QuickSheet/Extensions/quicksheet-stocks.json

The quicksheet-extension.json tells QuickSheet how to launch this extension:

{
  "name": "quicksheet-stocks",
  "prefix": "stocks",
  "version": "1.0.0",
  "description": "Live stock & crypto ticker via Yahoo Finance. Usage: stocks: AAPL or stocks: AAPL, MSFT, BTC-USD",
  "author": "Deskworks",
  "entry": "quicksheet-stocks",
  "language": "dotnet"
}

How it works

QuickSheet extensions communicate via JSON-lines on stdin/stdout. When a cell contains stocks: AAPL, QuickSheet sends an activate message; this extension fetches a live quote from Yahoo Finance and responds with write messages to fill the surrounding cells.

See the QuickSheet Extension Protocol for full details.

Zero dependencies

• No API key — uses Yahoo Finance's public chart endpoint
• No NuGet packages — only BCL HttpClient and System.Text.Json
• No external services — all data comes directly from Yahoo Finance

Supported symbols

Yahoo Finance symbol examples:

Type	Example symbols
US Stocks	AAPL, MSFT, GOOGL, TSLA, NVDA
ETFs	SPY, QQQ, VTI
Indices	^GSPC (S&P 500), ^DJI, ^IXIC
Crypto	BTC-USD, ETH-USD, SOL-USD
Forex	EURUSD=X, GBPUSD=X

---

Part of the QuickSheet extension ecosystem.