Serving the Quantitative Finance Community

 
Moneyweaver
Topic Author
Posts: 2
Joined: January 18th, 2019, 12:07 am

Local securities database

January 18th, 2019, 11:49 am

How do quants/analysts who work in funds/investment firms access large scale historical securities data sets when undertaking their own exploratory investigations/research. Do they use local (ie servers/workstations) databases for their own research? Or do they use bloomberg et al to download data into a funds securities master database and process the data there? If they want to update/ scan/ compare/ clean/ transform/ process corporate actions etc on large scale securities data sets for their own individual research/project needs where would they generally do this?
Last edited by Moneyweaver on January 18th, 2019, 5:04 pm, edited 1 time in total.
 
User avatar
bearish
Posts: 5186
Joined: February 3rd, 2011, 2:19 pm

Re: Local securities database

January 18th, 2019, 2:11 pm

You beg, borrow and try not to steal. Downloading BBG data into a database can be prohibitively expensive if you do it the correct way. Now, if you are a licensed terminal user you can, in principle, download all the data you want to your own workstation and analyze it there. YieldBook, Lehman Live (sorry, Lehman dead, Barclays Live), morganmarkets, CitiVelocity, etc. are also common sources, but all require permissioning, usually via your sales coverage.
 
Moneyweaver
Topic Author
Posts: 2
Joined: January 18th, 2019, 12:07 am

Re: Local securities database

January 18th, 2019, 6:44 pm

Thanks for info. Assuming a quant/analyst has begged, borrowed and tried not to steal the data and does regularly download data to their workstation how do they prepare/compare/validate/clean/process large scale historical data sets? Is this something quants/analysts are engaged in on an individual basis when carrying out research?