I am trying to retrieve data on Mutual Fund NAV's using "Get Data from Web" on the data tab. I would post the link that I am using but I am not allowed to post it since i have not posted a "few times". It is a link to NASDAQ.
It is working but it puts the data for each new mutual fund on a separate worksheet. Is there a was with either use this query or any other query that all of the required information would be placed on a single worksheet?
If you type out the URL, we can see specifically what you are looking at and then attempt to assist. Do not try and cut and paste the URL
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
You are not allowed to post any kinds of links, images or videos until you post a few times.
I tried to put it with my original question but received the message that I could not post url's, vidoes, etc until I had posted more to this site. So I will try to post something that looks like what I was using
xxx.hasdaq/symbol/?????
type it out manually, ie.and wrap it in code tags
Please Login or Register to view this content.
I am typing in manually. I am not copying. And, I am told that I cannot post what I type. See above. I also do not know what wrap it in code tags means. I would appreciate some help but it appears that there is no way to get my problem posted until I post a few times and if I can't post my problem, I do not know how I am going to get those few posts done.
Type it with gaps instead of the slashes and put spaces either side of the dots.
You do not yet have enough posts to be allowed links.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
www . nasdaq . com symbols dodgx
this works when I use it but each time that I change the symbol it puts the information on a new worksheet. I am trying to get multiple entries on a single worksheet. Is this possible?
corrrect URL is https://www.nasdaq.com/symbol/dodgx
Using Power Query, I was able append what I thought were significant tables. Here is what it looks like.
Data Range
Is this what you are trying to do? If not suggest you show us what you want as at this point we are only guessing. If this is the case, then post back and I will post the Mcode that achieved this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks