Excel basics

**arwar** · 12-20-09, 03:30 PM

here's a few I have on one of my drives. PM me if you are interested

13,521,915 Escape from Excel hell - Fixing Problems in Axcel 2003, 2002, and 2000; Loren Abdulezer (Wiley, 2006).pdf
20,584,989 Excel 2003 Bible; John Walkenbach (Wiley, 2003).pdf
11,497,747 Excel 2003 Formulas; John Walkenbach (Wiley, 2004).pdf
12,388,513 Excel 2003 VBA Programmer's Reference; Paul Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg (Wrox, 2004).pdf
3,113,578 Excel as Your Database; Paul Cornell, Jr (Apress, 2007).pdf
29,171,438 Excel by Example - A Microsoft Excel Cookbook for Electronics Engineers; Aubrey Kagan (Newnes, 2004).pdf
33,025,731 Excel for Scientists and Engineers - Numerical Methods; E. Joseph Bill0 (Wiley, 2007).pdf
8,819,436 Excel Hacks - Tips & Tools for Streamlining Your Spreadsheets, Second Edition; David, Raina Hawley (O'Reilly, 2004).pdf
8,179,930 Excel VBA Programming for the Absolute Beginner; Duane Birnbaum (Course Technology, 2002).pdf
8,332,145 Excel Workbook For Dummies; Greg Harvey, PhD (Wiley, 2006).pdf
16,263,379 Formulas and Functions With Microsoft Excel 2003; Paul McFedries (Sams, 2005).pdf
8,021,101 How To Do Everything With Microsoft Office Excel 2003; Guy Hart-Davis (McGraw-Hill, 2003).pdf
19,652,162 Mastering Excel 2003 Programming With VBA; Steven M. Hansen (Sybex, 2004).pdf
13,794,374 The Visibooks Guide To Excel 2003.pdf

**williams22** · 12-20-09, 03:35 PM

Anything by John Walkenbach is a great start. Anything he writes is basically the gospel when it comes to Excel. If you ever need help with anything please feel free to PM me.

**Joe Dogs** · 12-20-09, 05:04 PM

Thanks guys most appreciated.

**20Four7** · 12-20-09, 06:32 PM

What about getting a spreadsheet to scrape the lines from pinny and load it into a spread sheet. I'm assuming that would be utilizing some VBA programming?

**Wrecktangle** · 12-21-09, 10:19 AM

Originally posted by 20Four7

What about getting a spreadsheet to scrape the lines from pinny and load it into a spread sheet. I'm assuming that would be utilizing some VBA programming?

Seems Excel would be a poor tool for this.

But if the only thing you have is a hammer, everything pretty much looks like a nail.

**williams22** · 12-21-09, 05:55 PM

Originally posted by 20Four7

What about getting a spreadsheet to scrape the lines from pinny and load it into a spread sheet. I'm assuming that would be utilizing some VBA programming?

I think it could be done (assuming Pinnacle uses the same URLs for their picks pages each day), but it would probably be pretty ugly.

**esasky** · 12-24-09, 01:47 PM

Originally posted by williams22

I think it could be done (assuming Pinnacle uses the same URLs for their picks pages each day), but it would probably be pretty ugly.

it's actually easy to do this with Excel (you have to download from Pinnacle using Microsoft web query. The data will show up in an Excel sheet in raw form--you would then have to parse the data that is relevant (possibly on to another sheet).

**big0mar** · 12-25-09, 01:33 PM

Couldn't you use XML for that?

**williams22** · 12-25-09, 01:54 PM

Originally posted by esasky

it's actually easy to do this with Excel (you have to download from Pinnacle using Microsoft web query. The data will show up in an Excel sheet in raw form--you would then have to parse the data that is relevant (possibly on to another sheet).

I've looked at it and it would be a rather cumbersome project. Not impossible, but to say it's rather easy would be a stretch.

**esasky** · 12-25-09, 01:58 PM

Originally posted by big0mar

Couldn't you use XML for that?

You could , but I find it much easier just to copy and paste the URL line for Pinnacle Odds. Also, you have to be logged out of Pinnacle.

I built a system (using only Excel) that automatically downloads the 1) the lines from Pinnacle and 2) the Matchup's page from Covers (MLB/NHL only). I use it to try and identify a positive EV.

Each URL for each Matchup in Covers is the same except for a unique number to identify that particular matchup.

Saturday's Columbus at Detroit URL is:

covers.com/pageloader/pageLoader.aspx?page=/data/nhl/matchups/g2_summary_18.html

For Philadelphia at Carolina, just change the 18 to 17. etc.

So you have use to use just a little VBA code to change the parameters for each matchup.

**esasky** · 12-25-09, 02:05 PM

Originally posted by williams22

I've looked at it and it would be a rather cumbersome project. Not impossible, but to say it's rather easy would be a stretch.

Not a stretch at all--it depends on your knowledge level of Excel..

**arwar** · 12-27-09, 12:17 AM

I download & scrape Pinny lines several times a day, but I don't use Excel, VBA or anything by Microsoft. By outputting the results into a comma delimited file and saving it with a .csv extension, it is already an Excel spreadsheet. It is just my preference - just as I know people who prefer to do word processing in Lotus 1-2-3.

**andrewharry** · 03-08-11, 02:50 AM

Hey that's a great collection for excel. I am looking for some service or tool to import my business data directly into excel and in appropriate format does any version of excel has this feature that I desire I have found market data excel but don't know much about it. Is there any thing else to go with.