Full Market Depth Excel

[Lewis]

Hi, just looking for a shortcut to an answer before I go and get confused with my limited knowledge of programming.

I would like to be able to view the full market depth [or if not full at least the nearest 10 prices, rather than just 3] in excel. As BA does not currently do this I was looking for the easiest workaround and was wondering what would be the best/easiest option. I turn a scalping bot on the pre-race horses so need vast execution of orders however I can accept slower refreshes of the full market data.

1) is this available through COM interface [I don't think it is but just to check].

2) Use Gruss w/ excel as my 'execution' platform for orders to benefit from Full API access, and general speed of BA transactions, and write my own basic API bot which simply writes the 'full' prices to another sheet [even if it is less efficient at retrieving prices / refreshes slower].

3) Attempt to use some of the libraries available online through the Betfair Developer Program.

I have relatively little programming experience however I am happy to learn as I have free time over summer this year. I feel that 2 may be possible as I could learn to code something basic but I get the impression writing efficient code for fast refreshing software would be beyond my means.

I guess a third option would be to outsource some of the coding and if that was the case what would be a reasonable price range for number 2 [I appreciate this is not Find a Developer but this is just a small aside].

Thanks in advance and please let me know if my questions don't make sense or if I am just expecting to be spoon fed,

[GaryRussell]

It's available through the COM interface. See http://gruss-software.co.uk/forum/viewtopic.php?t=3825

[Lewis]

Cheers Gary excellent support as always, I guess I didn't read the documentation fully or did not appreciate what I was reading.

Apologies in advance for my inevitable failure to use the COM interface over the next week.

[Lewis]

I appreciate that you do not 'support' the COM interface in the same manner as the full program so I will try to keep this request brief.

I have proceeded with the steps in the User guide to set up the COM interface, creating a config file, enabling com interface in BA, ensured that the 'references' include BA.

I then downloaded the getMarketDepthExample_async.xls spreadsheet and connected it to BA through the normal 'log prices in excel'. It has continued to log the normal excel data as normal however the full depth from column Z onwards has not updated.

My question is whether this code should automatically update the prices [in which case I am having a problem somewhere else] or if I need to somehow 'call' the sub ba_getMarketDepthComplete...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.Count = 16 Then
If ba Is Nothing Then
Set ba = New BettingAssistantCom.ComClass
End If
ba.getMarketDepth False
End If
End Sub

[Other potential problems is that this is excel 2010, running on a remote desktop, i believe however that the IP should still be 127.0.0.1 and port 8000, is it possible that the port has been closed?]

All I am attempting to do is to 'scan' the market through COM if necessary to get price/volume into excel and then to use the 'normal' excel triggers that I have been using for a number of years to actually automate - should this be possible with the async example sheet?

Thanks again as I realise I may be making a very novice error.

[GaryRussell]

We've been having issues with a few users recently where the problem is that the event for the price update is not firing. This is due to the COM server not been registered properly. Please try the following.

1) Close BA and Excel and make sure not running in task manager.

2) Run the following utility which will remove all entries from the registry.
http://www.gruss-software.co.uk/Betting ... gistry.exe
Just click the start button and it should shortly display "Done"

3) Uninstall BA and then re-install from the following link.
http://www.gruss-software.co.uk/Betting ... t_Beta.msi

[Lewis]

As ever Gary, fantastic support - the registry cleaner has fixed the problem and I now have a functioning com link - excellent.

And a reply at 6am on a saturday - if only all companies had service like that.


[If anyone else on a remote server is attempting this you may run into problems trying to run the file provided. Due to account settings limiting what you may alter [not a true administrator] you may have to actually save the file and run it from your computer so that it does not block it as coming from the internet rather than simply clicking the link and running it automaticlaly].

[4everlost]

G'day all
I've been trying to get getMarketDepthExample_async.xls spreadsheet to fire up, with no success. I've tried the solution Gary provided above to no avail. I even tried another suggestion to use port 8001, still no luck.
I have created an Excel.exe.config file (definitely not a text file) with <configuration>
<startup>
<supportedRuntime version="v2.0.50727"/>
<supportedRuntime version="v1.1.4322"/>
</startup>
</configuration>
This is running on a 64 bit win 7 pc, with Office 2010 home & student (not click & run or starter pack)
Any help appreciated.

[doris_day]

Having the same problem as 4everlost. Sadly if I cant find a solution I'll have to find another software for my needs.

[GaryRussell]

Are you using the Beta version?

[Graham]

G'day all
I've been trying to get getMarketDepthExample_async.xls spreadsheet to fire up, with no success. I've tried the solution Gary provided above to no avail. I even tried another suggestion to use port 8001, still no luck.
I have created an Excel.exe.config file (definitely not a text file) with <configuration>
<startup>
<supportedRuntime version="v2.0.50727"/>
<supportedRuntime version="v1.1.4322"/>
</startup>
</configuration>
This is running on a 64 bit win 7 pc, with Office 2010 home & student (not click & run or starter pack)
Any help appreciated.

There was a thread a while back, where Gary advised the following when using the COM interface on a 64 bit machine:

I've just managed to get it working on a 64 bit PC. The following solution worked. Please let me know if it works for you.

1) Open a DOS command window.

2) Navigate to C:\Windows\Microsoft.NET\Framework64\v2.0.50727

3) Enter the following and press enter.
regasm /codebase "c:\program files (x86)\Betting Assistant\BettingAssistantCom.dll"

Link to thread is here:

http://www.gruss-software.co.uk/forum/v ... php?t=5975


Apologies if you've already tried this, hope that sorts the problem if you haven't.

Graham.

[doris_day]

Thanks Gary. I assumed if I had the latest version it would work but I downloaded from your link and its all ticketyboo and working perfectly.

[Tarmac]

Hi. I never quite managed VBA. Is there an example of a pre coded spreadsheet that I can just hook up to BA and get the full market depth or top 10 prices?? Thanks

Tarmac

[xiaonvren]

I have relatively little programming experience however I am happy to learn as I have free time over summer this year. I feel that 2 may be possible as I could learn to code something basic but I get the impression writing efficient code for fast refreshing software would be beyond my means.