Written and contributed by Rich Kaczmarek Part 2 explained Excel’s RTD function and how it interacted with ThinkOrSwim (TOS). Excel’s UPPER function was introduced, we indirectly referenced a symbol and a ThinkOrSwim directive, and you learned a clever way to copy equations to new cells so Excel would modify just the parts you wanted modified […]
Cynthia Sarver
Connecting ThinkOrSwim to Excel-Part 2 of 4
Written and contributed by Rich Kaczmarek The last article covered some DDE versus RTD technobabble and left you with an example of how to use RTD in Excel to get the last price of RUT from ThinkOrSwim (TOS). Not bad for a day’s work but let’s take it to the next level. Before we begin, […]
Connecting ThinkOrSwim to Excel-Part 1 of 4
Written and contributed by Rich Kaczmarek You can’t beat a spreadsheet for turning big chunks of data into actionable information. Without some experience in programming, however, it isn’t always the easiest way to manipulate real-time data. Let’s write (get it?) that wrong! It is easy to have ThinkOrSwim (TOS) stream live data into Excel but it’s […]
Under Pressure
We’ve had a significantly different market in 2016 than many people are accustomed to trading. Overnight gaps, intraday reversals and huge ATR’s have made it a more challenging trading environment than the previous several years. If you’re accustomed to nice, neat, well-behaved markets, this year has been an eye-opener. Perhaps you’ve had some losses. Perhaps […]
So what’s your real risk in the trade?
In my article “The Beauty of Planned Capital”, I mentioned the trader who reported his profit by completely ignoring his potential risk. I’m sure that everyone reading thought, “Geez, what a goof! I’d never do that! I know MY risk!”. Hooray for you! I hope so. But…I keep hearing people say things that make me […]
The One That Got Away
Snatching defeat from the jaws of victory You know the trade. We’ve all had them. It’s going along wonderfully and then suddenly, without the slightest provocation, it’s a losing trade. Mine was this January. It was probably the most flawless, easiest, most lovely M3 I’ve ever seen. Always profitable, rarely adjusted, it just burbled along making money. […]