What I want to do is make a dictionary of all the tickers on AMEX, NYSE and NASDAQ markets and their associated names/shortened names. I have all the information I need in Excel, I just don't know how to transfer it into C#.
I am going to be using the dictionary to test user input.
Right now I am using an SQL database and the only input that works for searching for a company like Apple, is either its associated stock ticker AAPL or typing the full name of the company like Apple Inc..
This is my dictionary setup, I have it in its own .cs file:
public class FinancialTickers
    {
        public string AssociatedName { get; set; }
        public string CompanyName { get; set; }
    }
    public static void Main()
    {
    }
 
    