Fully followed and understood. Good job. Trying to take this a step further, I am trying to create a spreadsheet to track my stock market investments. I am using the Excel web version which allows me to track several different types of information on each stock. However, I would like to add RSI and other key indicators which are not available in Excel Web or Office 365. Do you have a formula that can be used to capture specific data for a specific stock (i.e. ticker info keep in A1 as an example) and automatically or manually update all RSI or whatever of the fields desired from FinViz?
How to extract data from the graph besides the table.. I played the video to know that .. but was disappointed 😞 If you can share that I will be very happy .
You can use Functions to extract any cell(s) from the query ... I have designed formaulas to do exactly that and been using for many years. My issue now is the queries from web dat now are complex at least in my 365 Excel version and make simple into overwhelming. =Offset(Match(.... No doubt the new queries can allow that if you can figure it out and write scripts.
That's me, copy and paste the hard way. So I found you and this is easy to understand for how to I can be more productive and I like it that way.
How do I add data to excel from the web when it is not in a table on the web?
Same issue...
I just bought Excel and the ribbon doesn't look like this - and none of these steps works...
for me it just say Document on the site im trying to transfer the data from, is there another way around it ?
Fully followed and understood. Good job. Trying to take this a step further, I am trying to create a spreadsheet to track my stock market investments. I am using the Excel web version which allows me to track several different types of information on each stock. However, I would like to add RSI and other key indicators which are not available in Excel Web or Office 365. Do you have a formula that can be used to capture specific data for a specific stock (i.e. ticker info keep in A1 as an example) and automatically or manually update all RSI or whatever of the fields desired from FinViz?
What if want the entire WEB PAGE data to get imported in excel through this method?? How to do that??
yes I would like to know how to do this as well.
How to extract data from the graph besides the table.. I played the video to know that .. but was disappointed 😞
If you can share that I will be very happy .
thanks! What if i only want to extract One data point from a table?
You can click transform data instead of load to and work with it in power query
Is there a way to extract only one cell from the web's table?
You can use Functions to extract any cell(s) from the query ... I have designed formaulas to do exactly that and been using for many years.
My issue now is the queries from web dat now are complex at least in my 365 Excel version and make simple into overwhelming.
=Offset(Match(.... No doubt the new queries can allow that if you can figure it out and write scripts.
After copying the data I'm not able to format the data