Racing Post tissue doesn't working

[etrader]

Racing Post tissue excel example doesn't working. It seems RP changed the site

[GaryRussell]

I'll have a look when I get some time.

[etrader]

no problem, just keeping you posted

[Daywalker]

it's the url for web changes that's changed. the bit after the date for example on runners index is now "&cardHomeTabs=runner_index"

DW

[GaryRussell]

I have fixed the example. Download it from the following link.

http://www.gruss-software.co.uk/Excel/R ... Tissue.xls

[MiniBlueDragon]

Hi there. I'm planning on using this as a basis to grab other data from Racing Post (Jockey, Form, RPR, Days last ran, Age, Weight etc) to use while developing a system.

Is there a way to add the correct library for this spreadsheet? When I open it I get an error, "Compile error: Can't find project or library" so I assume I need to add the Microsoft HTML library, however as soon as I open the spreadsheet the error occurs and won't let me 'break' or stop it running to add the library. :/

The debug line is "Public Function getTissuePrice(ByVal horse As String) As Double"

Thanks in advance.

[MiniBlueDragon]

EDIT: Figured a way into the spreadsheet and it seems it's missing the library "BettingAssistanCom" as I don't have a beta directory in "C:\Betting Assistant Beta 1_1_0_66x100/BettingAssistanceCom..."

[MiniBlueDragon]

OK I have it working.

The issue is that I'm using the BetDaq software and so I don't have the correct library in the sheet's references list. Using Google I managed to find the following:

http://www.gruss-software.co.uk/Betting ... antCom.htm

That lead me to the installation of the beta and that in turn installed the required library.

Now to wrap my head around getting other info from RP using the methods in this example.

[glomo]

I have connected the example Racing Post spreadsheet to BA though find that whatever UK race I click on the tissue price is not updated accordingly.

Is there something extra that I'm not doing or is it because I use excel version 2003?

Has Racing Post changed their link perhaps?

Glo