Thank you for asking @jarric, I have setup the Excel file charts as standard templates and re-use them every week. Since I don’t use https://www.gridcoinstats.eu/ anymore to extract GRC information, I now add new data-points using this semi-automatic approach:
- Using Autoit and wget extract data points from https://boincstats.com for the RAC information (team RAC and overall project RAC)
- Manually extract USD/GRC value from https://coinmarketcap.com/currencies/gridcoin/
- Manually transfer data points to Excel to generate the week charts info per project
- Use a Pivot table to align the output to make it usable for the Excel file charts
- Use a macro in Excel (VBA) to extent the time-line with one week
I won't say this it is an easy way but it does the trick without too much effort. :)
Thank you for response.
Why not use their API to extract JSON with Gridcoin data? It might prove easier and faster, as you can write a simple script in any programming language.
///EDIT: It might be also reuseable!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for the suggestion and probably you're right. One more thing to add to the list. :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit