Commodity Trading - Coding language to analyze SnD
Hi all, I was wondering which coding language are you using to compare/analyze/ visualize SnD ? I’m loosing a precious time entering different data in excel and I’m pretty sure there are better ways to do it by scrapping informations from website/emails/ PDF automatically. I’m pretty much a newbie so if you have any ideas/resources that I can use to level up or real life examples on how you are using your coding skills to be more efficient It would be amazing. Cheers!
Python. Anyone who asks coding questions in this thread the answer is always python
Python is huge. I’m a rarer breed among my coworkers but I actually use R just as much if not more often than Python (tbh I’m pretty sure I use R more)
But it also might have smt to do with econometric background so the conclusion is both are good.
Citadel uses python
Always python
.
I use F#/C#
Can anyone share how a python based SnD is built or resources about this? Like beyond just replicating the excel SnD in python, how does python make it better? More focused on improved analysis rather than automation of processes.
I’d be interested too
The capability to work with much larger datasets and do calculations quicker. If I wanted to perform linear regression using a new dataset in excel, I would have to pull the data into excel, fit the cells so they are aligned perfectly with the rest of my data, which can take hours itself, and then hit about 5 or 6 hotkeys to perform a single regression and have it outputted in a clumsy way. In python, if I’ve designed the model well, every aspect of this is performed with the click of one button and the new data can be applied to an endless amounts of calculations.
Excel is designed for financial statement analysis, simple tables, and simple math. Python is a better tool for every type of analysis aside from accounting, and the only thing preventing it from ubiquity is boomers don’t know how to use it.
Thank you for the reply. I can see what you mean about being able to run more robust analysis, more quickly vs Excel.
Any tips on resources you found helpful to learn this. I am a competent programmer but definitely having difficulty converting to useful applications on the trading desk. Specifically I'm not sure how to approach system design and model building. You talk about a well designed model and that's where my knowledge is less clear.
It’s a matter of totally different tool. A handheld calculator is not the same as excel. And excel is not the same as python. If python were just for automating excel, that would be a huge under utilization.
The use cases for the additional capabilities in commodities are many. Everything from visiting websites and downloading data on web trawlers to writing to a database to applying machine learning algorithms beyond linear regression to performing complex data manipulation functions on millions of records at a time.
A velit dolorem aperiam ducimus voluptas veniam. Natus debitis debitis sed ipsam vel. Numquam dignissimos doloribus et tempore temporibus dicta sit natus. Minima reiciendis quisquam quia occaecati rem. Aperiam nemo sit nulla. Vero cupiditate distinctio enim sint magni cupiditate.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...