The tag has no usage guidance.

learn more… | top users | synonyms

20
votes
5answers
10k views

Usage of NoSQL storage in Finance

I am wondering if anyone has used NoSQL (mongodb, cassandra, etc.) to store and analyze data. I tried searching the web but was not able to see if the financial firms had gotten in to using nosql ...
3
votes
1answer
52 views

Kenneth R. French data base on momentum and size: construction and how to use it concretely with momentum only

So, you can find all the data bases on this site. More explicitly, I would like to take the "Developed Market Factors and Returns" part. Even more explicitly, let us take the "25 Portfolios Formed on ...
8
votes
1answer
3k views

Why use a column database for tick/bar data?

I often hear that column-oriented databases are the best choice method for storing time series data in finance applications. Especially by people selling expensive column-oriented databases. Yet, at ...
1
vote
1answer
161 views

Where can I find US public company bankruptcy data

I am doing a thesis about firm survival in time of crisis (2008-2009) and I would like to know where can I find publicly available database about company bankruptcy. Since I have thousands of ...
45
votes
7answers
15k views

Efficiently storing real-time intraday data in an application agnostic way

What would be the best approach to handle real-time intraday data storage? For personal research I've always imported from flat files only into memory (historical EOD), so I don't have much ...
-2
votes
3answers
338 views

Where to get access to an inexpensive or free hedge fund/CTA DB?

Basically, the question is in the title. For some similar data: EDHEC provides some data and one can also get the Mutual Funds data from the Yahoo Finance:is there anything else out there? Thanks, ...
1
vote
1answer
179 views

SEC 13F Security List has incorrect CUSIP numbers?

I'm building database of 13F sec.gov forms with 13F security lists (http://www.sec.gov/divisions/investment/13flists.htm). Along with integrity checks. I implemented CUSIP digit check algorithm to ...
0
votes
0answers
82 views

Greenplum database storage model for time series data

I have to deploy a greenplum database for analysis of time series data. I will have around 50 different time series (s1,s2,s3,...s50) and each series will have multiple pairs (time is 1 hour average ...
11
votes
9answers
12k views

Is there any thing out there as a substitute for KDB?

thanks a lot for your discussions on the original post. following your suggestions, let me re-phrase a bit : kdb is known for its efficiency, and such efficiency comes at a terrible price. However, ...
2
votes
1answer
91 views

Create 10-K Filing Database

I am finance grad student, and working to create a financial statement database. My objective is to download an income statement, balance sheet, and statement of cash flows for every publicly traded ...
0
votes
2answers
131 views

float64 to store price data: is precision sufficient?

I am looking to store equity price data in a hdf5 table. The use will be purely as a historical archive, not as day-to-day data source. Options One option would be to store base10 significand and ...
7
votes
5answers
3k views

Best way to store hourly/daily options data for research purposes

There are quite a few discussions here about storage, but I can't find quite what I'm looking for. I'm in need to design a database to store (mostly) option data (strikes, premiums bid / ask, etc.). ...
3
votes
3answers
377 views

Measuring historical earnings surprises, their frequency and severity

This is my first post to Quantitative Finance, so I hope my question is formatted the right way. I am starting to research the effects of earnings surprises on certain equity indices. Is there a ...
0
votes
3answers
581 views

Databases for storing and querying high frequency tick-level data?

My firm is looking for an out-of-the-box database system to store and query high-frequency tick data. What are the best options? It seems that kdb+ is the market leader in this field.
2
votes
1answer
298 views

Places to make quant code/tools publicly avaliable

Over the years I have developed several tools - including pricing, optimization and calibration tools - most in VBA, C# and C++ I would like to make them publicly avaliable. Aside from putting up my ...
1
vote
2answers
696 views

Free database for storing intraday tick data and querying bar (candle) data on budget hardware

I'm using a cloud machine with 512 RAM to store tick data in mysql, but I'm having trouble querying candle data. My current solution is to select all data within a time interval and do the tick -> ...
0
votes
1answer
1k views

S&P's Sovereign Ratings: Clarification on Definitions and Symbols

Similar to a question I asked earlier on, but I am now looking at S&P's sovereign ratings. Here, as in the case of Moody's, a few things are unclear to me in terms of the definitions used by ...
2
votes
1answer
323 views

Moody's Sovereign Ratings: Clarification on Definitions and Symbols

I'm working with sovereign ratings at present. With regard to Moody's there are a few things unclear to me in their definitions. Both questions refer to the sovereign rating history in Bloomberg CSDR ...
1
vote
1answer
453 views

Components of an index in a specific date

Objective: Get a list of all the companies that were ever part of an index (e.g.: FTSE100) in a given period of time (scale: years/decades). Method I have in mind: 1) Create an empty list k. 2) Get ...
2
votes
2answers
2k views

How can you convert the CUSIP of a bond issue to the CUSIP of the company's stock/

As part of a research project I ran a query on the Mergent FISD database using the WRDS website. The output included the CUSIPs of numerous bond issues (>10000). I am using this data to run event ...
0
votes
0answers
699 views

fetch from yahoo! finance database - varying number of ticks

To test a model with real-life data, I used the fetch-function in matlab to connect to the database of yahoo! finance. My code to try and get 7 different assets' returns is the following: ...
7
votes
2answers
2k views

Non-SQL methods for high-frequency accounting?

Does anyone know of any prior art for non-SQL data structures for high-frequency accounting, whether client, broker, or exchange-side? I'm thinking specifically of the problem of booking individual ...
6
votes
3answers
427 views

Scanning a stock database for errors/flaws

I'm currently working on some matlab code that is supposed to check a stock database for any errors (missing values, wrong values, etc.). The reason for this is that after reading this post I came to ...
17
votes
2answers
3k views

Do you have historical tick data you want to donate?

Do you have historical market/pricing ticket data that you would like to donate to the Open Source Trader project (OST)?? Please: upload your files! Once we gather some data, we'll do our best to ...
12
votes
3answers
6k views

R: How feasible is it to store — and work with — tick data in a database connected to R?

I'm looking to convert some tickdata .csv files into a database on a local disk and then use R to call the data and do my various analytics and modelling. What are some best practices / ...
4
votes
0answers
111 views

single channel for multiple feeds of news? [closed]

I subscribe to various blogs and twitter feeds which I use to parse for keywords. Many times these subscriptions do not include topics which are of the primary concern. Are there multiplex channels ...