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

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    Python o    SQL Server o    Excel o    Google Sheets with the GOOGLEFINANCE Function About the Blog’s Author Hi, I ...
Read more
Image
 GOOLEFINANCE Function in Google Sheets Can Download Historical Data via CSV Files A recent prior post at this blog describes the disabling of a Yahoo Finance feature for downloading historical price and volume data into csv files.  The Yahoo Finance web page from which you were formerly able to download historical prices without a fee has been updated by the following statement: " Downloading historical data is only available to Gold members. " The disabled feature degrades Yahoo Finance as a supplier of free data for security trading analytic projects.  As a result, this blog promised to investigate and demonstrate workarounds for the disabled free feature. The Gold member subscription plan  is currently priced at $49.95 per month or $479.40 per year when paid annually.  While the Gold member plan includes additional benefits besides the download of csv files with historical data, these additional features do not support security trading analytics projects o...
Read more
Image
Can Leveraged ETFs Safely Grow Long-Term Investments?   This post compares the performance of five pairs of ETFs.   Within each pair is an unleveraged ETF and a leveraged ETF based on five different market indexes.   Read on to learn if leveraged ETFs consistently outperformed unleveraged ETFs in the long run. The ETFs are compared over three different timeframes: since the ETF initially started trading (its launch date), over the last five years of trading, and over the next to last five years of trading.   By long-term investment, this post means buying-and-holding an ETF for a   period of several years or decades – not just a couple of weeks, days, or   minutes within a day.   The first of the three timeframes begins with the launch date for an ETF.   Because different ETFs can have different launch dates, the first timeframe can start on different trading dates for different ETFs. ETFs are compared in this post via their overall percen...
Read more