Countif

Originally Posted by Rikuk

I currently have a program which exports live betfair odds into excel, the data is always updating cell A1. Is there a way of charting this so I can see the trend over time?

Thanks in advance

Rik

Hi,

Which area would you like the data moved to (to chart), and how often does it update?

---

Originally Posted by Rikuk

Hi, Looking to track data in a line chart, updates every 30 seconds.

Rik

Hi,

Before I research the OnTime 30-second timer to trigger this, is this the sort of thing you are looking at, put a figure in A1 and press CTRL r

CTRL r is the Shortcut for Macro 1

---

Originally Posted by Rikuk

Yes that what i'm looking for

Rik

ok - first time play with OnTime, the Ontime seems to work, but it's not keen on being dismissed, so if all else fails use kill in B1 until I work out why.

Let me know how you go
---
added, remove the 'kill' to make it go
---

Originally Posted by Rikuk

Thanks that what I'm looking for, works on & off sometime get an error.

Thanks you for your time.

Rik

Hi,

an error does occur in trying to kill, (hence my use of B1) but if you get an error other than that please let me know.

---