#InternLife #DataAnalysis #Python #API
Hey fellow interns,
So, I may have just hit Bloomberg’s API monthly limit on the first day of my last month as an intern…oops. 🙃 Here’s my little tale of woe:
– I was working on a project that required a massive amount of historical data
– I ran my code with the bigger dataset, and BAM! Hit the limit
– Now I can’t use BQL, excel add-ons, or python packages for data pulls
– And there’s still two more data-heavy projects to tackle before my internship ends
But fear not, my friends! Here’s a possible solution to avoid my fate:
– Consider breaking up your data pulls into smaller batches to avoid hitting API limits
– Check and double-check your code against smaller datasets before going big
– Utilize tools like W
Lesson learned the hard way, but hey, at least I’ve got some quality time with excel in my future. Stay strong, fellow interns! 💪 Let’s conquer those projects together!
Tell your boss and get it straightened out sooner rather than later. They may be impressed lol
But better to own up as soon as possible.
Not a big deal at all. Speak with a Bloomberg help desk associate and ask if they can reset your limit. They should be able to help you out, and may not even need authorization from your boss. It’s probably best to loop your boss in, though, since you’ll be working with a few more large datasets during your time there.
Source: have a terminal, have routinely hit API limits when working on larger projects
Not a big deal at all. You guys are on free trials for your internships, and honestly if you’ve found something that works your boss may be extremely impressed. They’ll reset your limit, your firm (if it’s a large BB) pays these guys so much per month it’ll make your head explode.
Bloomberg reps will lift the limit if you ask
I did the same thing as you in may, contacted Bloomberg and they told me to go f*** myself, had to wait for the next month
Just call bbg and answer a few questions and they’ll lift it
There are some financial databases that are staggeringly expensive. Get an idea of which ones those are for your group and how they are charged (e.g. some searches and downloads are free or inexpensive). Some databases have (fantastic) help desks that can help you with queries (even do some of your work) and help if you are worried about excess data.
If you accidentally download too much data, you (or someone else) can call the data provider and they may choose to cancel the charges. Do NOT wait.
Some professors at universities would stick around late the “last” day of the month and blow through all the Bloomberg monthly data in a few minutes. That was a headscratcher for reasons I won’t go into.
EDIT – I will add the data in these systems is not particularly reliable. Bloomberg probably is among the better sources, depending on screen. If you have mission critical information or a live deal, you really need to go to the source.
LOL… you’re fine, I’d probably be impressed as your boss. At least you’re hitting the database.
Definitely call and ask for relief. Then be open with your bosses.
If you’re working on anything useful the cost of some data is peanuts.
*Uses BQL once*
1. It isn’t a big deal
2. Bbg can increase limits
3. If our intern hit the limit, their code wasn’t efficient enough dealing with real world constraints, sorry.
This is not that big of a deal. Just live chat bloomberg rep and say you accidentally hit the limit. They will reset the limit and probably ask what you were trying to accomplish and help you with it.
Don’t sweat it bro, shows you’re doing some big shit (what is Python anyways? is that child-size version of C++?).
One idea: zoom out a bit (if possible) on the data. Daily instead of tick data, weekly or monthly data.
I mean, at the end of the day it’s all linear regression anyways (fuck you PCA), so Excel can crunch through that monthly data.
Lol i think this happens to most interns who play around with too many BDH calls on a excel sheet. Bloomberg did not increase my limit on the intern license, but we had a spare professional license when a associate left that got transferred to me. Until i got that i just kept asking the other interns to refresh the sheets for me on a common drive folder, and used factset.