RE: Gridcoin weekly project update - 05/Mar/18

[jarric]

Do you create all those plots in Excel by hand, or do you have a VBA script to generate them for you?

Comments

[parejan]

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:

1. Using Autoit and wget extract data points from https://boincstats.com for the RAC information (team RAC and overall project RAC)
2. Manually extract USD/GRC value from https://coinmarketcap.com/currencies/gridcoin/
3. Manually transfer data points to Excel to generate the week charts info per project
4. Use a Pivot table to align the output to make it usable for the Excel file charts
5. 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. :)

[jarric]

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!

[parejan]

Thanks for the suggestion and probably you're right. One more thing to add to the list. :)