Sharps.se - Sveriges bästa sportsbettingforum med rekar, spelförslag och bettingtips - Visa ett inlägg - Automatiskt ladda hem Pinnacles odds i Excel

thom321 · 2011-06-14, 23:58

Gjorde som RobinD sa och här är länken. Ska finnas kvar i 7 dagar om jag förstår rätt.

http://wikisend.com/download/138974/...eed macro.xlsm

Eftersom jag inte vill skriva om min kommentar till mitt ursprungliga inlägg i det andra forumet så har jag kopierat den texten som följer nedan:
-----------------------------------------------------------------

uva's workbook on grabbing Pinnacle's XML feed with Excel gave me an idea to take this a step further by building a workbook that allows the user to create a table with odds for any sport/league that Pinnacle offers odds for and displaying it in a customized format e.g. depending on the sport or event. My goal was to get a working solution, not the prettiest, and in its current version it works for me at least and maybe it can be useful for someone else.

I wouldn't advice using the code I created as a proper way of writing VBA since my focus was on getting something working quickly. When that failed and the task got infinitely more complicated than I envisioned initially, instead of re-writing much of the code, I added some patches here and there to make it work. Hence, the code is very likely not the most efficient way (I know it isn't) but it works fast enough and is flexible enough for me.

I hadn't worked with XML before and I quickly got tired of trying to parse XML the way I assume it was intended. Instead I am simply looping through all the nodes and dumping the resulting columns of data into an Excel sheet and take if from there since I know I can get the data to dance pretty well once I have it in Excel.

If you decide to have a look at it, I suggest that you first read the sheet called "Instructions" (go figure) since it should tell you most of what you need to know to use the workbook. Actually, it tells you a whole lot more than you need to know but I included the extra info in case some of you felt like actually creating your own customized formatting for how the odds are displayed in the workbook.

Definitely works in Excel 2010, works in my version of Excel 2007 and probably works in Excel 2003. If you encounter any problems in running the macros (after having checked the references I list in the Instructions sheet) please let me know. Also, if it seems to run ok but the data looks incorrect I would definitely like to know. I have tested it a fair bit myself but not on all sports or all leagues so there might be some league specific issues that would prevent the data from displaying properly.

Edit by KP
Lade upp en permanent mirror här med http://dl.dropbox.com/u/5799500/Pinn...d%20macro.xlsm

2011-06-14, 23:58	#4
thom321 Reg.datum: apr 2010 Inlägg: 35 Sharp$: 582	Gjorde som RobinD sa och här är länken. Ska finnas kvar i 7 dagar om jag förstår rätt. http://wikisend.com/download/138974/...eed macro.xlsm Eftersom jag inte vill skriva om min kommentar till mitt ursprungliga inlägg i det andra forumet så har jag kopierat den texten som följer nedan: ----------------------------------------------------------------- uva's workbook on grabbing Pinnacle's XML feed with Excel gave me an idea to take this a step further by building a workbook that allows the user to create a table with odds for any sport/league that Pinnacle offers odds for and displaying it in a customized format e.g. depending on the sport or event. My goal was to get a working solution, not the prettiest, and in its current version it works for me at least and maybe it can be useful for someone else. I wouldn't advice using the code I created as a proper way of writing VBA since my focus was on getting something working quickly. When that failed and the task got infinitely more complicated than I envisioned initially, instead of re-writing much of the code, I added some patches here and there to make it work. Hence, the code is very likely not the most efficient way (I know it isn't) but it works fast enough and is flexible enough for me. I hadn't worked with XML before and I quickly got tired of trying to parse XML the way I assume it was intended. Instead I am simply looping through all the nodes and dumping the resulting columns of data into an Excel sheet and take if from there since I know I can get the data to dance pretty well once I have it in Excel. If you decide to have a look at it, I suggest that you first read the sheet called "Instructions" (go figure) since it should tell you most of what you need to know to use the workbook. Actually, it tells you a whole lot more than you need to know but I included the extra info in case some of you felt like actually creating your own customized formatting for how the odds are displayed in the workbook. Definitely works in Excel 2010, works in my version of Excel 2007 and probably works in Excel 2003. If you encounter any problems in running the macros (after having checked the references I list in the Instructions sheet) please let me know. Also, if it seems to run ok but the data looks incorrect I would definitely like to know. I have tested it a fair bit myself but not on all sports or all leagues so there might be some league specific issues that would prevent the data from displaying properly. Edit by KP Lade upp en permanent mirror här med http://dl.dropbox.com/u/5799500/Pinn...d%20macro.xlsm Följande användare gav Sharp$ för den här posten: Gervais (+5), Sonadar (+5), Shell Peppe (+2), hemirg (+1)