Portfolio Analysis in SQL: Weights to Drawdown
Portfolio analysis with free SQL: five short queries for position weights, concentration, correlation, dividend income, and the worst drawdown of the blend.
#sql
Filtering by topic #sql · clear
Stock Correlation Matrix in One SQL Query
A stock correlation matrix in one SQL query over daily returns, plus the curl and jq version and the measurement mistakes that quietly inflate the numbers.
Stock Split Calendar From a Free SQL API
Build a stock split calendar with one curl call and one SQL query: upcoming forward and reverse splits, ratios, effective dates, and splits per month.
Ex-Dividend Calendar from a Free SQL API
Build a forward ex-dividend calendar with one curl call to a free SQL API, plus the jq one liner that shapes the next 14 days into a readable table.
Free SQL API for Stock Market Data
A free SQL API for stock market data: write real SQL against 22 years of US equities, dividends, and fundamentals. 100 queries a day, no credit card.