I’ve got an Excel sheet working that will send you an email upon a cell value changing. Right now it requires a Gmail account. I’ll try to generalize it as much as I can. I plan on releasing it as a free tool when it’s done. Then you can use it in your own DDE spreadsheets. I will also incorporate it into the CAT tool for donors. And I will also update the ability to stream custom columns from TOS through DDE in all my tools, thanks to reader Allen, and put up a full tutorial to walk you through setting it up. No ETA, could be a couple of weeks.
Posts Tagged ‘CAT’
Here’s a plot of part of the day’s Dollar Weighted On Balance Volume superimposed over the price of the S&P E-mini (ES) futures. It only covers the part of the time my laptop was connected to the intertubes today, but I thought it was interesting. The Pink is the ES, the Blue is the DWOBV. There was a divergence around 10:30 AM that was followed by a big drop:
Also, I updated the dollar weighted CAT tool to record and plot the ES price (or whatever you put in your list as the first symbol), as well as added a capability to add a start time. That way you can click “Start” and it will wait to record until the time hits, or leave it blank and it will just start immediately. The update is in the “CAT_TOS_DDE_Recorder.zip” file in “Released Tools“. In the future I plan to do a bit of a re-do of the tool to make it more generic, so keep your eyes peeled for that.
It was pointed out to me that the prior CAT tool is really making a plot of On Balance Volume. I called it Advance / Decline, but it’s not really doing that in the official sense of the term. Anyway, it was also pointed out to me that 5 million shares of a biotech bomb move this indicator just as much as 5 million shares of GOOG, which is right, of course. So I added another file in my CAT tool release, called “CAT_DollarWOVB.xls”. It’s a dollar-weighted On Balance Volume calculation. This way, the 5 million shares of biotech bomb at $1.20 isn’t as important as the 5 million shares of GOOG at $525.
Download the “CAT_TOS_DDE_Recorder.zip” at “Released Tools” to get the update.
Donors rejoice: It’s finally here! My Complex Analysis Tool (CAT) for Think or Swim. This tool is an extension of my TOS_Excel_DDE tools, with the addition of macros that record the data at time intervals you choose. I covered the full how-to on DDE linking in a previous post. An earlier version is what I used to create the plots in these two posts.
The CAT tool comes pre-configured to take the S&P 500 and calculate an Advancing / Declining Volume for the index in real time. You can get data as often as every second. If the price of a stock now is above the price at the last time step, then the volume for that stock since the last step is positive. Vice versa for down. The result is summed for the whole list and then plotted. Here’s an example plot:
You could adapt this tool to other calculations or stock watch lists. Instructions are in the file; hopefully it’s self explanatory, but I can answer any questions you may have as you try to modify it to your needs.
The CAT tool is for donors only. You can download the file “CAT_TOS_DDE_Recorder.zip” from the Donors Only folder under the “Released Tools” section on my Google Site. If you haven’t yet become a blog donor, you can do so now by clicking the donate button. Donate an amount you feel my tools are worth to you.
If you want me to make you a custom version of the CAT tool, you can also email me for a price quote. Thanks for your support!