A Blog for Traders Who Like to Analyze Their Trades and Data Analysts Who Like to Trade

The Security Trading Analytics blog focuses on practical, data‑driven analysis for traders.  You’ll find posts ranging from collecting historical stock prices to backtesting buy‑sell models across different strategies and asset classes.  Current posts cover single‑stock ETFs, leveraged and unleveraged index ETFs, bitcoin‑related stocks, semiconductor stocks as well as a host of other assets. Most examples use spreadsheets and T‑SQL programming, but you’ll also see PowerShell scripts and metrics such as compound annual growth rate, overall percentage change, and cumulative growth rate across trades.

The blog is authored by Rick Dobson, who operated his own national seminar practice, worked on finance and healthcare development projects, and contributed regularly to MSSQLTips.com.  His work was recently recognized with the MSSQLTips.com Leadership Award.  He is also the author of ten programming books on Microsoft Access and Microsoft SQL Serer.

Announcements for new posts appear in selected LinkedIn groups and Reddit subgroups.  These announcements point to individual articles, but once you arrive at the blog, you may want to explore additional content.  To help you find exactly what you need, this post walks you through how to use two navigation tools:

  • Archive: Organizes posts chronologically by publication date.
  • Labels: Groups posts by topic, making it easy to see which articles share the same themes.

The Archive Tool

The Archive tool lets you browse posts in the order they were published.  To access it, click the Security Trading Analytics hyperlink in the first sentence of this post.  Your browser will display the blog’s homepage, which includes a banner with the blog title and an “About” statement.



Click the white arrow to the left of the blog title.  This opens another page, and when you view it in full‑screen mode, you will see two menu items on the left side. You can click either item to open the Archive or Labels feature.



Clicking Archive displays the list of posts by month and year.  As of the date the screenshot was taken, March 2026 contains two published posts.  Other months with two or three posts include December 2025, November 2025, and May 2025.  All remaining months in the screenshot contain one post.  Clicking Show More expands the list back to the blog’s inception in December 2023, which includes four posts.

 

If you click the March 2026 Archive entry, you will see a blurb for the most recent post in that month.  The blurb shows the title and the first several lines of text.  If the content interests you, click READ MORE to open the full post.  Otherwise, click MORE POSTS to move sequentially through earlier posts.


 

The Labels tool

If you click Labels instead of Archive, you will see a list of topics assigned to posts on the blog. The number in parentheses after each label shows how many posts share that label. Most labels appear in just one post, while the Backtesting label appears in three.  You can also click the Show More button to display the full list of labels for all blog post.



Clicking a label returns blurbs about the post with content on that label.  Here is the blurb that appears when you click the Buy-Sell Percent Improvement label at the bottom of the preceding screenshot.  The title for the post depicted by the blurb is “Comparative Market Performance for a Buy-Sell Model Versus a Buy-and-Hold Strategy for Eight Tickers”.


If you wanted some more details about how the buy-sell model compared to the buy-and-hold strategy, you could click the READ MORE text in the lower right corner of the preceding screenshot to open the post referenced by the blurb in your browser.  Then, if you scrolled through the post, you would eventually discover some text and a table like that which appears below.  This ticker describes how the buy-sell model compared  to the buy-and-hold strategy, and it supports the explanation with a table of results.


Next Steps

An obvious next step is to read more posts at the Security Trading Analytics blog.  When you arrive at a new post from LinkedIn or Reddit, you canl use the Archive and Labels tools to explore related content and get more value from each visit.  LinkedIn members can request Contact membership with me (Ricardo “Rick” Dobson) on LinkedIn so you can be notified of new posts as soon as they are announced.

What I Learned from this Post

  • The Archive tool lets you browse posts in the order they were published, which helps when you want to follow how a topic developed over time.

  • The Labels tool groups posts by theme, making it easy to jump directly to topics such as backtesting, buy‑sell models, or percent‑improvement metrics.

  • Using Archive and Labels together helps you get more value from each blog visit. You can see what came before or after a post and quickly find related content that expands on the same ideas.

  • These tools make it easier to explore the blog, discover additional posts, and understand the broader context for any article you arrive at from LinkedIn or Reddit.

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    SQL Server o    Google Sheets with the GOOGLEFINANCE Function o     Tiingo o     Excel o   ...
Read more
Image
  ETF Price Puzzles: Examples Showing Tiingo’s Raw and Adjusted Series Don’t Always Differ As I was preparing an analysis of a buy‑sell model for several major ETFs, I stumbled across some unexpected puzzles in the price data.   Tiingo provides both raw and adjusted price series, but for certain ETFs the two are identical — even across known split dates. This post explains how I discovered these puzzles in selected ETF ticker prices from Tiingo.   The post also describes why the puzzles matter, and how you can adjust for them when performing ETF analyses with Tiingo data. Where I Discovered Tiingo ETF Price Puzzles I was analyzing a model based on EMA proper orders for prices when I first noticed ETF price puzzles.   Any ETF price series can have multiple EMAs depending on their period lengths.   No matter what the period length for an EMA, it is always dependent on its underlying price data.   For any trading date, EMAs with shorter period lengths...
Read more
Image
  Building and Backtesting a Buy-Sell Model with Close Prices and EMAs Buy-Sell models are among my favorite analytical techniques because they simulate what traders do on a regular basis – namely, buy and sell securities.  However, no amount of backtesting is enough to guarantee how well a buy-sell model reflects actual market performance.  This is because publicly traded financial security prices are driven by diverse factors that can change over time.  Nevertheless, buy-sell models can offer useful guidelines for buying and selling securities when current market conditions are similar to previously backtested market scenarios. EMAs are another of my favorite analytical tools for modeling the behavior of security prices.  EMA is an abbreviation for an exponential moving average.  However, an EMA is really not an averaging technique.  Instead, EMAs are a smoothing technique for time series data.  The period, or more precisely period length, of an...
Read more