+ Reply to Thread
Results 1 to 3 of 3

Scrapping Data from a website

  1. #1
    Forum Contributor
    Join Date
    07-10-2019
    Location
    england
    MS-Off Ver
    2013
    Posts
    486

    Scrapping Data from a website

    Hi,
    I am trying to retrieve price history of stocks from this website
    https://www.tdameritrade.com/search/results.page?q=fran
    The above link, i searched for Fran

    The below are the links of Api of this website
    https://developer.tdameritrade.com/p...D/pricehistory
    https://developer.tdameritrade.com/p...D/pricehistory

    I want to create a macro to scrap details?
    is it possible?

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Scrapping Data from a website

    Do you have login details, as requested by the API?
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    07-10-2019
    Location
    england
    MS-Off Ver
    2013
    Posts
    486

    Re: Scrapping Data from a website

    Hi Olly,
    Nope, i dont have.. But the user has.. He asked me whether in the excel file taking the cell as input, create a macro for scrapping..
    So the macro can take the input from the file..
    Due to confidentiality, he didnot disclose..
    I am not very much familiar into scrapping..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Very weird problem with Data Scrapping VBA (works randomly)
    By KomicJ in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-12-2018, 02:31 PM
  2. VBA help in web scrapping
    By dvnr_76 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2016, 03:25 AM
  3. website scrapiplping to get data from multiplepages of website
    By mpatil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2015, 05:00 AM
  4. Scrapping column data from a different unopenned workbook.
    By Ghosted in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-08-2015, 12:21 PM
  5. Web Scrapping
    By shivu98 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-22-2014, 08:03 AM
  6. Web Scrapping Help
    By Spyderz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2012, 12:33 PM
  7. Opening website, getting data, closing website
    By beta_leonis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2012, 03:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1