Excel winros function

[eduguelman]

I´m having trouble making the winros function refer to another cell which would provide the name of the stock to price..
say i have the stock in cell A1, when i try to put =WINROS|Last!'A1'/10^12
it returns a value error.. i have tried many variations but the reference never works, any ideas?