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...
Posts
What are Single-Stock ETFs and Should I Invest in Them? Single-stock ETFs are different than traditional ETFs. Traditional ETFs offer a single security that tracks a collection of stocks, but the collection of stocks can be bought and sold like a single security. The collection of stocks underlying a traditional ETF supports diversification and thereby mitigates the risks associated with any one stock in the collection. Single-stock ETFs are based on just one stock, and they do not provide the benefit of diversification available from traditional ETFs. ETFs can be geared or not geared. A geared ETF aims to return a price change that is 1.5, 2, 3 or some other multiple value on the ETF’s price change during a day. Therefore, if an ETF’s price change is +2 percent and the gear ratio is 2, the geared ETF’s price rises by 4 percent on that trading day. In contrast, if an ETF’s price change is -2 percent on a trading day and the gear rat...
An Assessment of Selected Bitcoin-Related Securities from 2020 Through 2024 One of the most successful trading themes in 2024 was trading bitcoin-related securities. This post assesses success for selected bitcoin-related tickers relative to one widely traded non-bitcoin security as well as an index of bitcoin value. An earlier post examines outstanding performances by other securities during 2024. The bitcoin-related financial tickers tracked in this post include MSTR, GBTC, and MARA. These tickers are assess relative to two benchmark tickers -- namely, SPY and BTCUSD. MSTR is the ticker for a firm that began as a business intelligence and analytics firm. Starting in 2020, the firm began transforming itself into a bitcoin treasury so that it now has one of the world’s largest bitcoin holdings (around 440 thousand and growing at a relatively rapid pace). GBTC originated as a bitcoin trust, but it converted to a bitcoin ETF in January 2024. GBTC ...
Assessing Returns for Stocks In Watchlists A watchlist is a collection of stocks that can help you identify stock market trends by revealing securities driving those trends. In addition, you can also think of a collection of watchlists as sets of stocks designed to reflect changing growth rates in complementary market areas. It is not unusual for traders to take advantage of multiple contrasting watchlists. A watchlist does not necessarily contain your current portfolio of holdings. Instead, you can use a set of watchlists to identify stocks that are currently good candidates for either adding or removing positions from your current holdings. Trading decisions about when to buy, hold, or sell securities can be based on watchlists as well as technical and fundamental indicators along with trading narratives. Watchlists can be especially important for swing traders who hold positions over several weeks or months, and then exit positions within days w...