by JIFFIJAW » Sat Aug 09, 2008 10:37 pm
Hi All, Gary has posted a sample triggered betting example that additionally gets the Racing Post Tissue price by each selection. I'm a complete dummy at getting data from internet sites and have to rely on cutting and pasting and then sorting and then getting the BA Excel page to go and look up the horses name (having converted the RP name to the BF format -- no apostrophes, no days since last run, etc) and add the cut and pasted information to my selection calculations for the given race. How hard would it be to additionally get the RPR and the jockey name direct on to the BA Excel worksheet??
Gary refers to the winhttp commands and the relevant cell has "getTissuePrice(a5)" etc as the formula -- but what coding makes that "work". I'm happy to go and learn how to do this myself if someone can point me at what it is I should be looking at -- where do you learn how to do this kind of automated internet to Excel lookup and gather function?
JIFFIJAW -- I'm not a complete idiot - some parts are still missing