SMS, Whatsapp, Email - Alerts possible ?

Advanced automation available in Guardian - Chat with others and share files here.
Post Reply
scesc
Posts: 97
Joined: Sun May 22, 2016 8:01 am

Not quite sure where to put this question, but does anyone know of anything that could automate some kind of alert, either from within Bet Angel or Betfair that would maybe send an email, or a message of some kind. Due to having a regular 9-5 office job, I find myself nipping into the gents a bit too frequently to either log into Betfair, or to remote in to my home PC to see how my automation is doing. At the moment it's not a big deal because these are micro bets and I could easily wait until I get home, but curiosity always gets the better of me.
Basic information such as Betfair balance, or most recent profit/loss would be good.
User avatar
Euler
Posts: 20658
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ
Contact:

We have considered something like this but haven't found a suitable solution as yet. We found one last year but as soon as we started testing it, it was closed down as they didn't want it to be used 'to encouraging gambling' sheesh....
scesc
Posts: 97
Joined: Sun May 22, 2016 8:01 am

Thanks. Actually I wonder if a reasonably simple windows macro could be used on the remote machine that's running Bet Angel.
Have Betfair open. Click the balance refresh. Use a snip type tool to capture the balance, and send to myself via an email. It all sounds very clunky, but I guess may work.
If the sun wasn't shining today I'd investigate. Maybe this is a task for one evening this week.
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

I'm sure you can send emails from excel/MS office using VBA. Not sure what details BA sends to excel but it should be easy enough to automate an email to send the data from a sheet either at set times or when events occur like races suspending/changing
scesc
Posts: 97
Joined: Sun May 22, 2016 8:01 am

Yes, the Excel VB would be good. For now I have just loaded some freeware called TinyTask as a macro recorder. Works ok. I just tried it with the Betfair home page open (and logged in). Macro performs a balance refresh, opens up windows snip, takes a small snip of screen where balance shows. Clicks on new email in outlook, fills out details, pastes screenshot and sends. Closes windows snip. Then I left it recording doing nothing for 14 mins. I can then set it to repeat this about 36 times, which should cover me for the day. At least for now it satisfies my curiosity in knowing how things are going while I'm at work.
User avatar
marksmeets302
Posts: 525
Joined: Thu Dec 10, 2009 4:37 pm

I like NotifyMyAndroid for these things. I'm sure you can tie it to excel etc.
makkad
Posts: 60
Joined: Thu Sep 22, 2016 10:38 pm

Resurrected this thread as 4 years have passed since the last post. Technology must have moved on in the last 4 years. There should be a solution out there by now.

I was thinking of perhaps an alert being pushed through from BA onto my integrated excel spreadsheet - from which I could generate an alert of my own. Still a bit clunky though
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

I have emails sent to me via an excel sheet. Just a simple VBA script that sends me a balance and breakdown of results copied from a worksheet, also seends error alerts.

Here's a simple email script you'd call with Call sendErrorMail as long as you have outlook running on the PC too

Code: Select all

Sub sendErrorMail()
Application.DisplayAlerts = False
On Error Resume Next


Dim Email_Subject, Email_Send_From, Email_Send_To, _
Email_Cc, Email_Bcc, Email_Body As String
Dim Mail_Object, Mail_Single As Variant
Email_Subject = time() & " Error with  markets"
Email_Send_From = "[email protected]"
Email_Send_To = "[email protected]"
Email_Body = ' here you add whatever string you wish for the body

On Error GoTo debugs
Set Mail_Object = CreateObject("Outlook.Application")
Set Mail_Single = Mail_Object.CreateItem(0)
With Mail_Single
.Subject = Email_Subject
.To = Email_Send_To
.cc = Email_Cc
.BCC = Email_Bcc
.Body = Email_Body
.send
End With
debugs:
If Err.Description <> "" Then MsgBox Err.Description
End Sub
sniffer66
Posts: 658
Joined: Thu May 02, 2019 8:37 am

I sound a bit like a broken record but Auto-It would do it. Set your automation to popup an alert at required times, scrape the website or copy your logfile and mail it
wasp
Posts: 10
Joined: Thu Sep 10, 2020 6:47 pm

As above and their are add-ins for excel that can send text messages. Look in Excel -> File -> Options -> Add Ins
Post Reply

Return to “Bet Angel - Automation”