Live Stock Data

%3CLINGO-SUB%20id%3D%22lingo-sub-2339263%22%20slang%3D%22en-US%22%3ELive%20Stock%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339263%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20change%20the%20livestock%20data%20into%20a%20different%20currency%3F%20For%20example%2C%20if%20I%20have%20apples%20livestock%20data%20in%20excel%20and%20the%20price%20is%20shown%20in%20%24%20can%20I%20change%20it%20so%20the%20value%20is%20shown%20in%20GBP.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2339263%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2339360%22%20slang%3D%22en-US%22%3ERe%3A%20Live%20Stock%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339360%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1039692%22%20target%3D%22_blank%22%3E%40KFOSSU99%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20extract%20any%20stock%20data%20it%20will%20retrieve%20the%20trade%20currency%2C%20what%20you%20can%20do%20is%20use%20currency%20data%20type%20from%20USDGBP%20extract%20the%20price%20and%20do%20your%20calculation.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

Is it possible to change the livestock data into a different currency? For example, if I have apples livestock data in excel and the price is shown in $ can I change it so the value is shown in GBP.

 

Thanks

1 Reply

Hi @KFOSSU99,

 

When you extract any stock data it will retrieve the trade currency, what you can do is use currency data type from USDGBP extract the price and do your calculation. 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.