Help Needed : Auto Update external feed

[fpopiku]

Hello,

I'm new in this and I want to learn. I am facing a difficult problem and cannot find the answers by myself, would much appreciate any help I can get.
I want to auto update ( refresh ) an external feed containing odds from Pinnacle Sports website, at 30-60 seconds intervals. Here is the link : http://api.pinnaclesports.com/v1/fee...at=1&islive=0{.
I would also want to apply some formulas to other columns in excel, but mainly I would want to know where is the change in odds. For example if Bayern Munchen has the odds 2, and after the refresh the odds dropped at 1.9 I would want to see the difference in another cell.

Thank you for all your input and your help is much appreciated.

[JamesGoulding85]

Hey fpopiku im just picking this up. did you ever get anywhere with this??

Im hoping to create a similar workbook but am finding so many different responses im unsure where to start!

Thanks

[fpopiku]

Hello,

No I am searching for rhe answer. The main iddea is that I would want a feed to insert in an allready refreshed by another program book. If you have any iddeas would much appreciate.

Thank you