I am attempting to extract the average volume on screen, but converted into Norwegian Krone based on the currency of each individual stock's base currency. I tried the following, but it did not work: ShowVar(@Pricevolume2,AvgVol(91)*PRICE*FXRate) //
The idea is to find the average daily volume in NOK regardless of the stock's base currency.
What solution is available here?