Posts

About Security Trading Analytics Blog

  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 Fun
Image
  Do Returns from the GOOGLEFINANCE Function In Google Sheets Match Returns from Yahoo Finance? 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 for free.  A  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 $479.40 per year when paid annually.  Furthermore, a previously available payment plan for the service on a monthly basis is discontinued as of the time this post is prepared.   In evaluating a response to the price escalation from free to
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 of historical s
Yahoo Finance No longer Supports the Download of Historical Data via CSV Files A prior post from this blog demonstrated how to download historical stock price data via a csv file.  In the past couple of weeks, Yahoo Finance deleted this feature.  Another internet source confirms the dropping of the feature. Here is an example of the error message that I am encountering when I attempt to download historical data from Yahoo Finance to a csv file on my computer: {"finance":{"result":null,"error":{"code":"unauthorized","description":"User is not logged in"}}}. I am currently evaluating workarounds for the issue, and I expect to publish my initial discovered workarounds by late September 2024.. I expect the deleted feature to be problematic to self-directed traders/investors, financial quantitative analysts,  as well as authors, such as the blogmaster for the Security Trading Analytics blog .  Please feel to share with
Image
  Compound Annual Growth Rates for Leveraged Versus Unleveraged Exchange Traded Funds Exchanged Traded Funds (ETFs) offer self-directed investors an easy-to-use tool for growing their net worth.   You can think of an ETF as a basket of securities that can be bought and sold just like the stock shares for an individual company.   If the basket of securities for an ETF goes up over time, then shares for the ETF shares can also rise.   Of course, ETF share prices can also decline over time when their underlying basket of securities fail to rise or even just do not grow from their purchase price.   The objective for self-directed investors who want to grow their net worth with ETFs is to invest and hold shares in ETFs whose prices are increasing instead of declining most of the time. Leveraged ETFs are designed for investors who seek to have their invested net worth grow faster than an underlying basket of securities.   The greater the leverage for an ETF, the greater potential for accel