Currently using Excel web query import hack...filter out all PoS rows @
https://spd.overemo.com/ then averaging the remaining blocks.....set the macro to run every 2 min or so...grab price from exchange api in similar fashion but with json import, parse the query to AM from excel to update the coin...worked for me for JoltGas (JLG)...
I'm totally no good at programming and maths, so this is a rather lame way to implement but .... not bad for temporary patch work ;p
**something like this
Sub TestJLG()
Dim objHTTP As Object
Dim URL As String
Dim Data As String
Dim replyTXT
Dim URLConcat As String
Dim cellxIndex As Integer
Dim cellTicker As Integer
Dim cellName As Integer
Dim cellAlgo As Integer
Dim cellReward As Integer
Dim cellDiff As Integer
Dim cellBTC As Integer
cellTicker = 17
cellName = 20
cellAlgo = 8
cellReward = 11
cellDiff = 2
cellBTC = 5
cellxIndex = 1
URLConcat = "http://localhost:17790/api/coins/" & Cells(cellTicker, cellxIndex).Value & "?name=" & Cells(cellName, cellxIndex).Value & "&algorithm=" & Cells(cellAlgo, cellxIndex).Value & "&reward=" & Cells(cellReward, cellxIndex).Value & "&difficulty=" & Cells(cellDiff, cellxIndex).Value & "&btc=" & Cells(cellBTC, cellxIndex).Value
Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
URL = URLConcat
objHTTP.Open "POST", URL, False
objHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
objHTTP.send ("")
cellxIndex = 2
URLConcat = "http://localhost:17790/api/coins/" & Cells(cellTicker, cellxIndex).Value & "?name=" & Cells(cellName, cellxIndex).Value & "&algorithm=" & Cells(cellAlgo, cellxIndex).Value & "&reward=" & Cells(cellReward, cellxIndex).Value & "&difficulty=" & Cells(cellDiff, cellxIndex).Value & "&btc=" & Cells(cellBTC, cellxIndex).Value
Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
URL = URLConcat
objHTTP.Open "POST", URL, False
objHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
objHTTP.send ("")
Application.OnTime Now + TimeValue("00:00:30"), "TestJLG"
End Sub
currently trying to work out a way to cache the json locally so I don't get blocked from the api if the list of coins grows