|
| Let me start by saying I looked at a lot of etf swaps. None of them look like the sheet from xrt. Not even close. Xrt still has swap expirations from years ago showing up. And plenty for the future. Just an absurd amount for an obscure etf or any etf or even just any stock for that matter.
Anyway you start by looking up the upi code but I’ll do that part. It’s in the title.
Then you take that code to this website
Pddata.dtcc.com
Here you go to search. Then
-switch to “sec”
-switch to “equities”
-put the dates in. I just go back as far as it lets you. Go about fourth months back and that should get you all the info they have. If you put in too long of a time frame it’s no good
-put the upi code in
-switch it to csv and give the file a name
-click search
The file comes up under the reports tab. It takes a few minutes
Worth noting I don’t have a desktop computer and my
Laptop is really old and slow. So I’ve been using an iPhone. The pddata website can be tricky with the formatting but it’s doable.
Click download once the report is ready.
Open in preview then at the bottom it’ll have an option (usually before the data loads) to open up in “numbers”
It’s apples version of excel. Phone should come with it I think.
Next use the descending filter to filter by expiration date then add another filter for event timestamp as the second one.
I Then move the isin column next to the expiration date. And also collapse a lot of the empty columns.
It’s worth repeating this on the regular just to get a sense of it. Maybe just checking on Tuesday after the close lol
Tuesdays are important. Well let me say, the second day of the week is important for how the banks and market makers hedge.
Typically if a stock is goi g to rip up that week, the far otm calls that will be itm by end of week usually bottom on Tuesday around 9-1030 central
This also goes for sharp drops.
Ai explained it to me. Anyway the second day of the week usually
Edited by Deltamudd 6/18/2026 22:20
| |
|
XRT : upi code QZ2WW90VC9F8
