The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
13 views

Where can I find CMS swap trading prices?

I am writing a paper about CMS swap. To do so, I'd like to compare different theoretical pricing methods of these instruments to the "real prices" i.e. prices used in the marketplace. But I don't ...
3
votes
2answers
172 views

Which Database (MySql or NoSQL) for a Stock market App

I'm re-creating an app for Stockmarket Screening & Realtime charting Display. The database wireframe which i propose to design is as follows: 1. Company master - Where all the information of ...
3
votes
1answer
47 views

Where to find Investment home bias data & Historical country weight in World MSCI

I need the following data and struggles to find it, maybe some of you can help me. Note: I'm a student and in our university ain't Bloomberg nor Reuters. Investment home bias, e.g in 2012 US ...
6
votes
3answers
153 views

Creating Options Database

I am trying to create a database which will hold information for various stock options and will need to be updated daily. The idea is to use this database to keep track of changes in the open interest ...
2
votes
3answers
165 views

Options Data Sources

I am using Option Metrics to study a couple of things related to options. However, Option Metrics is quite limited in terms of scope (mainly it's US equities). I was wondering two things: 1) Are ...
1
vote
2answers
124 views

Which database to choose for storing and aggregating finance data?

I'm planing to store stock market data in realtime and aggregate ticks for draw volume based cluster graph. Something like this: Every tick (or second) data will be grouped by period (1,5,10 ...
2
votes
2answers
176 views

Free high resolution financial data

As thebonnotgang(1) stopped updating their database, I was wondering if there are some other free sources of high-frequency data available. I found a proper tick data api (ca. 25 day history) hosted ...
7
votes
2answers
422 views

What time series database can be used with Python and Pandas?

I'm looking for a time series database that can be easily used with Python and Pandas objects such as DataFrame, Panel... But these objects will always contains time series. Ideally I'm looking for ...
6
votes
2answers
2k views

Performance of Open Source Time Series Database for Financial Market Data

We would like to store financial tick data in a database (potentially billions of rows) and then create aggregated (open-high-low-close) bar data from it (e.g. 1min or 5min bars). It was mentioned ...
3
votes
1answer
110 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 ...
1
vote
1answer
311 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 ...
1
vote
1answer
436 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 ...
2
votes
1answer
146 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
170 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 ...
0
votes
3answers
818 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.
3
votes
2answers
388 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 ...
0
votes
1answer
2k 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
410 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
2answers
998 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 -> ...
3
votes
3answers
413 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 ...
1
vote
1answer
642 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
3answers
610 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, ...
0
votes
0answers
846 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: ...
2
votes
2answers
3k 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 ...
10
votes
5answers
4k 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.). ...
6
votes
3answers
460 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 ...
9
votes
1answer
4k 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 ...
20
votes
10answers
17k 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, ...
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 ...
12
votes
3answers
7k 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
112 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 ...
23
votes
5answers
12k 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 ...
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 ...
50
votes
7answers
19k 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 ...