As seen in the attached file, I have a list of several hundred public companies that I need to pull price performance data for. So far, I've been pulling data from barchart.com manually, but it's becoming tedious. Is there a way I can automate the process by pulling the 6-month, 1yr, and 3yr price % change?
what method are you using to pull it now?
Hi Adam,
I've been just going to barchart.com. For example, for aapl, I used https://www.barchart.com/stocks/quotes/AAPL/performance. I took the percent chnnge value for 6 month, 52-week, 3 year and manually fill in the blanks.
Actually the purpose of my question was to say are you copying and pasting the data from the web page to excel? Or are you querying the data manually by pushing buttons in Excel and using menus like for instance the get external data tab in the ribbon or power query? That's what I meant. I'm on a phone at the moment and just looking at the web page, it looks like some sort of table but you can't be sure unless you view the client source code of the page. Once you do that you would be able to tell if you could use get external data in the ribbon in Excel or power query to pull the data into Excel automatically because those features pull from grid type oriented structures on web pages whether they be HTML tables or not. The data doesn't necessarily have to be inside HTML table tags although that is the most commonly recognized structure that Excel accepts. I believe.
As an alternative, I would prefer using "Google Sheets" for this...
For example, the following formula gets the last stock price for APPLE;
Please Login or Register to view this content.
and, this one gets the highest price of APPLE in the current session;
and you have many other options to query ...Please Login or Register to view this content.
Last edited by Haluk; 12-01-2020 at 06:09 AM.
I don't understand your logic. Because in your file their is no any dates?
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
@avk; "date" is current day or the last date where there is available data.
You may find this link interesting. I have been using this for about a year to track particular stocks.
http://www.michael-saunders.com/stoc...ages/info.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Adam - I've just been copy and pasting so far.
Well obviously that won't work :-) do you know how to check the source code to a web page? And have you tried using power query or the other method in the menu options that I gave you previously?Originally Posted by fpkid1
Adam, I Know how to check the source code of a web page (I'm using chrome), but I'm pretty new to excel so I'm unfamiliar with the other steps. When using power query am i only able to pull from one web page at a time? Since I have a few hundred stock tickers that each need to be looked up separately could power query do that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks