If you want to look up certain height block number,

I did create a Google sheets script in the past that cycled through different block heights and pull the data from the API. Which I then copied into Excel and extracted the required data. How far back ate you trying to go. Querying the api from Google sheets was slow and times out so if going back a long way might need to be every 1000 blocks or so to keep the data manageable..

0

24.03.2022

Alex

CryptoDaz (Darren)
I did create a Google sheets script in the past th...

Does the script need to work with consequential block? Or can I extract information from (for example) block 1, 3001, 6001, 9001 and so on for other 1000 blocks?

0

24.03.2022

CryptoDaz (Darren)

Alex
Does the script need to work with consequential bl...

I enter a start block height then the interval between blocks, so could be block 54500 then every 100 blocks, or 72085 then every 123 blocks whatever is needed. Partly depends on which data range is wanted If you give me an idea I will see if I can tweak it and run off some data

0

24.03.2022

CryptoDaz (Darren)

Alex
Does the script need to work with consequential bl...

It could be block 1000, 2000, 3000, 4000, etc

0

24.03.2022

Alex

CryptoDaz (Darren)
I enter a start block height then the interval bet...

That sounds really great! Can you share it or is it personal?

0

24.03.2022

CryptoDaz (Darren)

Alex
That sounds really great! Can you share it or is i...

I'm not sure, would need tweaking a little.

0

24.03.2022

CryptoDaz (Darren)

Alex
That sounds really great! Can you share it or is i...

Were you after the supply APY or supply reward APY Cameron's link is for the supply apy and not the reward APY

0

24.03.2022

Alex

CryptoDaz (Darren)
Were you after the supply APY or supply reward APY...

Supply apy 👍

0

24.03.2022

CryptoDaz (Darren)

I don't get to hear anything mys of in advance

0

24.03.2022

CryptoDaz (Darren)

Alex
Supply apy 👍

Ok will take a look. Any idea how far back you are looking to go. Not sure if I can go back prior to kava-9 launch

0

24.03.2022

Alex

CryptoDaz (Darren)
Ok will take a look. Any idea how far back you are...

No sense going before kava 9...are there any guides to learn how to create those scripts by myself?

0

24.03.2022

CryptoDaz (Darren)

Alex
No sense going before kava 9...are there any guide...

If I can get it working I can share it si you can see how it works, which can be tweaked for different API queries

0

24.03.2022

Alex

CryptoDaz (Darren)
If I can get it working I can share it si you can ...

It sounds really good 👍

0

24.03.2022

CryptoDaz (Darren)

Here's a link to the Supply and Borrow APY's from 19th Jan through to 24th March that you asked about The graph didn't import very well, so if you want the graph for a particular asset let me know and can post a better image https://docs.google.com/spreadsheets/d/1sexKjoycuhKJkBSbTuHPTcWSVIYeF1h5sLUkVOhdwP4/edit?usp=sharing

0

26.03.2022

Alex

CryptoDaz (Darren)
Here's a link to the Supply and Borrow APY's from ...

Wow, this is exactly what I was looking for! I don't care about the graph: I can do it by myself on excel...on Monday I'll perform some calculations based on your data extraction. Thank you very much Darren, really appreciate your hard work 👏👏👏

0

26.03.2022

Alex · Accepted Answer

Alex

Is there a way to automatically extract thousands of block numbers at the same time?

0

24.03.2022

210 похожих чатов

If you want to look up certain height block number,

18 ответов

Похожие вопросы