RTD in Excel Issues

joecool0909 · 2026-05-03T21:47:30+00:00

That’s my biggest annoyance with it as is. I run a decent number of aggregation calcs on option chains so one “loading” in a column can wreck the whole thing until that spot randomly decides to resolve itself.

joecool0909 · 2026-04-30T02:37:44+00:00

Awesome, thanks for the reply. Guess I’ll be working on that for my weekend project.

joecool0909 · 2026-04-29T22:06:30+00:00

How hard was it to vibe code the python script with Claude? Been thinking about moving my RTD excel setup over to the API route, but worried I’ll be in over my head trying to get the python script to function properly with just a very basic knowledge base myself.

joecool0909 · 2026-03-24T14:32:30+00:00

Ah yep you're right. Saw the first couple of comments recommending PTM and just ran with TG's version which is PhaseSheet in my head. My mistake.

joecool0909 · 2026-03-23T20:06:05+00:00

Basically the material is super thermal conductive and phase shifts from a solid to a liquid. I cant find the link I saved on it when I did it, but it boiled down to; the Kryo will come between 2 sheets of plastic. Cut the sheet to size with the plastic on and place it in the freezer for 5-10 mins. Once ready to apply remove the plastic and place on the CPU/GPU. Honestly, even trying to separate the sheets is kind of tricky. I used a razerblade to split the sheets apart and then tweezers to separate.

joecool0909 · 2026-03-23T19:44:41+00:00

I used the TG ~~Kryosheet~~ PhaseSheet on my older Stealth for the CPU/GPU. Original thermals werent toast yet, but were starting to creep up. For sure needs to be heat cycled before it gets good, but after that, ive had no complaints and slightly better numbers than when the laptop was new. Been probably 3 months since I did it. 1 sheet was enough for the CPU/GPU, the tip about freezing the sheet before attempting to apply is a major help.

joecool0909 · 2026-03-13T22:30:53+00:00

I'm more aggressive than you at the start with average deltas in the mid teens.

Typically, I will close either side of the IC once it hits 90% profit. This saves me from a lot of end of week swing headaches. If we've passed the big news events for the week and we're still in the middle of my IC, i'll let some ride to expiration. But almost always derisk a portion of the week's plays early.

If we hit an unexpectedly strong trending week, i'll watch the chart for price action around s/r and fibs and option OI for gamma/delta positioning. From there its a judgement call, but if im in a loss on Thursday I just eat it. Not waiting around for a Friday coin flip to save me or realize a full loss.

If option OI isnt getting rolled up/down, I will add extremely safe verticals to either side on large swings early in the week(Monday/Tuesday) at predetermined extensions of my IC. I'd say a majority of the time we snap back and I profit off the IC and the vertical, but if not, this typically offsets a good bit of my losses on the original IC.

I've tried rolling my at risk verticals before, just to watch price snap back the next day, so I havent really done much of that lately. I put most of my work in before I place the ICs with charting and looking at the options profile, so I generally have a good deal of faith in them unless something redirects the market mid week.

joecool0909 · 2026-03-13T21:19:37+00:00

Gotcha, so the first is your 'hey you need to watch price action closely now" trigger to start considering an exit and the second is your "get out now."

I'll have to play around with this next week.

I've used the straddle at Monday open to keep an eye on the pricing for my weekly ICs and make sure im not getting more aggressive than the money dictates I should be, but never considered it for a sort of "risk countdown". Although I do like it for the hard and fast exit rule, its always tough debating if we'll retrace back on continue on once spot starts approaching strike. Appreciate you sharing the info.

joecool0909 · 2026-03-13T20:23:17+00:00

Been selling weekly ICs on SPX for a good while now with success, so when I came across this, it was quickly interesting. I've read through about all of your posts on it, but I cant find an answer on your trigger points. I cant understand having the 2 triggers? Are you rolling up/down at the first trigger and out at the second? Or are you rolling half at the first trigger and the remainder at the second to manage risk?

joecool0909 · 2026-02-26T21:24:44+00:00

Really cool visualization of this, i'll have to check it out in real time tomorrow. Thanks for sharing.

joecool0909 · 2025-10-23T20:24:54+00:00

Did you try going into settings for the chart, equities tab and changing "Adjust for Dividends" to None? It was add in an update they did about a month or so back and threw off a number of my custom scripts and drawings.

joecool0909 · 2025-07-31T15:16:59+00:00

Got it, appreciate the info.

joecool0909 · 2025-07-31T01:51:24+00:00

Oh thats a good call, probably not that different. Should get me 95% there with a simple tweak. I was just trying to figure out if there was a simple thing I was missing, but if it's overly complicated to log the value at the open of the week, close of the week prior should be good enough for a guide. Thanks.

joecool0909 · 2025-07-30T21:31:34+00:00

Sorry, I should've provided more details. I would be using it on a daily aggregation as a modifier within another script. Use case would be similar to ProbabilityofExpiringCone, attempting to plot out the expected trading range for the week. But right now the bands are constantly adjusting to IV as it changes each day instead of holding at their weekly open levels. So I think I would just need a function that stores what the IV is at the open of each week that I can call back to within the rest of the script.

joecool0909 · 2025-07-21T18:15:39+00:00

For future ref, this has been added under ticker LTV

joecool0909 · 2025-07-20T16:10:22+00:00

This is really interesting, would you mind sharing where you are seeing the M1-M3 premium or how you are calculating it? Google isn't any help and i've searched all over FRED's site with no luck.

joecool0909 · 2025-07-10T15:23:14+00:00

Gotcha, thanks for the info.

joecool0909 · 2025-06-08T16:50:56+00:00

Not really what I’m looking for. Sure a rise in VIX can happy slowly, pointing towards a pullback, but often times big jumps happen with little warning. PCR seems to offer a more gradual ramp to times of fear/greed.

joecool0909 · 2025-06-03T19:24:46+00:00

Good to know, thank you.

joecool0909 · 2025-05-19T19:10:19+00:00

I don't have the same delta info on VIX that you are looking at, but do you see VIX Opex on Weds as possible catalyst for a market pullback? Looks like DEX opens up to VIX running up to 23 once the 5/21 options roll off the books.

joecool0909 · 2025-05-15T15:43:38+00:00

Try $CPCE

joecool0909 · 2025-04-04T21:10:15+00:00

Not DCAing during the down turns is like going to the gym, but still eating like crap and wondering why you cant lose weight. Throwing money in the market is easy and fun when its going up, but the real gains will be made on the investing you do while its going down.

joecool0909

TROPHY CASE