submitted by Nat9523 to PowerBI [link] [comments]
|submitted by WeekendWarrior0187 to dataisbeautiful [link] [comments]|
|submitted by crytoloover to coinmarketbag [link] [comments]|
|submitted by zjd0114 to PowerBI [link] [comments]|
|submitted by fxmyworld to u/fxmyworld [link] [comments]|
First and foremost I would like to thank u/Naughty_Funkle_1992 & u/089jonas for their posts listed below:submitted by travis_b13 to Superstonk [link] [comments]
I decided to dive into the data that was listed in the lawsuit/comments, and boy of boy. It lists quite the information. I am also making the data public for everyone to see, and it can be found here:
EDIT: WARNING!!! It has come to my attention that clicking on a Google dock can be tracked back to your google account if you are signed in (potentially doxing you). Click the next link at your own risk.
EDIT 2: I edited the link to be a published link. It appears to be safer, but it can't be copied. I will gladly send anyone the link to the google sheets upon request (in case they want to copy the data)
Disclaimer: I am highly regarded, and I believe blue crayons taste the best, so take this as you want it.
Alright, Let's go.
I first input all the data form the two posts listed above into an Excel workbook. As an accountant, I thought it would be best to reconcile the two together to find any discrepancies between the numbers. The first thing I noticed is the Nominal value of the swaps did not add up perfectly between the two posts. However, since the post that has all they day by u/Naughty_Funkle_1992 had the Swaps broken down by Swap Counterparty and by the baskets, I decided to lean on that data a little more. For full disclosure the difference in the total Nominal value between the two posts was/is $525M (or about 1%), so both data sets are good enough to work with.
Remember this is a hypothetical. There could have been ten to twenty stocks in those swaps, so let's try to find more reasonable numbers:
These appear somewhat more realistic, but again, we don't know what we don't know, and what we don't know is what comprised of those swaps. These are just hypothetical based on the data that we currently have.
We can dive deeper though. We know that there are several counterparties to the swaps (at least six for these basket swaps), and we also know that these numbers only refer to Archegos. They do not contain the data for our friendly-neighborhood criminal Kenneth Griffin (who lied under oath to Congress, everyone) and Citadel, Virtu, State Street, etc. But what we do know is Credit Suisse seems to be on the hook for a lot of these swaps, so I'm assuming they are SC5 and/or SC6 from above.
Diving deeper, we can extract the current nominal value of the swaps based on today's closing price. We can do that by taking the share count from above and multiplying by today's closing price of $26.64.
Nominal value of swaps
Let's have some fun and see the bigger percentages of the swaps. I give you:
Nominal value of higher hypothetical percentages
So if all the basket swaps (which probably vary from basket to basket by the way) all had 5% of GME, the nominal value today is $3.5B, but if they had 25% that nominal value would be $17B. It may not sound like a huge number in the grand scheme of things, but remember that retail has locked up $2.35B (as of today's closing price of $26.64 (which would be $3B if the price was closer to $34)). Also, this number is actually really high when considering that GME's market cap is only $8.1B today.
Furthermore, this is only Archegos's swaps and doesn't include any data into swaps by Citadel, Virtu, State Street, etc., and Archegos is a drop in the bucket compared to how big those firms are. So even if Archegos was their size and they all were fairly equally short and if we only use the 5% from above and multiply it by 4 to include the three other firms just mentioned.... drum roll.... $14B minimal in swaps holding GME (almost twice the current market cap).
Conclusion: There is definitely more data that can be extracted from what I have put together, but I only did what I could in a short amount of time, as I'm supposed to be working; however, I thought it was important to point out some data that I put together and share it with everyone. I also believe that this post right here is why the CFTC won't release swap data and isn't making anyone report swaps until 2025. It's because there are apes out there like me that love data and can decipher it down very quickly and methodically.
In short, GME is definitely going to moon, and short r fuk, hedgies r fuk, and we moon soon.
Power to the Players
Hello,submitted by bjean07 to u/bjean07 [link] [comments]
This is a spreadsheet I made to easily keep track of my investments. I've decided to share it for free as a give back to the community.
𝐇𝐨𝐰 𝐢𝐭 𝐰𝐨𝐫𝐤𝐬 (𝐆𝐮𝐢𝐝𝐞 𝐢𝐧𝐜𝐥𝐮𝐝𝐞𝐝)
(w/Automatic calculation unless stated otherwise)
✦ Desired Portfolio (Manual Input)
✦ Tickers Info (Manual Input)
✦ Crypto and NFT Portfolios
✦ Transactions/Trades/Dividends History (Manual Input)
✦ Annual Reports
✦ Watchlist (Manual Input)
✦ Customization and Info
|submitted by AreaOfSquare to Daytrading [link] [comments]|
|submitted by binomotraders to u/binomotraders [link] [comments]|
|submitted by AreaOfSquare to Forexstrategy [link] [comments]|
|submitted by aezro to Damnthatsinteresting [link] [comments]|
|submitted by jacob-huber to loopringorg [link] [comments]|
|submitted by FineSkinLeather to Texans [link] [comments]|
|submitted by lil_yungdrip to dataanalysis [link] [comments]|
|submitted by Top_Location to CitadelLLC [link] [comments]|
Try our award-winning platform for free with a free forex demo account. Start developing your trading skills with IG. Practice trading with $10,000 virtual funds . Experiment with trading ideas risk-free. Test strategies on the go with our free mobile apps. Open a demo trading account. Try our award-winning platform * for free and develop your FX trading skills. Country of residence. I’d ... FOREX.com is a registered FCM and RFED with the CFTC and member of the National Futures Association (NFA # 0339826). Forex trading involves significant risk of loss and is not suitable for all investors. Full Disclosure. Spot Gold and Silver contracts are not subject to regulation under the U.S. Commodity Exchange Act. *Increasing leverage ... List of the best free, or 'no registration', day trading demo accounts and trading simulators with reviews. From Forex to spread betting, demo accounts offer a great way to learn, or practise trading with a platform or broker. Este tutorial introduz binomial opção de preços e oferece uma planilha Excel para Em cada fase, o preço das ações move-se por um fator u ou para baixo por um fator d. O primeiro passo nas opções de preços usando um modelo binomial é criar uma estrutura, ou árvore, S0: O preço das ações hoje. P: A probabilidade de um aumento de preços. U: O fator Por mais do segundo período, se ... Useful for all markets (forex, commodities, stocks, indices and others) and timeframes ; Compatibility: MetaTrader 4 ; Monthly updated for free ; How to trade with the Pivot Point Extra Indicator profitably: The Pivot Point Extra Indicator is based on a special mathematical algorithm that can predict future reversals of any market with a high probability. Our Pivot Point indicator is extremely ... forex trading yoga. forex currency rates live in pakistan Broker forex png Forex Yang Aman Di Indonesia forex market open and close Forex Brokers Forex Brokers fx impact india price. forex futures historical data. 7 forex micro account pip value Broker Forex Terbaik Dan Terpercaya forex gurukul Untuk Trader forex ea robot free Indonesia 2019 . forex trading courses for beginners. Trading Forex ... Real-Time Data Feed. To work with this supplier quotations, you will need to open a demo or live account for API trading. To do this, you must fill out a form on the website of any broker, working with Rithmic. The demo account will be opened after 5 minutes. Username and password will be sent to your e-mail. With the opening of a real account ...
[index]          
http://www.myforexdashboard.com Powerful software tool to analyze your Forex trading results, learn from them, improve your trading and increase your Profit ... The simple video tutorial will show you how to import live currency data from the web into your excel spread sheet. I will also show you how to get this data... Learn about our new offering in API trading. Use excel to monitor feeds, order, and positions in real time. Also, build your own strategies in excel using re... MS Excel - Import Live Data From Web Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Pavan Lalwani Tutorials Po... Real time forex rates in Excel form True FX. Very fast and easy. Includes real time bid and offer quotes from selected brokers. Please check the newest video... To open a FREE trading and Demat account with FYERS click the link below http://partners.fyers.in/AP0151 http://upstox.com/open-account/?f=R0DP (OPEN ACCOUNT... Import Stock Market Data to Excel using the Import from Web option in Excel. Steps to Import Stock market data in Excel are 1 - Go to Data Tab in Excel 2 - S... Real time financial data in Excel from Yahoo Finance and several other providers. You can install the Deriscope addin and use it for free for one week by dow... Demonstrates asynchronous acquisition of real time forex rates in Excel from TrueFX. Included are bid and offer quotes on the most important currency pairs. ... Learn how to manipulate live streaming data with excel in addition to placing orders directly from the excel spreadsheet. All of this can be done in R Trader Pro.