Using Powerquery to import data from a website to an Excel spreadsheet.

Take a look at this link. I use this to track the stocks I own.

http://www.michael-saunders.com/stoc...ages/info.html

See if this does what you are asking. It goes to the web site in question and brings up the information from that site for the Symbol you type in M2. You can review the Mcodes for both tables by clicking on View in the PQ Editor and then selecting Refresh All Button. I don't build graph charts so you will need to seek out others for that help.

I have been working on getting the second table imported through Power Query when you select the Ticker. I don't believe you can bring the graphic chart into PQ.

Attached is the updated file with instructions. It required building a Parameter table in Column A of Sheet2.
Here is the Mcode for that table which is closed and loaded to a connection only

Please Login or Register  to view this content.

Next I input the variable name of the query into the Path of the table I wished to get

Please Login or Register  to view this content.

It has been a great learning experience for me to figure this one out.

Hi Alansidman,
First, thank you for taking the time to work on this.
This is what I am after.
The chart is not as useful as this.
So, lets forget the graph.
I'd like to work with this.
So, as long as I enter any stock abbreviation/symbol (available on this site) in cell A3 and hit refresh, the data will populate into cells D1 through O13.
However, when I enter a stock abbreviation in A3 and select "Refresh All" (under the DATA tab), I get a message that I don't understand.
I have uploaded a PDF of the screenshot.
What am I doing wrong?
Thank you
Doofus.

Don't know why. It obviously works for me. Suggest you try and rebuild it yourself using my Mcode as a guide. It may have to do with the connection table not passing with the file. You have all the pieces to make it work. You just need to replicate it all in a new file.

Hi Alansidman,
I am now on an old computer that is running Excel 2010.
At work it is the most recent version of Excel.
I downloaded the document at work and tried but failed.
What am I missing?
I go to the POWERQUERY tab, FROM OTHER SOURCES > BLANK QUERY > ADVANCED EDITOR > copy and paste both your codes in the advanced editor

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

And I get a message that reads:

Expression.SyntaxError: Token Eof expected.

What am I dealing with ?

Please note that I am not very Powerquery savvy.
Thank you
Doofus

Doofus - please add code tags to your post as per the forum rules. Thanks.

No further help to be offered until this is done.

Hi AliGW,
Ok. I am dumb.
I go to edit post and select # tags before and after areas containing the code, but I don't see a difference in appearance after I post a quick reply.
Duh! I feel really dumb.
Thank you
Doofus.

1. Select the text that is code.
2. With the text selected, click the # icon on the toolbar.

Perfect!

Can you attach a file that displays the syntax error you refer to? It usually means there's a comma missing at the end of a line.

The code given by Alan is for two queries, as per the sample sheet he attached. You have tried to put them together into one query, hence the problem.

I won't be here in 8 hours - I'll be offline by then.

Here is step by step instructions attached. I am using Excel 2019, so the pictures may look a little different but you should be able to handle it.

Suggest if you are going to play in the PQ arena, you get a copy of "M is for (Data) Monkey" by Ken Puls and Miguel Escobar. It is an excellent primer to learn PQ.

I replaced your first line of Mcode with mine. I suspect it was a spacing within the URL. It works for me now.

Hi Alansidman,
Could the issue come from the website address?
The address https://finviz.com/quote.ashx?t=AAON&ty=c&ta=0&p=m&b=1 is for a monthly / 5year chart
The address https://finviz.com/quote.ashx?t=aaon is probably the daily chart.
Thus, would using the second web address be a better fit for getting the data to populate into the relevant cells once a stock ticker symbol is entered in cell A2?
But my immediate problem is that since we are only using the data in Table 0, I still cannot figure out how to enter the stock ticker symbol in cell A2 to get the Table 0 data to automatically populate into cells D1 through O13.
I have uploaded another Excel 10 spreadsheet with the initial data entered onto it.
If you (I know I've tried your patience) or anyone else is willing to look at this again, I'd appreciate it.
Thank you
Doofus

I really don't understand your issue. Everything works for me. Perhaps it is time for you to learn PQ from the start figure this out. Everything you have given me works for me so I don't understand what you need. There is nothing more I can offer you.

@Doofus1

I downloaded and ran it with different Ticker Symbols. Works perfectly for me. No errors. No issues.

Thoughts and not necessarily solutions

1. Your versions of Excel/Power Query are corrupted? Maybe reinstall/run repairs?
2. Older versions of PQ are not compatible with later versions? Not aware if this is true, however.

This is the best I can offer as it does work with my version of Excel and PQ.

I have done a little bit of research and wonder if it is your privacy settings. Read excerpt below that I pulled from another site

This error happens because you are trying to access data from two different Datasets . I was able to fix this issue by setting Privacy Levels under File > Options and Settings > Options > Privacy.


Once there, set the settings to "Always Ignore Privacy Level Settings"

Hi Alansidman,
YES!!!!
That is the trick!!!!
I apologize for being a pest but I probably have a compulsive disorder too.
Thank you!! Thank you!!! THANK YOU!!!!
Best
Doofus.