Keeping / capturing SP's on the Bet Angel Spreadsheet

[sherman]

Hi, Is there a way to keep the Betfair SP's on the Bet Angel spreadsheet ? They disappear after a short time.
Maybe it needs a macro to copy them to another col when they appear, but this is beyond my skill with vba, can anyone help or suggest ?
Thanks

[sherman]

Hi, I would really appreciate some help with this .. Is there any way to keep the SP data on the sheet ?

Cheers
Paul

[Xion]

It's easy to capture a cell value if using a time based trigger.

e.g.

Cell A1 = 16:00:00

Cell A2 = If(Now() >A1,"Capture","")

Suppose you want to capture the value in Cell B1 and keep it in Cell C1.

Cell C1 = If(A2 = "Capture",If(C1="",B1,C1),"")

All the time the word Capture remains in A2 the value in C1 will remain.

You can replace the word capture with anything you like.
If you want a formula that will work regardless of the word used then change the formula in C1 to

Cell C1 = If(A2 <> "",If(C1="",B1,C1),"")

Hope that helps.

[sherman]

Hi Xion, thanks for your reply, I am not sure yet if it will do what I need, but when I did a test and entered the formula in A1 & A2 that was ok, but when I entered in C1 (either of the formulas) I get a "circular reference" error ...

Cheers
Paul

[Xion]

Hi Paul

Sorry I forgot to mention about the circular reference. This perfectly normal.

You need to go in to Excel settings for Calculating and TICK the LIMIT ITERATION box then change the MAXIMUM ITERATIONS to 1.

That will stop the circular reference error and what you're trying to achieve should work.

Let me know how you get on or if you need more help.

Cheers.

[Orixian]

Thanks for that Xion ive spent the last few hours messing about with that formula. Was just waht i was looking for.

[Xion]

You're welcome.