Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    boflhusr is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2020
    Posts
    10

    Given a stock market symbol, how do I retrieve current price data from the web?

    I did a google search before posting here but I could not find a solution.

    Is this even do-able? From what website (eg. finance.yahoo.com?) and how does one enter the price data of the stock (eg. ibm) in an Access 2013 field? Thank you.

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    2,487
    Do it in Excel (https://www.engadget.com/2019/06/05/...k-data-nasdaq/) then link the Excel file in Access.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    boflhusr is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2020
    Posts
    10
    Quote Originally Posted by Gicu View Post
    Do it in Excel (https://www.engadget.com/2019/06/05/...k-data-nasdaq/) then link the Excel file in Access.

    Cheers,
    @Gicu, thank you. I went to the link. Not much info there, and the link mentions Office 365 only. Will it work with Excel 2013?

    I hope so. I've been upgrading since Lotus 123 and dBase days and I'm simply done with upgrades (except for the OS).

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    2,487
    For Excel 2013 try this (I have a Google sheet with live stock prices and it works great):
    https://www.vertex42.com/ExcelTempla...ck-quotes.html
    or you can try to link the Google sheet directly into Access:
    https://www.access-programmers.co.uk...tabase.260840/
    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,619
    I put a sample in the sample database section a few years back BUT, as it states in the thread, yahoo has changed its set up since then.

  6. #6
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    2,487
    Just tried and the solution in this link does work OK, a bit too many steps but I do have an Access file with stock data provided by Google finance via Google spreadsheets + Excel (linked in Access):
    https://www.vertex42.com/ExcelTempla...ck-quotes.html

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  7. #7
    boflhusr is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2020
    Posts
    10
    Quote Originally Posted by Gicu View Post
    Just tried and the solution in this link does work OK, a bit too many steps but I do have an Access file with stock data provided by Google finance via Google spreadsheets + Excel (linked in Access):
    https://www.vertex42.com/ExcelTempla...ck-quotes.html

    Cheers,
    @Gicu, thank you. I scanned the articles(s). Nowhere does it mention the Excel version. Would you know if it works in Excel 2013?

  8. #8
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    2,487
    Yes, I used Excel 2013 and it worked.
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  9. #9
    boflhusr is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2020
    Posts
    10
    Looks involved but I'll check it out. Thank you!

  10. #10
    samsquared is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    May 2021
    Location
    St. Augustine, FL
    Posts
    8
    I finally got this to work in Excel 2010 although it took some persistence because of script errors when I tried to enter the web link. I found no way to force Excel to use Chrome (default app) or EDGE. Thanks!

  11. #11
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    1,009
    I get Stock prices via Excel and a website and I just use a connection?
    Please, please use # when posting code snippets.
    Cross Posting Etiquette: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?search_query=debug+access+vba



  12. #12
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,619

  13. #13
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,486
    I like this add in for securing up to the minute stock prices

    https://www.michael-saunders.com/sto...ages/info.html

  14. #14
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,619

  15. #15
    samsquared is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    May 2021
    Location
    St. Augustine, FL
    Posts
    8
    Alan's link does at least do away with the Google docs portion, but I assume that the excel spreadsheet needs to remain open so that Access can get the values. I'll give it a try - thanks.

    Difficult to believe that it can't be done directly in Access...

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 04-02-2019, 06:45 AM
  2. Market Data Retrieval
    By Grefcon901 in forum Access
    Replies: 16
    Last Post: 04-07-2016, 01:59 PM
  3. Replies: 22
    Last Post: 12-20-2015, 02:46 AM
  4. Replies: 1
    Last Post: 07-11-2012, 01:42 PM
  5. Calculating Current Stock in Inventory/Warehouse
    By yohansetiawan in forum Access
    Replies: 5
    Last Post: 03-14-2012, 09:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums