Sample Triggered Betting Spreadsheets

Please post any questions regarding the program here.

Moderator: 2020vision

Sample Triggered Betting Spreadsheets

Postby xraymitch » Thu Jul 30, 2020 6:32 pm

Hello Gary,

In an effort to learn more about Excel I download your com class examples which you created over 8 years ago or so.

Whichever spreadsheet I run gives "Run Time Error -2147221164(80040154) Class Not Registered"

Debug shows in yellow always at the same line "Set ba = New BettingAssistantCom.ComClass"

I am using Excel 2016 with Windows 10 Pro and BA ver 1.3.0.45m

I am way out of my depth but have included a screenshot showiing the References that are enabled.

As this is not an urgent matter please advise when you get a chance.

Many thanks 8)

sauU1tglf3.png
References
sauU1tglf3.png (217.72 KiB) Viewed 15597 times
xraymitch
 
Posts: 410
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Re: Sample Triggered Betting Spreadsheets

Postby GaryRussell » Thu Jul 30, 2020 8:18 pm

You may need to do a re-install to register COM. Uninstall from the control panel then re-install from the following link.

http://www.gruss-software.co.uk/Betting ... istant.msi
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Re: Sample Triggered Betting Spreadsheets

Postby xraymitch » Fri Jul 31, 2020 9:36 am

Thanks, I will give that a try later today and report back.
xraymitch
 
Posts: 410
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Re: Sample Triggered Betting Spreadsheets

Postby xraymitch » Sun Aug 09, 2020 4:37 pm

Frustrating - I have reinstalled BA and Excel, all to no avail.

Have spent hours this last week searching on the error "Run Time Error -2147221164(80040154) Class Not Registered" but will continue to search in the hope of coming up with a solution.

Thanks 8)
xraymitch
 
Posts: 410
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Re: Sample Triggered Betting Spreadsheets

Postby GaryRussell » Sun Aug 09, 2020 7:23 pm

Is your office installation 64 bit? If so try the following.

Open a command prompt in admin mode then enter the following two commands.

i) cd C:\Windows\Microsoft.NET\Framework64\v4.0.30319
ii) regasm /codebase "c:\program files (x86)\Betting Assistant\BettingAssistantCom.dll"
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Re: Sample Triggered Betting Spreadsheets

Postby xraymitch » Mon Aug 10, 2020 5:01 pm

Brilliant - that has fixed it.

Thanks a million.

8)
xraymitch
 
Posts: 410
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Re: Sample Triggered Betting Spreadsheets

Postby daveat91 » Wed Aug 19, 2020 10:25 am

Hi just downloaded this sample lay sheet...it's just what I want for laying greyhounds...however I would like to lay the fav at BFSP is this possible..if not is it possible for me to lay at say 15 secs...any reply would be much appreciated

http://www.gruss-software.co.uk/Excel/Lay_Favourite.xls
daveat91
 
Posts: 2
Joined: Wed Mar 25, 2020 10:04 pm

Re: Sample Triggered Betting Spreadsheets

Postby xraymitch » Sun Aug 23, 2020 2:11 pm

xraymitch wrote:Brilliant - that has fixed it.

Thanks a million.

8)


Hi Gary,

Thought your last advice had sorted everything.

I have recently started experimenting with your example spreadsheet getMarketDepthExample_Async.xls which works perfectly provided Excel Log Current Prices is always the first Tab Page selected.

By way of an example, the order of Tab Pages for today's (22-08-20) UK Racing are Uttoxeter, York, Sandown, Chelmsford City, and if I wanted the MarketDepth for the 3rd Tab Sandown then it would load the selections etc but all values from cell(Z5) onwards would be filled with 0.00.

I have to delete the 1st and 2nd Tabs to make Sandown the first Tab to get cell(Z5) onwards filled correctly with MarketDepth values.

Any thoughts on what can be done to solve this are much appreciated.

Thanks 8)

PS Apologies for double posting at viewtopic.php?f=1&p=54134#p50232
xraymitch
 
Posts: 410
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Re: Sample Triggered Betting Spreadsheets

Postby GaryRussell » Sun Aug 23, 2020 3:38 pm

I will take a look and get back to you.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Re: Sample Triggered Betting Spreadsheets

Postby xraymitch » Mon Aug 24, 2020 9:01 am

GaryRussell wrote:I will take a look and get back to you.


Much obliged.
xraymitch
 
Posts: 410
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Re: Sample Triggered Betting Spreadsheets

Postby MarkRussell » Tue Aug 25, 2020 10:22 am

Hi,

Gary's example was only designed to work with one tab page.
I have updated it to use multiple tab pages linked to different Worksheets so that you can link the different venues to their own sheets and have the market depth on each sheet.
I've set it to allow for 6 venues but you could add more.
It's very important that when you link Betting Assistant to this Workbook that you link the tab pages in order.
When you open the Workbook you will see I have named the sheets venue1, venue2, etc
And when you do the linking you must use venue1 for tab page 1 and venue2 for tab page 2 etc.
This is because the VBA sitting behind each Worksheet sets the COM tabIndex property before calling the getMarketDepth function so that it knows which tab page the getMarketDepth relates to.

Download the Workbook using the following link:-
http://www.gruss-software.co.uk/Excel/getMarketDepthExample_Async_multisheet.xlsm

Regards,
Mark
User avatar
MarkRussell
Site Admin
 
Posts: 1787
Joined: Tue Feb 20, 2007 6:38 pm
Location: Birmingham

Re: Sample Triggered Betting Spreadsheets

Postby xraymitch » Wed Aug 26, 2020 5:05 pm

Hi Mark,

Gary's example was only designed to work with one tab page.
I suspected that might be the case and tried to amend it but it was beyond my basic VBA skills.

Big THANKS for taking the time to update the code which also gives me further examples to learn from.

regards
8)
xraymitch
 
Posts: 410
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Re: Sample Triggered Betting Spreadsheets

Postby NorthView » Wed Feb 24, 2021 2:52 pm

Hi Gary/Mark

I've followed the steps above on my Win 10 laptop with Excel 365...

Downloaded the multisheet xls from the link
Removed and reinstalled the latest BA (49c)
Registered the dll in a cmd prompt as above
In Excel365 Options/Add-ins: Manage COM Add-Ins, Go. selected C:\Program Files (x86)\Betting Assistant\BettingAssistantCom.dll, but get error message "C:\Program Files (x86)\Betting Assistant\BettingAssistantCom.dll not a valid Office Add In".

Please can you help?
NorthView
 
Posts: 172
Joined: Wed Oct 08, 2008 12:33 pm
Location: London

Re: Sample Triggered Betting Spreadsheets

Postby NorthView » Wed Feb 24, 2021 5:08 pm

Ok, I think I've realised that registering the dll via the cmd line does away with the need to Add it in via Excel, because it's connected to a racing market and logging prices without error.
NorthView
 
Posts: 172
Joined: Wed Oct 08, 2008 12:33 pm
Location: London


Return to Help

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 18 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.

cron