Security Trading Analytics Blog Posts
through May, 2025
(Click on Title to Navigate to a Post)
TitleDate
Comparative Market Performance for a Buy-Sell Model Versus a Buy-and-Hold Strategy for Eight Tickers5/27/2025
Programming and Backtesting Demonstrations for a Buy-Sell Model for Eight Tickers5/2/2025
Building and Backtesting a Buy-Sell Model with Close Prices and EMAs3/29/2025
What are Single-Stock ETFs and Should I Invest in Them?2/23/2025
An Assessment of Selected Bitcoin-Related Securities from 2020 Through 20241/27/2025
Assessing Returns for Stocks In Watchlists1/1/2025
Do Returns from the GOOGLEFINANCE Function In Google Sheets Match Returns from Yahoo Finance?10/30/2024
GOOLEFINANCE Function in Google Sheets Can Download Historical Data via CSV Files9/26/2024
Yahoo Finance No longer Supports the Free Download of Historical Data via CSV Files9/11/2024
Compound Annual Growth Rates for Leveraged Versus Unleveraged Exchange Traded Funds7/25/2024
An Introduction to Computing and Interpreting EMAs with Excel6/17/2024
Using Google Gemini to Learn Candlestick Charts and Moving Averages5/24/2024
Investing in Bitcoin-related Securities4/18/2024
Bitcoin USD Exchange Rates Versus Major Market ETFs3/14/2024
How to Download and Display Historical Price and Volume Data2/19/2024
Can Leveraged ETFs Safely Grow Long-Term Investments?1/27/2024
Bitcoin-related Ticker Performance in 2023 Year and in December 202312/30/2323
How to Compare Close Prices for Three Securities Over Four Year12/26/2023
Selected Prior References About Securities Trading Analytics Blog Topics from MSSQLTips.com12/3/2023
About the Security Trading Analytics Blog12/3/2023


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
  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...
Read more