Results 1 to 21 of 21

Powerquery data extraction from website question

Threaded View

  1. #3
    Forum Contributor
    Join Date
    06-04-2014
    Location
    Nevada, USA
    MS-Off Ver
    2019
    Posts
    345

    Re: Powerquery data extraction from website question

    Morning, AliGW,
    Sorry about the way I wrote that post.
    I am looking for someone to guide me here.
    When I mentioned "detailed instructions" I said that because I did not want someone to fix the sheet and have me thank them.
    I am into working towards the goal thing - ie using something I understand (the finviz.com) site, to make a tedious job easier - which adds to my understanding of PQ.
    I don't subscribe to this site. So, no one needs login credentials. I have not reached that level of expertise or insanity - yet.
    It is just a great site with a lot of free information.
    All that data, on that site, is available for free - unless you select the "Custom" option (that's when you have to subscribe to the site and have a login and password).
    It also has a lot of pop up ads.
    I want to bring the free data onto an excel sheet so that I can look at it in peace.
    For example, accessing the information for all companies in an industry will enable me to figure out the average price of shares in an industry or figure out how may of the companies pay a dividend. Incidentally, I am no Gordon Gekko or a Wolf of Wallstreet. I am more a sheep of Sesame Street.
    What have I tried?, the trick that Alansidman showed me with the the data on sheet 1. It did not work for me for this purpose.
    So, if you or anyone else can outline a starting point or how I can initiate the process, I'd appreciate it.
    I am reading the book M is for (data) monkey -on Ch2 but so far they are only working with CSV files. My question is about data extraction, transformation of and loading of data from a website to an excel sheet.
    Thank you
    Doofus

    Be back in about 8hrs.
    Last edited by Doofus1; 11-27-2020 at 03:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 10-28-2020, 12:05 PM
  2. [SOLVED] Using Powerquery to import data from a website to an Excel spreadsheet.
    By Doofus1 in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 10-27-2020, 01:17 AM
  3. Data Extraction from Website
    By Cardan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2019, 09:46 PM
  4. Data extraction from Website
    By Cicada in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2018, 04:50 PM
  5. Data extraction from website
    By jose612 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2013, 03:55 AM
  6. data extraction from website to excel spreadsheet
    By wyldjokre69 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-28-2012, 07:01 AM
  7. Navigating a website and data extraction
    By stcanary in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2010, 01:03 PM

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