.NET 4 query and visualization

We need a way to visualize data that is received through an API as a candlestick chart, and apply appropriate filtering to it. The API is .NET 4.0 and responds with a structured binary tagged data stream to a query. The data is essentially a long list of time and price data - the output variables are date, time, price, volume, buyer, seller. The input variables for the query are symbol, date or date-range, time-range. Excel might be an appropriate platform for the data visualization. Ideally the query can be done from Excel also. The received data should be used to construe a 1, 5, 15, or 30-minute candlestick chart depending on the user´s selection. Also, the user needs to be able to apply filtering to the visualization based on buyer and seller IDs to his or her liking. API documentation will be provided to bidders on request