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, at 30-60 seconds intervals.
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.
Excel VBA knowledge: Auto Update external feed
viewtopic.php?f=31&t=4674
That thread talks about data scraping.
For the cell copy you just need to make a simple macro that copy's the cell, do you want to store the odds or just know difference between a set time?
That thread talks about data scraping.
For the cell copy you just need to make a simple macro that copy's the cell, do you want to store the odds or just know difference between a set time?
Hello,
Thank you for you response. My big problem is to make the feed auto update(refresh). By now I have tried the auto-refresh and set the refresh interval to 1 minute, but doesn't work.
I would like to know the difference from between a set time. let's say 1 minute or less.
Thank you for you response. My big problem is to make the feed auto update(refresh). By now I have tried the auto-refresh and set the refresh interval to 1 minute, but doesn't work.
I would like to know the difference from between a set time. let's say 1 minute or less.
Have a look at the attached sheet I quickly made, there is one simple macro that copies the cell values. It works by the trigger in cell A2, as this will equal a 1 if it has been over 60 seconds since the last macro trigger.
If you can get your head around macros and IF statements, you can do a lot!
If you can get your head around macros and IF statements, you can do a lot!
You do not have the required permissions to view the files attached to this post.