Google sheets scripting and importing BTC data
Budget: $30 – $250 AUD
I am looking for someone to help me complete my google spreadsheet that is importing BTC data daily.
Some of this would be data regarding basic trading functions like Stoch RSI, Pi cycle, MACD etc, whereas other data would be on chain data like NUPL, MVRV-z score, Mayer Multiple etc. 17 indicators in total. Some I have already solved with a bit of google and chat gpt.
I would prefer to import this data without a subscription to glassnode or coinmetrics etc. There are pages online that have this data shown, There should be a way to export from there I think.
I don't really know how to setup google sheets properly to import JSON and other such things.
I also need this data backdated to its earliest available date.
I have setup some scripts to import some of this information but I am a novice at this and I am sure someone could just come in and tidy it up and get it running smoothly in no time at all.
How I am trying to set it up at the moment is that one row populates with all the data of today's date, as it becomes available throughout the day.
As the day ends, a new row gets added with the new date of tomorrow. Then, all the formulas that are pulling in the data of today are copied to the tomorrow row, and the cycle repeats.
But I need to make sure it then flattens all the data of yesterday, so they stop following the current day, and stay on their own date.
Does that make sense? Anyway, you'll see what I mean.
Some of this would be data regarding basic trading functions like Stoch RSI, Pi cycle, MACD etc, whereas other data would be on chain data like NUPL, MVRV-z score, Mayer Multiple etc. 17 indicators in total. Some I have already solved with a bit of google and chat gpt.
I would prefer to import this data without a subscription to glassnode or coinmetrics etc. There are pages online that have this data shown, There should be a way to export from there I think.
I don't really know how to setup google sheets properly to import JSON and other such things.
I also need this data backdated to its earliest available date.
I have setup some scripts to import some of this information but I am a novice at this and I am sure someone could just come in and tidy it up and get it running smoothly in no time at all.
How I am trying to set it up at the moment is that one row populates with all the data of today's date, as it becomes available throughout the day.
As the day ends, a new row gets added with the new date of tomorrow. Then, all the formulas that are pulling in the data of today are copied to the tomorrow row, and the cycle repeats.
But I need to make sure it then flattens all the data of yesterday, so they stop following the current day, and stay on their own date.
Does that make sense? Anyway, you'll see what I mean.