Jump to content

Recommended Posts

Hi All

I was wondering if anybody could help me "pull in" the last traded price into an excel spreadsheet ??

I am currently using Bitstamp but all attempts using the "import data from the web" feature have failed.

Thanks in advance for your time :)

Edited by Stormy09

Share this post


Link to post
Share on other sites

Thanks for the reply OlivierA

To be honest I am trying to build a small amount of xrp by trading instead of buying and I have a few targets

at various percentages 

If I could just "auto update" the price it would save a lot of time .

At the moment I have qty sold and price, current price which is keyed in every couple of minutes

and my little spreadsheet tells me what profit / loss this current price is giving.

I am using Excel 2013 

Share this post


Link to post
Share on other sites

You can use this to get BTC/USD

=(GOOGLEFINANCE("CURRENCY:BTCUSD"))

after that, I,m sure you can figure out some maths to create all the pairs you need

Edited by OlivierA

Share this post


Link to post
Share on other sites

I haven't (and won't) test it with Excel, I prefer Google Spreadsheets for this kind of task. If it doesn't work with Excel, maybe give it a try.

You can also extract info from Ripple. It's a little more tricky, this is how I do it

Let's say you want the weighted average  price of USD.Bitstamp/XRP

You need the Bitstamp address: rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B

You can change that Ripple address to you needs.

In cell A1 you extract the info, but won't a clean price

=IMPORTDATA("https://data.ripple.com/v2/exchange_rates/XRP/USD+rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B")

So, in cell A2, you clean up cell A1 to extract only the price

=REGEXEXTRACT(A1,"[0-9]*\.[0-9]+[0-9]+")

Lots more fun here if you're into this

https://ripple.com/build/data-api-v2/#get-exchange-rates

 

Share this post


Link to post
Share on other sites

Really wish I was - it's left me bog-eyed !! - unfortunately I just can't follow that

HOWEVER - I am just experimenting with Google Sheets as opposed to Excel and I 

really appreciate your help - kindest regards and good luck with your trading :)

Share this post


Link to post
Share on other sites
6 hours ago, OlivierA said:

I haven't (and won't) test it with Excel, I prefer Google Spreadsheets for this kind of task. If it doesn't work with Excel, maybe give it a try.

You can also extract info from Ripple. It's a little more tricky, this is how I do it

Let's say you want the weighted average  price of USD.Bitstamp/XRP

You need the Bitstamp address: rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B

You can change that Ripple address to you needs.

In cell A1 you extract the info, but won't a clean price

=IMPORTDATA("https://data.ripple.com/v2/exchange_rates/XRP/USD+rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B")

So, in cell A2, you clean up cell A1 to extract only the price

=REGEXEXTRACT(A1,"[0-9]*\.[0-9]+[0-9]+")

Lots more fun here if you're into this

https://ripple.com/build/data-api-v2/#get-exchange-rates

 

Thank you. But there seems to be a difference from what i get from the api vs ripplecharts.com if I use this:

https://data.ripple.com/v2/exchange_rates/XRP/USD+rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B?

Am I doing something wrong? Would like to get the rate via the api

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...