Posts

About Security Trading Analytics Blog

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
Image
  An Introduction to Computing and Interpreting EMAs with Excel   This post offers introductory coverage for computing and interpreting exponential moving averages (EMAs) with Excel.   I have written about and regularly use EMAs in my own securities trading.   A couple of my prior articles ( Differences Between Exponential Moving Average and Simple Moving Average in SQL Server and Revisiting Time Series Model Performance Assessment with T-SQL ) focus on how to compute and interpret EMAs.    Because of the significance of EMAs to security trading analytics, I expect to issue multiple posts on this topic in the next couple of years. This is the initial post with coverage of EMAs in this blog.   Therefore, the coverage will be both basic and simple from an analytical perspective.   The focus of this post is to show how to use Excel for computing EMAs and interpreting EMA values.   Excel’s charting capabilities are tapped to illustrate how to interpret EMAs.   The post also includes