Security Trading Analytics Blog Posts Through February 24, 2025
Click on a Title to Navigate to a Post
About the Security Trading Analytics Blog
Bitcoin-related Ticker Performance in 2023 Year and in December 2023
Can Leveraged ETFs Safely Grow Long-Term Investments?
How to Download and Display Historical Price and Volume Data
Bitcoin USD Exchange Rates Versus Major Market ETFs
Investing in Bitcoin-related Securities
Using Google Gemini to Learn Candlestick Charts and Moving Averages
An Introduction to Computing and Interpreting EMAs with Excel
Compound Annual Growth Rates for Leveraged Versus Unleveraged Exchange Traded Funds
Yahoo Finance No Longer Supports the Download of Historical Data via CSV Files
GOOLEFINANCE Function in Google Sheets Can Download Historical Data via CSV Files
Do Returns from the GOOGLEFINANCE Function in Google Sheets Match Returns from Yahoo Finance?
An Assessment of Selected Bitcoin-Related Securities from 2020 Through 2024
Assessing Returns for Stocks In Watchlists
What are Single-Stock ETFs and Should I Invest in Them?

Comments

Post a Comment

Popular posts from this blog

Image
A Preliminary Analysis of EMA Period Lengths and Price Action in a Buy-Sell Model This blog introduced on March 26, 2026, an earlier version of the Buy on Proper Order and Sell on Dynamic Stop Loss Orders Buy-Sell model.  Proper order was defined in that post by a relationship between a close price and two EMA values, such as close > ema_21 and ema_21 > ema_100.  In this post, the model dynamically updates upper and lower boundary values based on price action to lock in a portion of accumulated gains or at least constrain the size of a loss associated with a trade.  This post extends the March 26 post by updating the code for implementing the model, diving more deeply into how price action can change model performance, and testing the model over a broader range of tickers examined as well as over longer timeframes. The model examined in this post uses proper order relationships for close prices and exponential moving averages with different period lengths to discove...
Read more
About the Security Trading Analytics Blog This blog aims to empower site visitors who seek examples and demonstrations of quantitative methods for tracking and projecting security prices.  Another goal of the blog is to present methods and resources that are practical and useful for individuals who want to become better traders and investors with the help of quant methods. Quantitative methods may include, but are not limited to: ·               Analysis of historical security prices ·               Technical analysis of trends and indicators ·               Models for when to buy and sell securities implemented with: o   SQL Server o   Google Sheets with the GOOGLEFINANCE Function o   Excel with the STOCKHISTORY Function ...
Read more
Image
  ETF Price Puzzles: Examples Showing Tiingo’s Raw and Adjusted Series Don’t Always Differ As I was preparing an analysis of a buy‑sell model for several major ETFs, I stumbled across some unexpected puzzles in the price data.   Tiingo provides both raw and adjusted price series, but for certain ETFs the two are identical — even across known split dates. This post explains how I discovered these puzzles in selected ETF ticker prices from Tiingo.   The post also describes why the puzzles matter, and how you can adjust for them when performing ETF analyses with Tiingo data. Where I Discovered Tiingo ETF Price Puzzles I was analyzing a model based on EMA proper orders for prices when I first noticed ETF price puzzles.   Any ETF price series can have multiple EMAs depending on their period lengths.   No matter what the period length for an EMA, it is always dependent on its underlying price data.   For any trading date, EMAs with shorter period lengths...
Read more