its a function from python pandas incorporated into excel
@soldier4082
8 ай бұрын
execllent
@LearnAccountingFinance
8 ай бұрын
thanks!
@Sito21ify
Жыл бұрын
Is this for stock rates or something casual else?
@LearnAccountingFinance
Жыл бұрын
This for current stock prices as well as currency exchange rates. All business - no casual :)
@Soyodi
4 ай бұрын
I can't see the option currencies data type
@sofiahotel517
3 ай бұрын
ME TOO
@why7389
6 күн бұрын
Same here
@Soyodi
5 күн бұрын
I managed to get the currencies but forgot how I did it 😅
@CS-if4ms
3 күн бұрын
@@Soyodi Actually surprisingly easy to do lets say you want to convert use to gbp ADD a cell using the currency codes so USD\GBP Then highlight the cell and click on data\stocks A little icon will appear on the left of the cell then to output the exchange rate to a cell type location of the cell. price So a1.price in a new cell to convert a value :: type location of the cell.price*location of the value you want to convert so a1.price*b1 Im not sure if the values will change based on the day rate so might be worth using the paste special values It doesn't seem so easy to use in web based version of excel 🙂
@BaconPowderful
6 ай бұрын
Didn’t work for me. 😢
@stephanzurcher
2 ай бұрын
When I click on prices nothing happens on the adjacent cells
Пікірлер: 16