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()
{
}