Tag Info

Hot answers tagged

5

A columnar database or No-SQL solution may be your best choice. It depends on which OS you target, what your throughput and latency requirements are and whether you look to persist all data or not and finally how big the size of your data is expected to be. Obviously if you only look to store hourly/daily data then even a database that comprises a year of ...


5

I recommend you optimize your SQL implementation instead of going for NoSQL, and throwing more expensive hardware at the problem. Always benchmark first. The reason I'm saying this is that I've seen MS SQL Server scale perfectly fine for options data of the magnitude you're describing and "big number of strikes tables will be enormously long and, hence, ...


4

(P) prefix : As a service to the market and typically at the request of an issuer, Moody's will assign a provisional rating when it is highly likely that the rating will become final after all documents are received, or an obligation is issued into the market. A provisional rating is denoted by placing a (P) in front of the rating. Such ratings may also be ...


2

You need to log some data, and later use it for analysis. Dare I suggest you just append the values to a set of files? You can load up the data later for your runs, and cache anything needed frequently. Frankly buying an SSD and copying the files to that before you run analysis should solve your problem, and no-one had to get hurt.


2

I would recommend de-normalising the data or using a document database such as NoSQL or MongoDB. These provide a speed advantage when performing select statements as there would be no need to lookup or join data from other tables. An advantage of using a document database is that they store data in an industry standard format such as JSON or XML so it should ...


2

Github and Bitbucket are both good options for a git repository. If you want other people to look at your code and help build on it, Github is the better choice. If privacy is what matters most, you can get a free private repository from Bitbucket. On github, only public repositories are free.


1

SD is selective default http://www.reuters.com/article/2013/06/28/us-cyprus-downgrade-standardandpoors-idUSBRE95R0YQ20130628 +u is unsolicited rating http://lexicon.ft.com/Term?term=unsolicited-rating


1

You can use this website here: http://activequote.fidelity.com/mmnet/SymLookup.phtml I would recommend using a simple data manipulation language such as Python in order to solve your problem. You would need to write a code that read the webpage for specific CUSIP numbers and then find the specific portion of the HTML file that will contain the name of the ...


1

Have you considered the HDF5 data model? Edit for Louis : Why using HDF5 ? As stated in the HFDF short description page : HDF5 is a unique technology suite that makes possible the management of extremely large and complex data collections. HDF5 is a suitable solution when dealing with very large datasets and you need performance. Again, as ...



Only top voted, non community-wiki answers of a minimum length are eligible