

Split on each line that is read in to get the comma separated values. Do you know what that means? It means splitting the data up into meaningful bits. CSV (comma separated values)ġ) In your C# program, construct a URL with the desired parameters to match your stock, date range and data type.Ģ) Connect to the url and read in the data response using the code I outlined in my earlier post.ģ) Now you have to parse the data. Ignore=The format of the file to download e.g. for Jan 01, use 01 here.ĭ=END MONTH NUMBER -1 e.g. For February, use 1ī=BEGIN MONTH DAY e.g. I'm going to make a wild assumption that you know what a URL is.Ī=BEGIN MONTH NUMBER -1 e.g. Copy the link URL to dissect it for your program e.g.:Īs I said before, it's not rocket science. Start Date: Jan 01 2006, End Date: Nov 17 2006, Select the Daily data.ħ) Click on the button that says "Get Prices"Ĩ) The page should now reload and display the prices for the dates you selected.ĩ) At the bottom of the page there should be a link that says "Download to Spreadsheet". In addition, you should be shown a form to allow you to specify the date range and data to retrieve.Ħ) Enter the dates and data you want to download e.g. Click on the link that says "Historical Prices"ĥ) You should now be presented with a page displaying historical price information for Microsoft. Click on the button that says "GO".ģ) You should now be presented with a page displaying information for Microsoft.Ĥ) On the left you should see a column with links in it. Can you even code in C#?ġ) Got to Yahoo! Finance by typing in your browser: Ģ) In the "Get Quotes" input box, enter the symbol of the stock you are interested in e.g. Did you follow my suggestions? I don't think you did.
