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.
Bookmarks