Oh What a Tangled Web We Weave When First We Update a Spreadsheet from Fed Data
I got into a bit of a pickle this weekend when updating my Primary Dealer position and Financing charts. The spreadsheets that I use to create them are massive aggregations of multiple New York Fed data tables. I need to create dozens of linked tables to collect and aggregate that data into two coherent story telling charts.
I made one small change in one of the two workbooks by adding a couple lines to accommodate an extra week of data. Simple, right? That caused a series of cascading errors in the two linked worksheets. The New York Fed doesn’t make it easy, to aggregate this data. In fact, they make it nearly impossible, which is probably why I’m the only one crazy enough to try this at home.
I didn’t realize the error until I was finished and looked at the chart. It was trash. It was all trash.
I spent 3 hours, until midnight last night, rebuilding all of it, after spending 3 hours building it. So I don’t have a finished report on that data as I had intended, nor was I able to get to the technical report on Sunday night as I usually do.
That’s my sob story excuse for presenting the Technical Trader report for you in two parts this morning, which may be a better way to do it anyway. 😀 First, I’ll start with the chart picks, herein. I’ll get the technical market overview out to you well before New York opens.
If I’m lucky, I’ll get that Primary Dealer report out to Liquidity Trader Money Trends subscribers this morning also.
Thanks for your commiseration and support!
And now, on with the show.
As a thanks to Liquidity Trader Money Trends subscribers for your patience, here’s a link for you to download this report, if you’re interested.
These reports are not investment advice. They are for informational purposes, intended for an audience of investment and trading professionals, and other experienced investors and traders. Chart pick performance changes week to week and past performance may not indicate future results, as you know. Trading involves risk, and these reports assume that you understand those risks and manage them according to your tolerance.