Advertisement
Lauda

Untitled

Aug 6th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.91 KB | None | 0 0
  1. class Program
  2.     {
  3.         static void Main(string[] args)
  4.         {
  5.         var url = "http://www.google.com/finance/historical?q=MSFT&output=csv";
  6.         var request = WebRequest.Create(url);
  7.         var response = request.GetResponse();
  8.         var dataStream = response.GetResponseStream();
  9.         var reader = new StreamReader(dataStream);
  10.         var csv = await reader.ReadToEndAsync();
  11.         reader.Close();
  12.         dataStream.Close();
  13.         response.Close();
  14.         var prices = csv.Split('\n').Skip(1)
  15.                         .Select(line => line.Split(','))
  16.                         .Where(values => values.Length >= 5)
  17.                         .Select(values => new {
  18.                             date = values[0],
  19.                             price = float.Parse(values[4])
  20.                         });
  21.  
  22.         foreach (var p in prices.Take(10))
  23.             Console.WriteLine(p);
  24.         }
  25.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement