1. #1
    burrissa
    burrissa's Avatar SBR PRO
    Join Date: 12-22-09
    Posts: 90
    Betpoints: 328

    Anyone willing to teach SDQL to excel queries for dummies?

    Any experts willing to teach us how to set up an excel spreadsheet so that we can run several saved SDQL queries through excel at the push of a button? I'm not asking for your personal spreadsheets or queries, just the basic setup to get excel to run queries. I saw one post on here by Stevenash on how to get queries running using VB. I'm not that strong on VB but know how to record macros. I'm sure several members would be interested. Show us how to fish instead of giving us a fish. Thanks to everyone who's willing to help us entry level students.

  2. #2
    Waterstpub87
    Life-Style Arbitrage
    Waterstpub87's Avatar SBR PRO
    Join Date: 09-09-09
    Posts: 3,170
    Betpoints: 1864

    What exactly does this mean?

    I don't use SDQL, or believe that it is useful, so I don't know what the data looks like. If it is something like find all rows that meet certain criteria, easy to write VBA to get to that. Is there somewhere where you can copy and paste example data?

    If all you are looking for is something to give values based on if cells meet criteria, you might be able to avoid VBA and just write if(and formulas.
    Last edited by Waterstpub87; 07-19-17 at 03:05 PM.
    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 09/13/2018


  3. #3
    burrissa
    burrissa's Avatar SBR PRO
    Join Date: 12-22-09
    Posts: 90
    Betpoints: 328

    I'm wanting to store my queries on the spreadsheet, hit a refresh button and have all the queries ran at once and the data updated on the spreadsheet. I can then manipulate the data in the order I want and make comparison's.

    Here's a query:

    http://sportsdatabase.com/mlb/query?...+S+D+Q+L+%21++


    I tried running it from the data tab and then from web. I entered the link and the web page comes up and shows the query results but will not allow me to import. I get an error message that says "unable to open, cannot download the information you requested".

    Am I totally off base with this?

  4. #4
    Waterstpub87
    Life-Style Arbitrage
    Waterstpub87's Avatar SBR PRO
    Join Date: 09-09-09
    Posts: 3,170
    Betpoints: 1864

    Excel doesn't like something about this site, might be the ... in the webaddess.

    If it liked it, you could script something to by going to a certain webaddress and pulling the data. It might get tricky but it is doable.

    If you could get the data that is underlying these calculations, you could copy paste that into excel, and not have to mess with downloading it. It looks like some of that data is saved in the "Tables" section of the website.
    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 09/13/2018


  5. #5
    mdunlap3
    mdunlap3's Avatar Become A Pro!
    Join Date: 02-18-13
    Posts: 1,295
    Betpoints: 3607

    Hi. I'm no "expert", but I am very comfortable with the syntax of the query language. Do you have any specific questions?

  6. #6
    LtDementia
    LtDementia's Avatar SBR PRO
    Join Date: 08-22-10
    Posts: 203
    Betpoints: 1926

    Ok - I'll jump in but I'm using an old excel 2003 so your mileage may vary.

    On the main menu I follow the menu item(s) 'Data|Import External Data|New Web Query'. This gets to an input window with a place for the sportsdatabase url and the resulting content. Copy the url into to requested url field and press 'go'. The result of the query will populate the contents area of the window. Use the checkboxes to select the tables of interest and press 'Import'. There might be one more one more popup but its self explanatory. Your worksheet will now be populated with the results of the query.

    By default, the request is saved and can be re-run by right-clicking on the data and selecting 'refresh'

    Enjoy-

    LT

  7. #7
    burrissa
    burrissa's Avatar SBR PRO
    Join Date: 12-22-09
    Posts: 90
    Betpoints: 328

    Hi LT,
    Thanks for jumping in. If you read the second half of my post #3 you'll see I tried that but it won't import the data. I have other spreadsheets that are automated in this fashion (same as your instructions)but none are trying to import data from a database query. I'm working nights this weekend so I'll keep trying next week. Thank you for jumping in and responding.

  8. #8
    Optional
    Optional's Avatar Moderator
    Join Date: 06-10-10
    Posts: 34,970
    Betpoints: 5211

    Sportsdatabase.com offers an API to extract the data you need http://www.sportsdatabase.com/api

    You can find instructions on that page and a link to a discussion group for help at the bottom.

    SBR
    Forum
    Mod
    Squad

    $20
    Angelman
    donation 02/15/2018

    SBR Bash
    Punta Cana
    Attendee 2/4/2017


  9. #9
    Optional
    Optional's Avatar Moderator
    Join Date: 06-10-10
    Posts: 34,970
    Betpoints: 5211

    Also, if you are importing loads of data and doing a lot of recalculations you will quickly find that you need a supercomputer to run Excel fast enough.

    SBR
    Forum
    Mod
    Squad

    $20
    Angelman
    donation 02/15/2018

    SBR Bash
    Punta Cana
    Attendee 2/4/2017


  10. #10
    Waterstpub87
    Life-Style Arbitrage
    Waterstpub87's Avatar SBR PRO
    Join Date: 09-09-09
    Posts: 3,170
    Betpoints: 1864

    Quote Originally Posted by Optional View Post
    Also, if you are importing loads of data and doing a lot of recalculations you will quickly find that you need a supercomputer to run Excel fast enough.
    Depends on how much you to import. I built a scraping program in excel for college football play by play results. Takes around 45 minutes to scrap 150 games or so. I do have a decent, but older, computer.
    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 09/13/2018


  11. #11
    advantageU
    conor wants rematch
    advantageU's Avatar SBR PRO
    Join Date: 06-11-17
    Posts: 186
    Betpoints: 194

    Quote Originally Posted by Waterstpub87 View Post
    Depends on how much you to import. I built a scraping program in excel for college football play by play results. Takes around 45 minutes to scrap 150 games or so. I do have a decent, but older, computer.
    Is this something you would be willing to share with the forum or with me in private?

    BTP
    Week 2
    3-2-0 225 pts


  12. #12
    Waterstpub87
    Life-Style Arbitrage
    Waterstpub87's Avatar SBR PRO
    Join Date: 09-09-09
    Posts: 3,170
    Betpoints: 1864

    Quote Originally Posted by advantageU View Post
    Is this something you would be willing to share with the forum or with me in private?
    Yea, Ok
    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 09/13/2018


Top