Day Trading Charts - The best free candlestick charts ...

First and foremost I would like to thank u/Naughty_Funkle_1992 & u/089jonas for their posts listed below:

https://www.reddit.com/Superstonk/comments/yjexhh/big_numbers_leaked_arechegos_basket_swaps/
https://www.reddit.com/Superstonk/comments/yi9b27/found_this_in_a_whistleblower_document_attached/

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)
https://docs.google.com/spreadsheets/d/e/2PACX-1vQRPJHxuuUxDt3cq7jtaKq3vTOtzYibSrBMfNsQ_OSyo6sZNC9ILR4oc5HITi9nQj9supfF4oHQBa1G/pubhtml

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.

Findings:

We now know that Archegos liked bullet swaps, as bullet swaps are entered into at current value and "in which the notional value is constant throughout the life of the swap. In this type of swap no regular cash flows take place... Instead, parties to the swap agree to make a single payment at maturity date."
The notional value of the basket swaps (only) Archego entered into between 11/02/202 and 03/23/2020 was between $32.9B & $33.4B
There were six swap counterparites (SC) to the basket swaps with the following notional values
- SC1 - $7.1B
- SC3 - $4.4B
- SC4 - $2.2B
- SC5 - $10.4B
- SC6 - $9.0B
- SC8 - $0.2B
- Total - $33.4B
There were nine total baskets swaps with the six counterparties:
- SC1 Basket 1 - $7.1B
- SC3 Basket 1 - $0.7B
- SC3 Basket 2 - $3.7B
- SC4 Basket 1 - $2.2B
- SC5 Basket 1 - $1.0B
- SC5 Basket 2 - $9.4B
- SC6 Basket 1 - $0.7B
- SC6 Basket 2 - $8.3B
- SC8 Basket 1 - $0.2B
- Total - $33.4B

Next, I used hypotheticals to extract potential based on percentages of the swaps. For instance, I used scenarios where GME comprised 25%, 50%, 75%, and 100% of the total swaps to obtain the possible amount total shares that were apart of the Nominal short. In order to do that, I used the closing price of each day that the swaps were entered into to obtain the possible number of shares in each swap for each day. You can see that in column I-L in my google sheet file (link near top of post). Doing that I was able to obtain the following hypotheticals:

Table 1
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:

Table 2
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
LFG!

Cheers.

Anyone know where to get free forex data everyday that I could put into excel? I need someway I can automate. I only really need daily OHLC.

How used is Microsoft Excel when it comes to Data Analytics, I am studying Excel and was thinking what makes a person intermediate with excel, then I also wondered that if I study excel would it be beneficial in my journey of becoming a Data Analyst and working my way up to become Data Scientist.
I honestly would like to study SQL for my next part so I can move my way closer to learning Python again.
Edit:
Thank you, everyone, for such great pointers and insights while I am on this journey to becoming Data Analysts and working my way to become a Data Scientist
They said to enjoy the journey and not the end goal and the journey is amazing thank you everyone

I've been playing around with QC recently and it seems like either I don't know what I'm doing or the data is hard to validate. I'm simply running algo over a short 2 year period and cross checking orders my algo is generating against charts on tradingview and the candle times are just different (diff close time, diff dates etc). It's so hard to get consistent data to validate whether the orders generated are matching the criteria I intended it to use. Is there a way to draw charts in QC similar to tradingview's chart style? I've looked into it and the charting seems quite basic.
Alternatively is it worth learning Pinescript and operating off Tradingview, or MQL4/5 in Metatrader and operating directly off those platforms with the data that the brokers provide?
It'll mean I need to learn how to code in those languages but at least I know the data will be good which gives me confidence to use a small amount of money as opposed to using QC now I have zero confidence in the data being accurate.

Hi I have an excel file (.xlsb)with +million rows, it’s took a long time (5 min)to read it in python, any helpful ways plz to make it faster?

I'm looking to buy G10 high quality intraday FOREX data. 5 minute OHLC would be perfect. Please recommend a vendor. Thanks

The first thing that comes to my mind are keyboard shortcuts to make navigating quicker, but what else should come with an Excel “refresher” lesson?
Any tips/tricks specific to a data entry position?
What comes to my mind:
Shift + Space bar / Ctrl + Space bar
Ctrl + Shift + (+) to insert
F2
Alt + Tab / Alt + Windows + Arrows
Paste values only shortcut
Number formatting shortcuts
Ctrl + Shift + arrows
Format painteF4
Ctrl + Shift + L
Filters / sorting to make edits and find typos.
What else would be valuable for a data entry position?
Also curious, what would you price this service at?
Thanks for any help.

I’m currently working as a Data Analyst where I work predominantly in R, with a bit of SQL and Excel from time to time. I’d say I’m fairly good at coding in R, but I do still need to look things up from time to time (like syntax for different functions). Because of this I’d say I’m not a “natural” at programming. I also don’t really use things like GitHub very often, and my code is typically more of a “what gets the job done”, as opposed to “what does the job best”.
My background is in Physics, so not directly computer science or data science. This also means that my mathematics is also quite strong but I’m by no means a statistician. But overall I do have plenty of experience in working with data.
Just wondering if I’ve got the skill set (or at least the foundations) to be a successful data scientist?

The Fazzaco Expo Interviews goes inside the fintech industry, especially the forex brokerage business, with executives from top companies and startups showing excellence in performance, to explore the keys to success in the market.
The Dubai 2022 series contains 30+ exclusive interviews with companies including AximTrade, AUSFOREX, B2Broker - Liquidity & Technology Provider, GTC Global Trade Capital Ltd and more.
Click the link below to view more.
https://www.fazzaco.com/features/fazzacoexpointerviews-seriesdubai2022
NCM Investment ACY Securities YaMarkets ICM.com Brokeree Solutions Leverate PU Prime FP Markets (First Prudential Markets) IXO PRIME FxPro INFINOX Capital Alpari OneRoyal Mohicans Markets Zenfinex Traders Trust marketwinner QFIL Solutions Fair Trading Technology
Wonderinterest Trading ltd Noor Capital M4Markets
#expertinsights #FazzacoExpo #FazzacoExpoDubai2022 #Executives #B2BEvent #Networking #Business #Forex #Finance #Fintech #B2BMarketing #Exhibitions #EventMarketing #OfflineEvent #Marketing #Fazzaco #Dubai #fx #forexbroker #news

I want to insert data from one database to another. But i can't use insert into select statement as I am not allowed to do that. I have to insert it manually. So to do that i copied data from the first database pasted into an Excel sheet and added a comma so i can insert them into the other database but unfortunately the dates get formatted into numbers while I'm adding a comma. Is there anything I can do?

Hi I have an excel file (.xlsb)with +million rows, it’s took a long time (5 min)to read it in python, any helpful ways plz to make it faster?

Day Trading Charts - The best free candlestick charts ...

#shorts #binomo #forex #binance #gateio #btc #kriptopara #coin #shibainu #trader #trading

Shorts R so Fuk. I'm highly regarded in my field. I'm an accountant and I took the time to break down the Archegos swap data for everyone, and put it into Excel for everyone to see. Come on in to get some analysis of the data.

Forex Risk Management Excel Sheet

Free Forex Risk Management Excel Sheet

Easy way of copying web data to excel.

If you have used LoopDropSharp then you will love Maize. Improved error handling, faster performance, intuitive interface, and yes, all data is logged to a csv file to use in notepad or excel.

How to get forex data into excel.

Despite his size, Bryce Young has excellent (A++ but not S-Tier) arm talent. I roughly measured this difficult throw from the far NCAA hash at ~60.44mph. The Average speed at the NFL Combine is 54mph. Tua has a 53.5mph arm. Watson 54. Burrow 56. Wentz 59. Mahomes 61. Allen 63. (data source inside)

How would you enter this data into excel so it’s easier to analyze?

Excel for Data Analytics ?

(UPDATE 1) Votes are in and 166** messages have been sent. All data is being recorded into Excel and I will post responses and updates as they come

Changing platforms for better Forex data? (QC, Tradingview, MetaTrader)

Big data in excel file

G10 FOREX Intraday Data - Vendor Recommendations Please!

I’ve been hired to provide an Excel “refresher” tutoring session(s) for a data entry position. What are some good things to cover?

Do you need to be an “excellent” programmer to have a successful career as a data scientist?

The Fazzaco Expo Interviews goes inside the fintech industry, especially the forex brokerage business, with executives from top companies and startups showing excellence in performance, to explore the keys to success in the market.

Un organisme d'autoréglementation du Forex russe va vérifier FINAM Forex et VTB Forex en 2020

Noob Question of the day: So I'm have bakkesmod & ballchasing. Looking for a way see quantitative data for improvement over games. I have exported the data from a Excel sheet and made graph but this seems like too much work. Looking for the best method from the GCs and SSLs. Winner gets 300 coins!

Data Analytics using Excel

Copy SQL server data into excel

Big data in excel file

Trading tanpa candle dan indikator by 352 Signal4G