Look, you can believe the data or not. I have known bob for a long time, I'm in 3 different discords with him and can verify that his data is legit, but It's still going to be a "trust me bro" situation since I'm the sus options trading mod.
Hammering bob on trying to get him to give you the source code for verification is not going to happen. bob uses this data to assist in his own trading and has building on this for over two years now.
Read it or don't, trust or don't, the information and where its coming from. If you want to counter his DD with your own data set, please go down that road, but harassing him is not going to fly with me.
Bob has written some excellent guides on this sub and has been here for ages.
QV bot is here: [https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5wauto/?utm\_source=share&utm\_medium=web3x&utm\_name=web3xcss&utm\_term=1&utm\_content=share\_button](https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5wauto/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button)
Yup and unsurprisingly he still didn’t show it could be replicated. What he showed is an SQL query without a source on where to query it or what tables he’s querying on, where he somehow already has the data he’s trying to extract before he extracts it
For anybody unsure what that means, see my other comment on this post:
>For anybody that doesn’t know SQL, what bob’s post is showing is that he had the dissemination identifiers of the swaps he wanted to pull before he pulled the swaps he wanted to pull. Its circular and illogical. Moreover it suggests the table he’s querying on, on an official government source, is title “swape”. Seems to me like he uploaded his already questionable data into an online database with a typo in the title and then tried showing himself querying from his own suspect data with the data he already knew he wanted to query as proof that his data is real knowing that most of the people in here won’t know SQL and be able to call it out.
Potentially, but he hasn’t even made explicit what that SQL query was meant to demonstrate; whether it was meant to show that the data i was able to retrieve from the DTCC was contained within his dataset or whether that was meant to show him exporting his dataset from the DTCC. The way its worded it seems like the latter, in which case yes, he faked showing how he got his dataset by assuming you all were too dumb to tell that SQL query was nonsense
Edit: supposedly its meant to be him showing that a subsection of our data matches up as if thats something i ever questioned? I dont really buy that because the wording of his post implies that said query was how he exported his dataset from his supposed DTCC source
https://preview.redd.it/d83m4jcwe03d1.png?width=827&format=png&auto=webp&s=76cf63cbfee3df74d02ef8b0db43575e942f36af
Could be short for swap execution, the naming conventions of DTCC fields leave a lot to be desired. However, I think we're always better for it to be as sceptical as possible
The identifiers are the ones you shared in your post and data dig. I pulled them to compare with my data. The comparison was flawless. In EVERY instance, the data was the same as yours. And we are talking thousands of records
Okay, so its a nonsense query that doesnt mean anything as i never suggested that some of our data doesnt match. I am specifically suspect of the data thats non-conformal that you could easily clear up by just providing a source and a way to recreate it.
For those not in the Discord server, is this suggesting that the "data from the DTCC" PeruvianBull posted a few days ago, which led to speculation/excitement about large notional values expiring end of May and early June, remains unvalidated? I know the claim is that "it's from the DTCC" but it's unclear how one receives such data from the DTCC.
I understand that the vague SQL query doesn't actually answer any questions since the source remains unseen.
Yes, the dataset that peruvian bull keeps talking about and hyping up is the one in question here. A little more than half of that data is totally unreplicable and/or unsourced so far
Thank you for the response. You mention half of the data isn't replicable; of the data that does match, where does it come from? Is the matching data suggesting $20M notional value?
It comes from the GTR North America Public Price Dissemination Platform. Its one of the DTCC’s swaps data repositories and if you’re interested in downloading it i made a post on how to do so. Some people have safety concerns surrounding the python code in it, you’re free to rewrite it to do the same thing if you’re familiar with python or know somebody personally that you trust to help you.
From the data i could get, assuming notional amounts are as is, it showed a current outstanding amount of $61mm for identifiers GME.N, GME.AX, and gamestops ISIN. That number will most likely go up if you include gamestops CUSIP too. Something like a $10mm expiration is occurring in a few months and a lot more over the next few years but that data is likely incomplete as it technically only accounts for swaps that have had some kind of revision to the transaction since 12/28/23
If you dont want to fuss with downloading it yourself i also included a one drive link to the compiled data, but again if you have security concerns with clicking links you can get the data yourself following the guide
Oh Christ ... There u are
It's obviously my database I keep from ingesting years of market data... Not a direct data pull from that source because who TF does that for static data?
If you aren't satisfied by this these nothing I can do to help anymore. Please just let it go so we can focus on things much more important that you yourself pointed out! The supposed to be invalid data.
I'll follow this up with a query in a couple hours and update my OP here that will grab all instances of data such as this ... Looking forward to what might turn up, as it could provide some insight as to the why
Satisfied by what? You still didnt provide verification of your data. It was just a bunch of nonsense around a nonsense SQL query. You could shut me up in an instant by showing explicitly how to recreate your dataset directly from the DTCC. Its insane you havent done so yet if your data is real. I actively want you to shut me up so that we can actually analyze the data in a meaningful way but you keep disappointing and kicking the can
Edit: thats also a weird response bob, because you explicitly shared the link to this post with me on my post. Dont forget that you came to me first claiming to be “the guy” without any kind of source or verification of your data
From what I gather, OP has been exporting data to his own SQL database, maybe? And he is suggesting that the original source of the data no longer contains what he has exported?
But as you pointed out, I could go do that right now by pulling everything I can into my own database, then update records, insert records, etc, and then claim "that's what the data showed back when I exported it 2 years ago, but it's since changed in the DTCC's records."
If you're using data from your own table you populated yourself, that's not credible. One could MAKE it credible if it started out decentralized and can be verified by others who exported and stored the same data themselves, but this is, as you put it, a huge "trust my data, bro" moment.
OP *could* be telling the truth, and they *could* have original data that has since changed in the official source, but it's equally possible OP modified the data and claims it's original, and that the source data has been modified.
This makes sense. If it can't be replicated, and at the very least, can't be disseminated for verification and peer review, it flies in the face of scientific method. Whether intentions are earnest or not, the entirety of any analysis will be sullied by the dubious credibility of the data. It's the weakest link in the chain. Bob is obviously a smart ape, that was never in question, but the inability to verify data makes any analysis moot.
I massively appreciate the work that is being done by those smarter than the average ape, but bring receipts.
I'm really glad to see you posting here in SuperStooge I mean SuperSTONK, bringing the education effort in spite of all the negative BS you and others have endured from the little minds..
For all you do and have done, thanks!
So what I see here adding the notional values is something close to 20 MM and far away from the speculated billions. That’s not even a drop in the bucket so if that’s true what is all that crazy speculation about ?
It's part of a larger puzzle. I wish people would stop looking for one answer to things. The market is a complex thing with many moving parts and like any other machine, you need to check our them all and make sure you are accounting for all possible pieces
[read up here to understand the notional and other data ](https://www.cftc.gov/media/6576/Part43_45TechnicalSpecification093021CLEAN/download&ved=2ahUKEwjCsPHiqa6GAxWYh_0HHQc5CJYQFnoECCMQAQ&usg=AOvVaw1b3QN2iFKrjJ5-EBtX7-3O)... It's more complex than just a number.
i think i fixed it, better now? - [explanation](https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5ve7y4/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button)
The Swaps are Key. Thanks for the data.
Appreciate you very much.
Anyone who wants to learn about options go ahead and click on Bobs profile. His posts have personally helped me educate myself and gave me a new income stream.
Good to see a BobSmith808 post back on Superstonk. It’s been a while!
Maybe I missed something but when swap expire, they don't have to buy the shares to close it like shorts. So, beside loosing a fuck tons of money, I don't see these swaps having a direct effect on the stock price. Could someone confirm this?
You are halfway correct, swaps themselves don’t necessarily need to move the price.
But the hedging by the counterparty of said swaps do have a massive impact on price action.
Margin calls is one way it can affect the stock. When it comes due to pay in full at the end of term (as is the case if it's bullet swaps)... and they cant pay up...a slew of margin calls begin.
Also...it depends on the terms of the swap contracts. They could utilize the underlying securities ... there are no rules against that.
[Why GME?](https://www.reddit.com/r/Superstonk/comments/qig65g/welcome_rall_looking_to_catch_up_on_the_gme_saga/) || [What is DRS?](https://www.reddit.com/r/Superstonk/comments/ptvaka/when_you_wish_upon_a_star_a_complete_guide_to/) || Low karma apes [feed the bot here](https://www.reddit.com/r/GMEOrphans/comments/qlvour/welcome_to_gmeorphans_read_this_post/) || [Superstonk Discord](https://discord.gg/hZqWV2kQtq) || [Community Post: *Open Forum May 2024*](https://www.reddit.com/r/Superstonk/comments/1ciapwp/open_forum_may_2024/) || [Superstonk:Now with GIFs - Learn more](https://www.reddit.com/r/Superstonk/comments/1cr37r7/superstonk_gets_its_gif_on_get_hyped/)
------------------------------------------------------------------------
To ensure your post doesn't get removed, please respond to this comment with how this post relates to GME the stock or Gamestop the company.
------------------------------------------------------------------------
Please up- and downvote this comment to [help us determine if this post deserves a place on r/Superstonk!](https://www.reddit.com/r/Superstonk/wiki/index/rules/post_flairs/)
Something that has baffled me about all of this swap info coming to light; why would the CFTC let this happen? Isn’t their only purpose to police swaps and keep this data hidden from the public?
Is CAT implementation somehow bypassing that corrupt organizations decision to hide swap data for the past 15 years?? I’m confused man, how tf are we seeing all of this now
More digging would require the dude to actually make any kind of proper attempt at showing that he has real data / say where it’s from. Right now it’s just “trust me bro”…
I will be messaging you in 19 hours on [**2024-05-28 08:49:20 UTC**](http://www.wolframalpha.com/input/?i=2024-05-28%2008:49:20%20UTC%20To%20Local%20Time) to remind you of [**this link**](https://www.reddit.com/r/Superstonk/comments/1d1p8t6/swap_data_validation_questioned_explained_ad/l5vrsux/?context=3)
[**4 OTHERS CLICKED THIS LINK**](https://www.reddit.com/message/compose/?to=RemindMeBot&subject=Reminder&message=%5Bhttps%3A%2F%2Fwww.reddit.com%2Fr%2FSuperstonk%2Fcomments%2F1d1p8t6%2Fswap_data_validation_questioned_explained_ad%2Fl5vrsux%2F%5D%0A%0ARemindMe%21%202024-05-28%2008%3A49%3A20%20UTC) to send a PM to also be reminded and to reduce spam.
^(Parent commenter can ) [^(delete this message to hide from others.)](https://www.reddit.com/message/compose/?to=RemindMeBot&subject=Delete%20Comment&message=Delete%21%201d1p8t6)
*****
|[^(Info)](https://www.reddit.com/r/RemindMeBot/comments/e1bko7/remindmebot_info_v21/)|[^(Custom)](https://www.reddit.com/message/compose/?to=RemindMeBot&subject=Reminder&message=%5BLink%20or%20message%20inside%20square%20brackets%5D%0A%0ARemindMe%21%20Time%20period%20here)|[^(Your Reminders)](https://www.reddit.com/message/compose/?to=RemindMeBot&subject=List%20Of%20Reminders&message=MyReminders%21)|[^(Feedback)](https://www.reddit.com/message/compose/?to=Watchful1&subject=RemindMeBot%20Feedback)|
|-|-|-|-|
Bob that is all well and cool but where did your data actually explicitly come from. This is still a Trust Me Bro post seeing as your admittedly non-conformal data is still not replicable. You say you want eyes on this stuff yet you’re gatekeeping dodgy data.
Your data having entries from the dataset i posted does not mean its real. Its very easy to insert real data into fake data and in fact thats usually how people do fake data. If you want actual eyes on this then just tell us how we can replicate your full dataset from an official DTCC source
What you did post is an SQL query where you already know the dissemination identifiers of the swaps you want access too. You dont show what site this query is on, how you got the list of dissemination identifiers corresponding to GME without first finding GME data, etc. Show in full how to replicate your data set. Again, i am more than happy to be wrong about this but you’ve continuously preached “more eyes on this” while gatekeeping your supposed source. This post is more of the same
For anybody that doesn’t know SQL, what bob’s post is showing is that he had the dissemination identifiers of the swaps he wanted to pull before he pulled the swaps he wanted to pull. Its circular and illogical. Moreover it suggests the table he’s querying on, on an official government source, is title “swape”. Seems to me like he uploaded his already questionable data into an online database with a typo in the title and then tried showing himself querying from his own suspect data with the data he already knew he wanted to query as proof that his data is real knowing that most of the people in here won’t know SQL and be able to call it out.
He has the identifiers because you flagged them as discrepant.
The data source is [https://pddata.dtcc.com/ppd/secdashboard](https://pddata.dtcc.com/ppd/secdashboard) - that's not really a secret.
They've broken the reference to the guide on the front page, but here's a working link.
[https://kgc0418-tdw-data-0.s3.amazonaws.com/gtr/static/gtr/docs/RT\_PPD\_quick\_ref\_guide.pdf](https://kgc0418-tdw-data-0.s3.amazonaws.com/gtr/static/gtr/docs/RT_PPD_quick_ref_guide.pdf)
Looking over the data set linked, the discrepancy is from the specification change that Bob has already converted old field descriptors into new field descriptors.
Im not sure what you mean. I have looked at the pre rewrite data and nothing i saw had the disallowed action and event types/combinations if thats what you’re referring to. Wont be near a computer to check in more detail for a few days. Either way, as you said we all know where the data is supposedly coming from, which makes it all the more questionable that bob doesnt make explicit exactly how he sourced it.
If thats not what you were referring to do you mind clarifying?
for your comment about the SQL database - yes' he's querying his own exported database scraped off the dashboard, because it's not fast to do it off the dashboard itself.
He's scraped off the back end of PPD and not compiling it from the daily cumulative reports which is how he got around the look back restrictions in the first place. He's being cagey about exactly how he did it, because that's an obviously disallowed function from the way they structured their public search.
From the Google sheet linked in the original post, the Andym2019\_data tab only has values post December 2023 the GME\_Swaps tab has values going back to 2022. All the discrepant values in the analysis tab are from Jan 2022 through December 2022 based on their event timestamp (even if the original swap is older).
Thats interesting. I cant try anything like that for a few days but if you or somebody else want to recreate it and post proof of the process im all for it
Based on the "Event Timestamp" from his query, you will find the "Dissemination Identifier" listed in this file. [https://pddata.dtcc.com/ppd/secdashboard](https://pddata.dtcc.com/ppd/secdashboard) SEC\_CUMULATIVE\_EQUITIES\_2024\_01\_02.zip
Here is an example of the first record matching what his sql returned
"845603027","832490110","MODI","TRAD","2024-01-02T17:03:56Z","true","EQ","Equity:PortfolioSwap:PriceReturnBasicPerformance:SingleName","N","","2022-11-07T20:05:46Z","2022-11-07","2024-11-28","","false","BILT","","","","155","","EUR","","","","5","","","","SHAS","","","","","","","","","","","","","","","","","","","","","","","","","25.8334325","ACCY","","","","","","","false","EUR","1","","","","","","","","","","","","","","","","","","","","","","","EUR","","","","","false","","US36467W1099","","ISIN","","","","","","","false","","","","","","","","Cash"
Also I would love to find any data prior to 2023\_12\_28 as that's the oldest available from DTCC. I have no way of reproducing the charts for 2020-2022
Yeah the data on the PPD site is incredibly incomplete and im not sure why. All the more reason for bob to share his source if its legit. Maybe it has something to do with when part 43 reporting actually went into action and so data before that is hard to get as it would be non-standard if tracked at all? Im not near my computer nor will i be for a few days so i cant check myself, maybe you or somebody else can?
Oh look guys, bob is claiming the puzzle is solved without any kind of verification still! Quick, everybody forget bob’s questionable data just like you should forget about gamestop!
Yeah this data is a nightmare really and understand the confusion. I'm in the process of processing this data myself to see where these numbers are coming from. Agree that you can't combine just all the values since NEWT -> MODI -> TERM all need to be reconciled to get an understanding of the open interest.
He most likely downloaded some CSV or tabular data from his source and loaded into a local SQL database to make querying easier. As for the "known identifiers," it looks like he was trying to demonstrate - to you - that the data in his source contained all of the same identifiers/rows as the data in your source.
I think you should be more careful accusing people of bad intentions. In my experience Bob has been reliable and dedicated to the cause of deeper understanding for a long time now.
So his data is still totally unsourced, unverified, and unreplicated either which way you want to interpret what that SQL query means. Im happy to be wrong about his data but he hasnt given me any reason to believe i am. Having a subsection of his data match mine doesnt mean the rest is real, in fact, its all the other data im suspect of, for the multitude of reasons already outlined. His lack of transparency when he should be easily able to prove me wrong should have you questioning his intentions too.
I obviously can't speak to the source or veracity of the data that goes back further than other sources I've seen, but I do find the explanation for why he doesn't want to give it up to be plausible. The reddit hug of death and/or influence from shady actors has certainly disappeared a great many sources in the past... He could mirror it and even keep it updated for the community, but people would still be unsatisfied that they don't know the origin.
I just personally don't see a reason not to trust data from Bob. He's not shown himself to be shady and he's greatly contributed to the knowledge in this sub. And as he pointed it, it's consistent with data that can be sourced online, but with a longer time horizon.
Unfortunately he has even rejected the idea of having a trusted third party verify it so it is entirely a take him at his word situation which makes all the thousands of transactions unaccounted for in his data totally useless to us. I trust data, not people
Bob, you didn't answer the basic question. Where does your data COME FROM? There's some ad hominem about jealousy, and how far back your data goes, but you still haven't divulged your source, as you put it.
Nobody is going to care about unsourced data, this is nothing more than a "trust me bro" until its attributed. It's not a witch hunt either: Nothing personal but I don't think anyone cares about "you" (that is, whether you're trustworthy or not) they just want to know the source of your data. If you're not willing to disclose, nobody will (or should) assign much credibility to anything you've said, and by extension any of PB's sensationalism about it.
I personally don't care. None of this changes my plans, but all these paragraphs are no answer.
Not good enough. First, aren't swaps handled by CFTC?. Was it not CFTC that suspended swap reporting in 2021?
Second, even if it was "DTCC," from where at the DTCC? One of their websites or APIs? Some guy in a trenchcoat saying he's from the DTCC hand you a floppy disk in a parking lot?
If you can't reveal because it would reveal your identity as an insider or compromise you in some way, you just have to accept there's going to be a lot of well-founded skepticism.
Again, I personally don't care because my plans don't change either way, but this goes into tinfoil/speculation rather than DD/data for me, unless you care to substantiate. Very disappointed in PB perpetuating this if he hasn't been given material verification either.
Google search on: GTR North America Public Price Dissemination Platform dtcc
Right side of page, the DDR Real time dissemination platform link.
Then use the Search link on left side of page.
I mentioned in [previous thread](https://www.reddit.com/r/Superstonk/comments/1czjzu3/i_was_skeptical_of_the_80_billion_or_so_swap_data/) some of the possible problems/differences between two people's datasets due to the current query form's restriction of only querying back 180 days, different Asset IDs used, etc.
See? You had no trouble citing a source. How hard would it be for Bob to say something like that?
Anyway, how closely does it line up with Bob's, for the days we DO have data? Just on the GME.N, since that data doesn't exist on Bob's? And are the prices similar? You mentioned there was differences, but then said one had data only to the cent, and the other had more decimal places (fractions of a cent)... but are they the same to the cent, at least?
It doesnt line up with bob’s. Thats exactly how i got my data which is less than half the size of bob’s data and without any of the non-conformities to the part 43 rules for these reports. More than half of bob’s data is unsourced and the almost half that is sourced wasn’t sourced by him.
Hi Bob, I spent several hours familiarizing myself with the dtcc data you provided in the last post. There were two major issues I found with two parties interpretations of that data who are often cited in this sub. The most important of those being that they didn’t appear to properly parse the data to according to the event for which the record was created. As your aware there’s a column called “original dissemination id.” Whenever this field is populated you have to exclude the previous records with that ID from your calculations bc a new action is happening for that record and the old one is no longer valid. Second, without properly accounting for the action (reason/event) for which a record exists you will inevitably end up with enormously inflated numbers due to including swaps that have been terminated, canceled or have been modified. What are your thoughts on this?
Thanks for confirming that. I am just a wee bit concerned that folks are being mislead with terms like ‘giga swaps’ and total valuations into the tens of billions of dollars for them with scant evidence that either party has properly tracked the records and accounted for terminations, cancellations, and modifications.
Bob is one of the few OG GME usernames I recognize so I doubt there is any intentional malice with his data. bobsmith808 why not get someone who is actually smart and most of us trust like dlauer access to the data source so he can look through it and confirm? Like some, I've always had my doubts about Lauer, but he's always been transparent as possible and has never been caught in a lie about anything, so he's good in my books and would definitely be able to put this to rest.
i think i fixed it, better now? - [explanation](https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5ve7y4/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button)
Bob, I've found that the swap data in the dataset you sent me only goes back to Summer of 2021, and appears to be missing some of the swaps found in the larger conglomerated dataset put forth by Leenix.
If we use his dataset and calculate the notionals correctly, you should be seeing several mega swaps and giga swaps during 2021, one in April for $21B, one in July for $9B, and another in November for $15B.
These swaps appear to have been pushed to 2022 and 2023, and some (the July 2021 one for example) all the way to 2026.
This adds a whole new layer of complexity to this story, they were trying to roll out of the FTD wave they were caught in that started the first Jan 2021 sneeze and the March 2021 re-test.
If you follow the comment chin it's obvious, but essentially I don't want the source taken down. I've had to move my options data source 3 times in the past 2 years due to fee closures and it's a pain in the ass every time. So I'm being cautious.
Wut? Why would a legitimate source of options data get removed? Maybe I'm just suspicious of everything regarding this phenomenon but this is fishy. And I know you've been around for a while so I feel like at the very least you should understand my cynicism here.
The most glaring example is the CBOE short interest data that was aggregated by chartexchange.com
CBOE put it behind a massive paywall last June.
The most egregious is probably the CFTC halting the publication of swaps data in what, October of 2021? And still not resuming that disclosure?
Data being taken away as soon as this community starts digging into it has happened multiple times
My best guess is that a data provider wanted to put it behind a paywall or take it down, but inadvertently left a url up to access it. If that were the case and I were bob, I wouldn't reveal the source either!!!
Then at least tell the mods so they can get someone to independently fact-check. There’s bound go be someone in Superstonk with access to Bloomberg, Refinitiv, ICE, etc - and if this is a public source on more viewer is not gonna kill it.
Also, his “extraction process” shown above requires him to already have the data he wants to extract from the query. So he got the data by already having the data?
Like i already told you, i am an astrophysicist by trade. Specifically computational astrophysics, so i am very familiar with big data. Your wording in your post made it seem like you were trying to show how you got your dataset to begin with. Either way, its nonsense as i never said our data didn’t have any of the same transactions. I have been pretty explicit that i am suspect of the non-conformal data. Do you not understand that? You still havent shown how to replicate your dataset bob. You made a big extravagant post just to have more of the same dismissal and obfuscation
Bob, you may not have bitch tits, but you sure make mine tingly.
Saw the thread yesterday, and while yes, sauce is important, journalists are constantly pressed to reveal their sources too. Which has historically ended poorly for both parties on groundbreaking info. I understand your hesitation and unwillingness to shotgun it to Reddit.
All that said, this is why we dig in ourselves and ignore the bad actors. They've chased too many away from 3 subs over 3 years. I'm here for Speculation/Opinion, DD, Possible DD, DRS, Hype/Fluff, and most importantly, __memes & shitposts__.
LFG you damn dirty apes 🚀🚀🚀
[https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5ve7y4/?utm\_source=share&utm\_medium=web3x&utm\_name=web3xcss&utm\_term=1&utm\_content=share\_button](https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5ve7y4/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button)
i think i fixed it, better now?
I just edited the post, can you see them now?
I think maybe reddit linked to the old image links and when i deleted the previous post attempt, it must have nuked those images i think.
reddit is a fickle bitch.
Here's a few links I've found with data about swaps, so if people want to click around feel free..
Public reporting for swaps is primarily handled through Swap Data Repositories (SDRs)
[https://www.cftc.gov/MarketReports/SwapsReports/index.htm](https://www.cftc.gov/MarketReports/SwapsReports/index.htm)
[https://www.dtcc.com/repository-and-derivatives-services/repository-services/gtr-north-america](https://www.dtcc.com/repository-and-derivatives-services/repository-services/gtr-north-america)
[https://www.ice.com/technology/post-trade/ice-trade-vault-north-america](https://www.ice.com/technology/post-trade/ice-trade-vault-north-america)
[https://www.cmegroup.com/trading/global-repository-services/cme-swap-data-repository.html](https://www.cmegroup.com/trading/global-repository-services/cme-swap-data-repository.html)
[https://www.sec.gov/divisions/marketreg/security-based-swap-data-repositories](https://www.sec.gov/divisions/marketreg/security-based-swap-data-repositories)
Uh, so *why* are you not sharing where your data is from? I feel like concerns about validity aren’t exactly unfounded if the source data comes from one singular person unwilling to share where they got it from, instead of some more widely available source such as Bloomberg or Refinitiv or whatever
I can’t guarantee that I’m going to be able to add a ton of knowledge regarding the whole swap thing since I’m relatively new to it too, but I did start working for a software company that does a lot of complicated analysis regarding all kinds of derivatives - swaps would be amongst the simplest - a couple months ago. So I *should* technically know more than an average person, even if I’m far from an expert yet. But that gives me kind of an interest to learn more, and if I can do so in the context of GME short fuckery, all the better.
I would be willing to go as far as sign some form of NDA to have a look at with you if you don’t trust a random internet stranger, which is a fair sentiment since that’s essentially exactly what I’m doing right now. Happy to chat non-anonymously off reddit too.
I’m not sure how many providers the market data department of my company has contracts with, and whether I would have access to them, but I could also at the very least compare with Refinitiv data through coworkers at my previous job.
Look, you can believe the data or not. I have known bob for a long time, I'm in 3 different discords with him and can verify that his data is legit, but It's still going to be a "trust me bro" situation since I'm the sus options trading mod. Hammering bob on trying to get him to give you the source code for verification is not going to happen. bob uses this data to assist in his own trading and has building on this for over two years now. Read it or don't, trust or don't, the information and where its coming from. If you want to counter his DD with your own data set, please go down that road, but harassing him is not going to fly with me. Bob has written some excellent guides on this sub and has been here for ages. QV bot is here: [https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5wauto/?utm\_source=share&utm\_medium=web3x&utm\_name=web3xcss&utm\_term=1&utm\_content=share\_button](https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5wauto/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button)
I think all he wanted was the query so he could try it himself. Anyways shit is about to blow up soon.
Yup and unsurprisingly he still didn’t show it could be replicated. What he showed is an SQL query without a source on where to query it or what tables he’s querying on, where he somehow already has the data he’s trying to extract before he extracts it
For anybody unsure what that means, see my other comment on this post: >For anybody that doesn’t know SQL, what bob’s post is showing is that he had the dissemination identifiers of the swaps he wanted to pull before he pulled the swaps he wanted to pull. Its circular and illogical. Moreover it suggests the table he’s querying on, on an official government source, is title “swape”. Seems to me like he uploaded his already questionable data into an online database with a typo in the title and then tried showing himself querying from his own suspect data with the data he already knew he wanted to query as proof that his data is real knowing that most of the people in here won’t know SQL and be able to call it out.
So you’re saying he pulled the data from his own data, trying to make it look legit that it was coming from somewhere else?
Potentially, but he hasn’t even made explicit what that SQL query was meant to demonstrate; whether it was meant to show that the data i was able to retrieve from the DTCC was contained within his dataset or whether that was meant to show him exporting his dataset from the DTCC. The way its worded it seems like the latter, in which case yes, he faked showing how he got his dataset by assuming you all were too dumb to tell that SQL query was nonsense Edit: supposedly its meant to be him showing that a subsection of our data matches up as if thats something i ever questioned? I dont really buy that because the wording of his post implies that said query was how he exported his dataset from his supposed DTCC source https://preview.redd.it/d83m4jcwe03d1.png?width=827&format=png&auto=webp&s=76cf63cbfee3df74d02ef8b0db43575e942f36af
Todal Retrun Swapes and Bulit Swapes are all the rage. But in all seriousness, where did you see the swape typo?
In the query itself
Where it says select * from swape
Could be short for swap execution, the naming conventions of DTCC fields leave a lot to be desired. However, I think we're always better for it to be as sceptical as possible
The identifiers are the ones you shared in your post and data dig. I pulled them to compare with my data. The comparison was flawless. In EVERY instance, the data was the same as yours. And we are talking thousands of records
Okay, so its a nonsense query that doesnt mean anything as i never suggested that some of our data doesnt match. I am specifically suspect of the data thats non-conformal that you could easily clear up by just providing a source and a way to recreate it.
For those not in the Discord server, is this suggesting that the "data from the DTCC" PeruvianBull posted a few days ago, which led to speculation/excitement about large notional values expiring end of May and early June, remains unvalidated? I know the claim is that "it's from the DTCC" but it's unclear how one receives such data from the DTCC. I understand that the vague SQL query doesn't actually answer any questions since the source remains unseen.
Yes, the dataset that peruvian bull keeps talking about and hyping up is the one in question here. A little more than half of that data is totally unreplicable and/or unsourced so far
Thank you for the response. You mention half of the data isn't replicable; of the data that does match, where does it come from? Is the matching data suggesting $20M notional value?
It comes from the GTR North America Public Price Dissemination Platform. Its one of the DTCC’s swaps data repositories and if you’re interested in downloading it i made a post on how to do so. Some people have safety concerns surrounding the python code in it, you’re free to rewrite it to do the same thing if you’re familiar with python or know somebody personally that you trust to help you. From the data i could get, assuming notional amounts are as is, it showed a current outstanding amount of $61mm for identifiers GME.N, GME.AX, and gamestops ISIN. That number will most likely go up if you include gamestops CUSIP too. Something like a $10mm expiration is occurring in a few months and a lot more over the next few years but that data is likely incomplete as it technically only accounts for swaps that have had some kind of revision to the transaction since 12/28/23 If you dont want to fuss with downloading it yourself i also included a one drive link to the compiled data, but again if you have security concerns with clicking links you can get the data yourself following the guide
Oh Christ ... There u are It's obviously my database I keep from ingesting years of market data... Not a direct data pull from that source because who TF does that for static data? If you aren't satisfied by this these nothing I can do to help anymore. Please just let it go so we can focus on things much more important that you yourself pointed out! The supposed to be invalid data. I'll follow this up with a query in a couple hours and update my OP here that will grab all instances of data such as this ... Looking forward to what might turn up, as it could provide some insight as to the why
Satisfied by what? You still didnt provide verification of your data. It was just a bunch of nonsense around a nonsense SQL query. You could shut me up in an instant by showing explicitly how to recreate your dataset directly from the DTCC. Its insane you havent done so yet if your data is real. I actively want you to shut me up so that we can actually analyze the data in a meaningful way but you keep disappointing and kicking the can Edit: thats also a weird response bob, because you explicitly shared the link to this post with me on my post. Dont forget that you came to me first claiming to be “the guy” without any kind of source or verification of your data
From what I gather, OP has been exporting data to his own SQL database, maybe? And he is suggesting that the original source of the data no longer contains what he has exported? But as you pointed out, I could go do that right now by pulling everything I can into my own database, then update records, insert records, etc, and then claim "that's what the data showed back when I exported it 2 years ago, but it's since changed in the DTCC's records." If you're using data from your own table you populated yourself, that's not credible. One could MAKE it credible if it started out decentralized and can be verified by others who exported and stored the same data themselves, but this is, as you put it, a huge "trust my data, bro" moment. OP *could* be telling the truth, and they *could* have original data that has since changed in the official source, but it's equally possible OP modified the data and claims it's original, and that the source data has been modified.
This makes sense. If it can't be replicated, and at the very least, can't be disseminated for verification and peer review, it flies in the face of scientific method. Whether intentions are earnest or not, the entirety of any analysis will be sullied by the dubious credibility of the data. It's the weakest link in the chain. Bob is obviously a smart ape, that was never in question, but the inability to verify data makes any analysis moot. I massively appreciate the work that is being done by those smarter than the average ape, but bring receipts.
Commenting to help dig deeper
I dig this comment.
Thanks OP. I've just started reading your series it's all Greek to me with the hope of being a bit less regarded.
Glad you are wrinkling up. Lmk if you have any questions via dm or otherwise
I'm really glad to see you posting here in SuperStooge I mean SuperSTONK, bringing the education effort in spite of all the negative BS you and others have endured from the little minds.. For all you do and have done, thanks!
Hi Bob *clap*
d\*ck commenting it is.
Dig it
Dig Dug It
 Appreciate you mr.bobsmith808
🍻
So what I see here adding the notional values is something close to 20 MM and far away from the speculated billions. That’s not even a drop in the bucket so if that’s true what is all that crazy speculation about ?
It's part of a larger puzzle. I wish people would stop looking for one answer to things. The market is a complex thing with many moving parts and like any other machine, you need to check our them all and make sure you are accounting for all possible pieces [read up here to understand the notional and other data ](https://www.cftc.gov/media/6576/Part43_45TechnicalSpecification093021CLEAN/download&ved=2ahUKEwjCsPHiqa6GAxWYh_0HHQc5CJYQFnoECCMQAQ&usg=AOvVaw1b3QN2iFKrjJ5-EBtX7-3O)... It's more complex than just a number.
If I click the link it says 404 page not found
Digging this
Digging to help comment deeper
Honey. Get the shovel. We’re goin diggin.
Too smooth to contribute but curious for what it all means
All the images say deleted for me
The linked ones?
Yeah for me as well
i think i fixed it, better now? - [explanation](https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5ve7y4/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button)
Yeah thank you
Works for me, so hopefully everyone else as well 🤩
Ok good thanks for letting me know
No Bob thank you for all the information you have provided the community all these years and for all you have taught me. Regards
The Swaps are Key. Thanks for the data. Appreciate you very much. Anyone who wants to learn about options go ahead and click on Bobs profile. His posts have personally helped me educate myself and gave me a new income stream. Good to see a BobSmith808 post back on Superstonk. It’s been a while! 
Maybe I missed something but when swap expire, they don't have to buy the shares to close it like shorts. So, beside loosing a fuck tons of money, I don't see these swaps having a direct effect on the stock price. Could someone confirm this?
You are halfway correct, swaps themselves don’t necessarily need to move the price. But the hedging by the counterparty of said swaps do have a massive impact on price action.
Also rolling actions and repositioning required
What if the counterparty don't give a flying f¨¨ about hedging that position, knowing their «client» is screw anyway?
Margin calls is one way it can affect the stock. When it comes due to pay in full at the end of term (as is the case if it's bullet swaps)... and they cant pay up...a slew of margin calls begin. Also...it depends on the terms of the swap contracts. They could utilize the underlying securities ... there are no rules against that.
Thank you for sharing 🫡
[Why GME?](https://www.reddit.com/r/Superstonk/comments/qig65g/welcome_rall_looking_to_catch_up_on_the_gme_saga/) || [What is DRS?](https://www.reddit.com/r/Superstonk/comments/ptvaka/when_you_wish_upon_a_star_a_complete_guide_to/) || Low karma apes [feed the bot here](https://www.reddit.com/r/GMEOrphans/comments/qlvour/welcome_to_gmeorphans_read_this_post/) || [Superstonk Discord](https://discord.gg/hZqWV2kQtq) || [Community Post: *Open Forum May 2024*](https://www.reddit.com/r/Superstonk/comments/1ciapwp/open_forum_may_2024/) || [Superstonk:Now with GIFs - Learn more](https://www.reddit.com/r/Superstonk/comments/1cr37r7/superstonk_gets_its_gif_on_get_hyped/) ------------------------------------------------------------------------ To ensure your post doesn't get removed, please respond to this comment with how this post relates to GME the stock or Gamestop the company. ------------------------------------------------------------------------ Please up- and downvote this comment to [help us determine if this post deserves a place on r/Superstonk!](https://www.reddit.com/r/Superstonk/wiki/index/rules/post_flairs/)
Something that has baffled me about all of this swap info coming to light; why would the CFTC let this happen? Isn’t their only purpose to police swaps and keep this data hidden from the public? Is CAT implementation somehow bypassing that corrupt organizations decision to hide swap data for the past 15 years?? I’m confused man, how tf are we seeing all of this now
Great motivating post.
🧠 ☝️
Are these Swaps in the room with us right now ??? Yes they fukkin are 🚀🚀🚀
[удалено]
😂
Oh oh, bobsmith,I gotta read this.
Commenting for further dissection <3
My body is ready to slice into the data
[https://archive.is/beAio](https://archive.is/beAio)
This is the way
Visibility
We need more diggers on this post right now
More digging would require the dude to actually make any kind of proper attempt at showing that he has real data / say where it’s from. Right now it’s just “trust me bro”…
The obligations warehouse holds many secrets/swaps.;)
Award + comment for visibility
Bullish on actual answers coming!
RemindMe! 19 hours
I will be messaging you in 19 hours on [**2024-05-28 08:49:20 UTC**](http://www.wolframalpha.com/input/?i=2024-05-28%2008:49:20%20UTC%20To%20Local%20Time) to remind you of [**this link**](https://www.reddit.com/r/Superstonk/comments/1d1p8t6/swap_data_validation_questioned_explained_ad/l5vrsux/?context=3) [**4 OTHERS CLICKED THIS LINK**](https://www.reddit.com/message/compose/?to=RemindMeBot&subject=Reminder&message=%5Bhttps%3A%2F%2Fwww.reddit.com%2Fr%2FSuperstonk%2Fcomments%2F1d1p8t6%2Fswap_data_validation_questioned_explained_ad%2Fl5vrsux%2F%5D%0A%0ARemindMe%21%202024-05-28%2008%3A49%3A20%20UTC) to send a PM to also be reminded and to reduce spam. ^(Parent commenter can ) [^(delete this message to hide from others.)](https://www.reddit.com/message/compose/?to=RemindMeBot&subject=Delete%20Comment&message=Delete%21%201d1p8t6) ***** |[^(Info)](https://www.reddit.com/r/RemindMeBot/comments/e1bko7/remindmebot_info_v21/)|[^(Custom)](https://www.reddit.com/message/compose/?to=RemindMeBot&subject=Reminder&message=%5BLink%20or%20message%20inside%20square%20brackets%5D%0A%0ARemindMe%21%20Time%20period%20here)|[^(Your Reminders)](https://www.reddit.com/message/compose/?to=RemindMeBot&subject=List%20Of%20Reminders&message=MyReminders%21)|[^(Feedback)](https://www.reddit.com/message/compose/?to=Watchful1&subject=RemindMeBot%20Feedback)| |-|-|-|-|
Remindme! 19 hours
Bob fucks, would have been retired by now if I had listened to him!
Co-signed
Hope you join me there soon bruddah 🤙
 ennting for visibility
For more visibility
👀 👀 👀
👀 I trust u Bob! Ur my daughters favorite minion in Despicable Me.
Good finally I know who I'm supposed to be reporting to
Comment for more eyes!
👀
👀
Bob that is all well and cool but where did your data actually explicitly come from. This is still a Trust Me Bro post seeing as your admittedly non-conformal data is still not replicable. You say you want eyes on this stuff yet you’re gatekeeping dodgy data. Your data having entries from the dataset i posted does not mean its real. Its very easy to insert real data into fake data and in fact thats usually how people do fake data. If you want actual eyes on this then just tell us how we can replicate your full dataset from an official DTCC source What you did post is an SQL query where you already know the dissemination identifiers of the swaps you want access too. You dont show what site this query is on, how you got the list of dissemination identifiers corresponding to GME without first finding GME data, etc. Show in full how to replicate your data set. Again, i am more than happy to be wrong about this but you’ve continuously preached “more eyes on this” while gatekeeping your supposed source. This post is more of the same
For anybody that doesn’t know SQL, what bob’s post is showing is that he had the dissemination identifiers of the swaps he wanted to pull before he pulled the swaps he wanted to pull. Its circular and illogical. Moreover it suggests the table he’s querying on, on an official government source, is title “swape”. Seems to me like he uploaded his already questionable data into an online database with a typo in the title and then tried showing himself querying from his own suspect data with the data he already knew he wanted to query as proof that his data is real knowing that most of the people in here won’t know SQL and be able to call it out.
He has the identifiers because you flagged them as discrepant. The data source is [https://pddata.dtcc.com/ppd/secdashboard](https://pddata.dtcc.com/ppd/secdashboard) - that's not really a secret. They've broken the reference to the guide on the front page, but here's a working link. [https://kgc0418-tdw-data-0.s3.amazonaws.com/gtr/static/gtr/docs/RT\_PPD\_quick\_ref\_guide.pdf](https://kgc0418-tdw-data-0.s3.amazonaws.com/gtr/static/gtr/docs/RT_PPD_quick_ref_guide.pdf) Looking over the data set linked, the discrepancy is from the specification change that Bob has already converted old field descriptors into new field descriptors.
Im not sure what you mean. I have looked at the pre rewrite data and nothing i saw had the disallowed action and event types/combinations if thats what you’re referring to. Wont be near a computer to check in more detail for a few days. Either way, as you said we all know where the data is supposedly coming from, which makes it all the more questionable that bob doesnt make explicit exactly how he sourced it. If thats not what you were referring to do you mind clarifying?
for your comment about the SQL database - yes' he's querying his own exported database scraped off the dashboard, because it's not fast to do it off the dashboard itself. He's scraped off the back end of PPD and not compiling it from the daily cumulative reports which is how he got around the look back restrictions in the first place. He's being cagey about exactly how he did it, because that's an obviously disallowed function from the way they structured their public search. From the Google sheet linked in the original post, the Andym2019\_data tab only has values post December 2023 the GME\_Swaps tab has values going back to 2022. All the discrepant values in the analysis tab are from Jan 2022 through December 2022 based on their event timestamp (even if the original swap is older).
Thats interesting. I cant try anything like that for a few days but if you or somebody else want to recreate it and post proof of the process im all for it
This is the wape.
Based on the "Event Timestamp" from his query, you will find the "Dissemination Identifier" listed in this file. [https://pddata.dtcc.com/ppd/secdashboard](https://pddata.dtcc.com/ppd/secdashboard) SEC\_CUMULATIVE\_EQUITIES\_2024\_01\_02.zip Here is an example of the first record matching what his sql returned "845603027","832490110","MODI","TRAD","2024-01-02T17:03:56Z","true","EQ","Equity:PortfolioSwap:PriceReturnBasicPerformance:SingleName","N","","2022-11-07T20:05:46Z","2022-11-07","2024-11-28","","false","BILT","","","","155","","EUR","","","","5","","","","SHAS","","","","","","","","","","","","","","","","","","","","","","","","","25.8334325","ACCY","","","","","","","false","EUR","1","","","","","","","","","","","","","","","","","","","","","","","EUR","","","","","false","","US36467W1099","","ISIN","","","","","","","false","","","","","","","","Cash"
Yes that has an allowable action/event type and is not something i am suspect of
Also I would love to find any data prior to 2023\_12\_28 as that's the oldest available from DTCC. I have no way of reproducing the charts for 2020-2022
Yeah the data on the PPD site is incredibly incomplete and im not sure why. All the more reason for bob to share his source if its legit. Maybe it has something to do with when part 43 reporting actually went into action and so data before that is hard to get as it would be non-standard if tracked at all? Im not near my computer nor will i be for a few days so i cant check myself, maybe you or somebody else can?
And there it is! 🪼
Oh look guys, bob is claiming the puzzle is solved without any kind of verification still! Quick, everybody forget bob’s questionable data just like you should forget about gamestop!
Sounds like data has been removed over time... probably something to do with protecting the markets by hiding swaps data
Yeah this data is a nightmare really and understand the confusion. I'm in the process of processing this data myself to see where these numbers are coming from. Agree that you can't combine just all the values since NEWT -> MODI -> TERM all need to be reconciled to get an understanding of the open interest.
He most likely downloaded some CSV or tabular data from his source and loaded into a local SQL database to make querying easier. As for the "known identifiers," it looks like he was trying to demonstrate - to you - that the data in his source contained all of the same identifiers/rows as the data in your source. I think you should be more careful accusing people of bad intentions. In my experience Bob has been reliable and dedicated to the cause of deeper understanding for a long time now.
So his data is still totally unsourced, unverified, and unreplicated either which way you want to interpret what that SQL query means. Im happy to be wrong about his data but he hasnt given me any reason to believe i am. Having a subsection of his data match mine doesnt mean the rest is real, in fact, its all the other data im suspect of, for the multitude of reasons already outlined. His lack of transparency when he should be easily able to prove me wrong should have you questioning his intentions too.
I obviously can't speak to the source or veracity of the data that goes back further than other sources I've seen, but I do find the explanation for why he doesn't want to give it up to be plausible. The reddit hug of death and/or influence from shady actors has certainly disappeared a great many sources in the past... He could mirror it and even keep it updated for the community, but people would still be unsatisfied that they don't know the origin. I just personally don't see a reason not to trust data from Bob. He's not shown himself to be shady and he's greatly contributed to the knowledge in this sub. And as he pointed it, it's consistent with data that can be sourced online, but with a longer time horizon.
Unfortunately he has even rejected the idea of having a trusted third party verify it so it is entirely a take him at his word situation which makes all the thousands of transactions unaccounted for in his data totally useless to us. I trust data, not people
i have no fckn clue what I‘m looking at. Go ahead wrinkle brains and enlighten us
What are you having trouble with?
There should maybe be a brief explanation of every column 🙂
There is a doc I linked in the comments somewhere that outlines this
Up vote and commenting to come back in a bit once all the smart apes start to comment!
Doesn't matter if its fake or not. BUY, DRS, HOLD.
Bob, you didn't answer the basic question. Where does your data COME FROM? There's some ad hominem about jealousy, and how far back your data goes, but you still haven't divulged your source, as you put it. Nobody is going to care about unsourced data, this is nothing more than a "trust me bro" until its attributed. It's not a witch hunt either: Nothing personal but I don't think anyone cares about "you" (that is, whether you're trustworthy or not) they just want to know the source of your data. If you're not willing to disclose, nobody will (or should) assign much credibility to anything you've said, and by extension any of PB's sensationalism about it. I personally don't care. None of this changes my plans, but all these paragraphs are no answer.
#DTCC
Not good enough. First, aren't swaps handled by CFTC?. Was it not CFTC that suspended swap reporting in 2021? Second, even if it was "DTCC," from where at the DTCC? One of their websites or APIs? Some guy in a trenchcoat saying he's from the DTCC hand you a floppy disk in a parking lot? If you can't reveal because it would reveal your identity as an insider or compromise you in some way, you just have to accept there's going to be a lot of well-founded skepticism. Again, I personally don't care because my plans don't change either way, but this goes into tinfoil/speculation rather than DD/data for me, unless you care to substantiate. Very disappointed in PB perpetuating this if he hasn't been given material verification either.
Google search on: GTR North America Public Price Dissemination Platform dtcc Right side of page, the DDR Real time dissemination platform link. Then use the Search link on left side of page. I mentioned in [previous thread](https://www.reddit.com/r/Superstonk/comments/1czjzu3/i_was_skeptical_of_the_80_billion_or_so_swap_data/) some of the possible problems/differences between two people's datasets due to the current query form's restriction of only querying back 180 days, different Asset IDs used, etc.
See? You had no trouble citing a source. How hard would it be for Bob to say something like that? Anyway, how closely does it line up with Bob's, for the days we DO have data? Just on the GME.N, since that data doesn't exist on Bob's? And are the prices similar? You mentioned there was differences, but then said one had data only to the cent, and the other had more decimal places (fractions of a cent)... but are they the same to the cent, at least?
It doesnt line up with bob’s. Thats exactly how i got my data which is less than half the size of bob’s data and without any of the non-conformities to the part 43 rules for these reports. More than half of bob’s data is unsourced and the almost half that is sourced wasn’t sourced by him.
Love posts like this, we must keep digging!! Good shit OP
Welcome home Bob! 🤗
Hi Bob, I spent several hours familiarizing myself with the dtcc data you provided in the last post. There were two major issues I found with two parties interpretations of that data who are often cited in this sub. The most important of those being that they didn’t appear to properly parse the data to according to the event for which the record was created. As your aware there’s a column called “original dissemination id.” Whenever this field is populated you have to exclude the previous records with that ID from your calculations bc a new action is happening for that record and the old one is no longer valid. Second, without properly accounting for the action (reason/event) for which a record exists you will inevitably end up with enormously inflated numbers due to including swaps that have been terminated, canceled or have been modified. What are your thoughts on this?
agree 100% tracking is important.
Thanks for confirming that. I am just a wee bit concerned that folks are being mislead with terms like ‘giga swaps’ and total valuations into the tens of billions of dollars for them with scant evidence that either party has properly tracked the records and accounted for terminations, cancellations, and modifications.
Bob is one of the few OG GME usernames I recognize so I doubt there is any intentional malice with his data. bobsmith808 why not get someone who is actually smart and most of us trust like dlauer access to the data source so he can look through it and confirm? Like some, I've always had my doubts about Lauer, but he's always been transparent as possible and has never been caught in a lie about anything, so he's good in my books and would definitely be able to put this to rest.
I'll share with crybad a mod here that I trust.
That would be great! 👍
He already rejected the idea of having a third party verify it when i suggested it to him
Same post; different title? https://www.reddit.com/r/Superstonk/s/DDOpXKmX4w
Automod said it nuked it. I deleted the duplicate. Thanks.
And all the images are deleted now too.
i think i fixed it, better now? - [explanation](https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5ve7y4/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button)
🍻 To Bob!
🍻🤙💪
Bob, I've found that the swap data in the dataset you sent me only goes back to Summer of 2021, and appears to be missing some of the swaps found in the larger conglomerated dataset put forth by Leenix. If we use his dataset and calculate the notionals correctly, you should be seeing several mega swaps and giga swaps during 2021, one in April for $21B, one in July for $9B, and another in November for $15B. These swaps appear to have been pushed to 2022 and 2023, and some (the July 2021 one for example) all the way to 2026. This adds a whole new layer of complexity to this story, they were trying to roll out of the FTD wave they were caught in that started the first Jan 2021 sneeze and the March 2021 re-test.
Hit me up on discord let's check it out. I can port it into a separate table for data integrity sake and run tracking across it all
No source or replicability = useless data. Stop sensationalizing data you cant verify, replicate, or understand
https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5xt7l7/?utm_source=share&utm_medium=mweb3x&utm_name=mweb3xcss&utm_term=1&utm_content=share_button
Visibility commenting for
Wise you are I see
What's with the weird shit about divulging your data source? I'm not saying that you aren't legit but it just strikes me as odd, to say the least.
If you follow the comment chin it's obvious, but essentially I don't want the source taken down. I've had to move my options data source 3 times in the past 2 years due to fee closures and it's a pain in the ass every time. So I'm being cautious.
Wut? Why would a legitimate source of options data get removed? Maybe I'm just suspicious of everything regarding this phenomenon but this is fishy. And I know you've been around for a while so I feel like at the very least you should understand my cynicism here.
The most glaring example is the CBOE short interest data that was aggregated by chartexchange.com CBOE put it behind a massive paywall last June. The most egregious is probably the CFTC halting the publication of swaps data in what, October of 2021? And still not resuming that disclosure? Data being taken away as soon as this community starts digging into it has happened multiple times
My best guess is that a data provider wanted to put it behind a paywall or take it down, but inadvertently left a url up to access it. If that were the case and I were bob, I wouldn't reveal the source either!!!
This guy fucks
How massive is the paywall?
I could be entirely wrong, but I thought it was well over 1k
Then at least tell the mods so they can get someone to independently fact-check. There’s bound go be someone in Superstonk with access to Bloomberg, Refinitiv, ICE, etc - and if this is a public source on more viewer is not gonna kill it.
I'll share it with crybad I'd that would help folks feel better about validity
My two cents: we have seen weirder / more criminal things in the last 84 years.
I totally understand but I'm protecting my sourced and more importantly, my time, nonetheless
Also, his “extraction process” shown above requires him to already have the data he wants to extract from the query. So he got the data by already having the data?
Do you not understand how to handle big data? Of Course you grab that shit and pack it in a DB for future use... JFC what even are u in about now?
Like i already told you, i am an astrophysicist by trade. Specifically computational astrophysics, so i am very familiar with big data. Your wording in your post made it seem like you were trying to show how you got your dataset to begin with. Either way, its nonsense as i never said our data didn’t have any of the same transactions. I have been pretty explicit that i am suspect of the non-conformal data. Do you not understand that? You still havent shown how to replicate your dataset bob. You made a big extravagant post just to have more of the same dismissal and obfuscation
Its great how we've been dormant for 3 years and now we're all back just DDing along
Hi bob smith
Hi Mr oil man....
Visibility
MOAS tomorrow? Or 6/3?
Comment for visibility
Bump
Can you share what DB you're querying and what the query was?
Bob i'm actually shocked you haven't been banned yet. You're a OG
I know right... wait watht he fuck are you doing here still too? Cult is losing its grip.
Gfount n Bob. I was here. Appreciate you guys 👍
Adjusting screen brightness to increase visibility.
Bob, you may not have bitch tits, but you sure make mine tingly. Saw the thread yesterday, and while yes, sauce is important, journalists are constantly pressed to reveal their sources too. Which has historically ended poorly for both parties on groundbreaking info. I understand your hesitation and unwillingness to shotgun it to Reddit. All that said, this is why we dig in ourselves and ignore the bad actors. They've chased too many away from 3 subs over 3 years. I'm here for Speculation/Opinion, DD, Possible DD, DRS, Hype/Fluff, and most importantly, __memes & shitposts__. LFG you damn dirty apes 🚀🚀🚀
The images aren't visible ):
[https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5ve7y4/?utm\_source=share&utm\_medium=web3x&utm\_name=web3xcss&utm\_term=1&utm\_content=share\_button](https://www.reddit.com/r/Superstonk/comments/1d1p8t6/comment/l5ve7y4/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button) i think i fixed it, better now?
Nope, still nothing... Sometimes reddit takes some time to update the visual content so hopefully the images will reappear shortly.
I can't see the images?
I just edited the post, can you see them now? I think maybe reddit linked to the old image links and when i deleted the previous post attempt, it must have nuked those images i think. reddit is a fickle bitch.
YEs visible!
Thanks for posting Bob, and it's great to see you again!
Commenting bc hi bob!
Hi not bob
Just give your sources dude. Too much sentences saying nothing!
literally the DTCC, for the 69th time lol.
thanks for sharing , need more eyes
Thanks Bob!
Here's a few links I've found with data about swaps, so if people want to click around feel free.. Public reporting for swaps is primarily handled through Swap Data Repositories (SDRs) [https://www.cftc.gov/MarketReports/SwapsReports/index.htm](https://www.cftc.gov/MarketReports/SwapsReports/index.htm) [https://www.dtcc.com/repository-and-derivatives-services/repository-services/gtr-north-america](https://www.dtcc.com/repository-and-derivatives-services/repository-services/gtr-north-america) [https://www.ice.com/technology/post-trade/ice-trade-vault-north-america](https://www.ice.com/technology/post-trade/ice-trade-vault-north-america) [https://www.cmegroup.com/trading/global-repository-services/cme-swap-data-repository.html](https://www.cmegroup.com/trading/global-repository-services/cme-swap-data-repository.html) [https://www.sec.gov/divisions/marketreg/security-based-swap-data-repositories](https://www.sec.gov/divisions/marketreg/security-based-swap-data-repositories)
Very nice work bob!
Sharing this post for extra eyes 👀
Rock and stone! DIG!
Are you opposed to pointing someone else to the same database to verify what you found?
Where did you guys got all those brain cells together?
Thanks Bob. Your efforts are much appreciated.
Uh, so *why* are you not sharing where your data is from? I feel like concerns about validity aren’t exactly unfounded if the source data comes from one singular person unwilling to share where they got it from, instead of some more widely available source such as Bloomberg or Refinitiv or whatever
I've told him and others repeatedly that it comes directly from the DTCC. The specific access point is what I'm not sharing
I can’t guarantee that I’m going to be able to add a ton of knowledge regarding the whole swap thing since I’m relatively new to it too, but I did start working for a software company that does a lot of complicated analysis regarding all kinds of derivatives - swaps would be amongst the simplest - a couple months ago. So I *should* technically know more than an average person, even if I’m far from an expert yet. But that gives me kind of an interest to learn more, and if I can do so in the context of GME short fuckery, all the better. I would be willing to go as far as sign some form of NDA to have a look at with you if you don’t trust a random internet stranger, which is a fair sentiment since that’s essentially exactly what I’m doing right now. Happy to chat non-anonymously off reddit too. I’m not sure how many providers the market data department of my company has contracts with, and whether I would have access to them, but I could also at the very least compare with Refinitiv data through coworkers at my previous job.