• C++ Programming for Financial Engineering
    Highly recommended by thousands of MFE students. Covers essential C++ topics with applications to financial engineering. Learn more Join!
    Python for Finance with Intro to Data Science
    Gain practical understanding of Python to read, understand, and write professional Python code for your first day on the job. Learn more Join!
    An Intuition-Based Options Primer for FE
    Ideal for entry level positions interviews and graduate studies, specializing in options trading arbitrage and options valuation models. Learn more Join!

Schema to store EOD data

Joined
11/13/16
Messages
1
Points
11
I'm looking to store EOD data in a MySQL database. The table would be simple with columns for Ticker, date OHLC.

The problems are that the company associated with certain tickers changes over time (C used to be Chrysler, now it is Citibank). What is the most efficient way to store the data so that I can query a company's data going back as long as I want?
 
Back
Top