Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Currency Formula #90

Open
CyberSpace1925 opened this issue Aug 10, 2021 · 2 comments
Open

Currency Formula #90

CyberSpace1925 opened this issue Aug 10, 2021 · 2 comments
Assignees
@diegomanuel
Labels
enhancement New feature or request

Comments

@CyberSpace1925
Copy link

HI I'm searching on how i can import live prices from binance to google sheets and I found you. I have a question using this formula =BINANCE("prices", "BTC") how do we add currency or how do we use local currency? for example I want a live price BTC in philippine Peso (PHP)?
@CyberSpace1925 CyberSpace1925 added the enhancement New feature or request label Aug 10, 2021
@HamsterHam88
Copy link

You can just use this in Google Sheets to get an exchange rate =GOOGLEFINANCE("CURRENCY:GBPUSD") and then use the =Binance(...) formula / the ex rate one.

@HamsterHam88
Copy link

It refreshes when you load your spreadhseet up and then I think every 20 mins.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@diegomanuel diegomanuel

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@diegomanuel @HamsterHam88 @CyberSpace1925