Security Trading Analytics Blog Posts Through October 30, 2024

Click on a Title to Navigate to a Post

 

Title

About the Security Trading Analytics Blog

How to Compare Close Prices for Three Securities Over Four Years

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?

 

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 am Rick Dobson, an analyst and a computer programmer who earned his Ph.D. at Arizona State University in psychology along with 12 hours of graduate-level computer science courses for one of my foreign language requirements.  I started my c
Read more
Image
How to Compare Close Prices for Three Securities Over Four Years This blog describes the relatively simple analytical task of comparing close prices for three securities from a start trading date through an end trading date in each of four years – namely, 2020, 2021, 2022, and 2023.  The close price data for successive trading days are derived from Yahoo Finance .  This post illustrates two main ways to compare close prices for different securities -- by performance charts within a year for each of the four years and by the compound annual growth rate (cagr) across the four years.  The three securities examined in this tip include Marathon Digital Holdings Inc. (MARA), the bitcoin-US dollar exchange rate (BTC-USD), and the SPDR S&P 500 ETF Trust (SPY). ·         The Marathon Digital Holdings site claims it is the largest bitcoin miner in North America as of November 30, 2023.  Bitcoin miners participate in verifying and maintaining the Bitcoin network.  Although the prices of b
Read more
Image
  Bitcoin-related Ticker Performance in 2023 Year and in December 2023 It has been a very strong performance year and month for bitcoin-related securities.   Treemap charts can be a very powerful data visualization tool.   This post is to show how treemap charts are well suited to conveying these kinds of results. Here is a one-month chart for December, 2023.   Despite some close price retreats towards the end of the month, bitcoin miner prices advanced well in December, 2023. BITF, the ticker for a Canadian-based miner which focuses on the use of hydro electricity sources, returned the largest monthly gain. MARA, a large, publicly traded company which focuses on US mining operations, returned the second largest monthly gain. Here is a year-to-date performance chart for the whole of 2023.   In the following chart, MARA with a gain of 578% edged slightly ahead of BITF with a gain of 555%. Other bitcoin miners returning over 300% for the year include RIOT and CLSK.   MSTR is
Read more