Page 1 of 1

Local securities database

Posted: January 18th, 2019, 11:49 am
by Moneyweaver
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?

Re: Local securities database

Posted: January 18th, 2019, 2:11 pm
by bearish
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.

Re: Local securities database

Posted: January 18th, 2019, 6:44 pm
by Moneyweaver
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?