A "static" visualization example
The figure gives the structure of the Volatility Database. It currently contains 5 tables, among which four are connected via the Security ID, a primary key in Table 1 (Security).
In Table 1 (Security) we store the securities' ticker (as used by Bloomberg), and the flag index (if the security is an index, the flag is true; for an equity, the flag is false). In Table 3 (Security price) we store the closing price (daily values) for the Security specified by Security ID. Table 5 (option Price) stores all the information needed to compute the Implied Volatility. An interest rate yield curve is stored in Table 6 (Yield Curve). The curve is constructed using interpolated values from interest rate products. Table 8 contains all the necessary information for drawing the volatility surface on a different platform (for example, on a web page).
The purpose of the Volatility Database is to provide valuable data, and quality analytical tools and algorithms of financial data for universities, traders, banks, hedge funds, etc. Currently, the database contains:
Dynamic visualization is available here.