The question is "How do I reference data in an .csv file?
My way would be to cut out the .csv file and use a Macro containing VBA and ADO that receives the data and puts it directly into a worksheet in Excel. Any ODBC compliant database can be your source.
Excel 2010 has Data>>Get External Data - from various data sources. However, I prefer to write my own code because I have absolute control and can format the results in the macro.
Refresh is at the click of a button and you can do anything with it.
I could let you know some specifics if you tell me what database the metrics are coming from.
PS Look at the list of drivers in Data>>Get External Data>> Existing Connections>> Browse for More >> New Source >> Other Advanced >> Next which leads you to the Data Link Properties list. You then have to know what source database and what driver to use. You can email me at cliffbeacham at hotmail with more details.