Tag Info

Hot answers tagged

2

Assuming you are at a decent university, you are better off seeing if you can get this data from Bloomberg or from a university subscription to Compustat.


2

As background, Floating point precision is a way of storing numbers such that the precision is relative to the largest digit. For instance, the number $0.00123$ stored in fixed precision needs 6 digits of precision (3 zeros and the 3 non-zero numbers). However, this same number stored as floating point precision $1.23 \cdot 10^{-3}$ needs only 3 ...


2

Have a look at Kona which is a FOSS project trying to be compatible. Also Tom Szczesny has done some work on its predecessors namely A. I hope this helps. Also if you are not looking for a perfect substitute you can have a look at other Time Series Databases like InfluexDB, Java Chronicles, OpenTSDB, KairosDB which are all Open Source. There are commercial ...


1

I've run into this issue as well. I can't find any official documentation, but the issue arises because the SEC makes up CUSIPs for all of the options on the list. It does this by taking the first 6 digits of the underlying equity (which makes sense, as this represents the issuer, which should be the same for the stock and the option), and then for the 7th ...


1

The Harvard Bankrupcy Data Project tries to do exactly that, they seem to have data for the specified time frame, but unfortunately I cannot vouch for its accuracy. http://bdp.law.harvard.edu/filingsdb.cfm edit: They don't seem to offer the full data any more, so that indeed won't work for you. You could instead try this one, one of the sources for the ...


1

Recently I found a book on earnings trading but did not have time to read thoroughly. Trading on Corporate Earnings News - John Shon I also had spent some time to see earnings surprise effects and it is a quite interesting but not easy to use topic. There is certainly a jump if the estimates and announced earnings have a large mismatch but the magnitude ...


1

For any data that is not strictly tabular and unchanging in schema, you should rule out SQL solutions. Option pricing fits that description in my experience, because high-liquidity stocks, currencies, or bonds, will have a far bigger set of strikes and maturities than lower liquidity instruments. Thus in a relational database you will have to have columns ...


1

Lots of people focus on data storage ability and compare KDB with other SQL/query-based databases. Such comparison is like considering "Is a Ferrari good for running a bus route?" KDB+ is capable of manipulating and querying large data set. The performance is fast (in comparison to most RDBMS) due to its column based storage, but it's not her strongest ...


1

One of the reasons q/kdb+ is attractive for tick data is that it can process data tick by tick as well as using the SQL-like query language. The only system I've used that can process a tick-feed like q/kdb+ is Esper. It is very difficult to work with because it's an embedded language invoked by an Esper runtime environment within a JVM. There are extra ...



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