Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Power BI Currency Error
Hi,
It appears that when Power BI gets the 'Symbol Price' of a share (from finance.yachoo in this instance) it doesn't not distinguish between GBP(pounds) and GBp(pence) is there a way for it to tell the difference between the two? As it currently reads 1,601.00GPp to be £1601, rather than the correct £16.01.
Thanks.
It appears that when Power BI gets the 'Symbol Price' of a share (from finance.yachoo in this instance) it doesn't not distinguish between GBP(pounds) and GBp(pence) is there a way for it to tell the difference between the two? As it currently reads 1,601.00GPp to be £1601, rather than the correct £16.01.
Thanks.
Comments
in psConfig.txt for your symbol list you can specify factor of 0.01 to convert pence to pounds:
# Yahoo: list of symbols from Yahoo Finance website. Format: Symbol,MinDate,MaxDate,IntraDayFlag[Y|N],[DividendFlag[Y|N],FactorHistory,FactorIntraDay,FactorDividend
A.L,,,Y,N,0.01,0.01,0.01