• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Website Power Query: Invoke different ticker symbols|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Website Power Query: Invoke different ticker symbols|Power Query|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumPower QueryWebsite Power Query: Invoke differe…
sp_PrintTopic sp_TopicIcon
Website Power Query: Invoke different ticker symbols
Avatar
Tim Leija

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
September 9, 2021
sp_UserOfflineSmall Offline
1
September 9, 2021 - 4:32 am
sp_Permalink sp_Print

I want to make the web work versus going the API route. The website is static with the ticker symbol on the end of web address. I added the fx to invoke different ticker symbols (picture attached). The only ticker symbol it works with is the one I started with. I cannot invoke new ticker symbols of companies. I get the error that column 20 is missing or invalid. 

Endstate: I want to type it a ticker symbol and pull a small amount of information from the financial statements. Ticker-Capture.PNGImage Enlarger

Anticipated-End-State-of-a-successful-Power-Query.PNGImage Enlarger

sp_PlupAttachments Attachments
  • sp_PlupImage Ticker-Capture.PNG (118 KB)
  • sp_PlupImage Anticipated-End-State-of-a-successful-Power-Query.PNG (66 KB)
Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4447
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
September 9, 2021 - 10:12 am
sp_Permalink sp_Print

Hi Tim,

Welcome to our forum! Try removing the 'Changed Type' step to see if that fixes the issue.

Mynda

Avatar
Tim Leija

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
September 9, 2021
sp_UserOfflineSmall Offline
3
September 9, 2021 - 9:44 pm
sp_Permalink sp_Print

I removed 

in

 #"Changed Type"

And now I can't get past the error Expression.SyntaxError: Token in Expected.

By the way, I'm a super newbie to PowerQuery and I'm very grateful I stumbled upon your Youtube channel. 

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4447
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
4
September 10, 2021 - 1:07 pm
sp_Permalink sp_Print

Are you able to share your file? It's difficult to troubleshoot without seeing the file.

Avatar
Tim Leija

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
September 9, 2021
sp_UserOfflineSmall Offline
5
September 20, 2021 - 7:48 am
sp_Permalink sp_Print

Here is my file. Ticker is on first tab. It works with AAPL, when I built it. It won't work with other tickers. I prefer it to just have the columns on tab 1 that I manually enter. But if I can only pull full table, then I will use VLOOKUP or other formula to assist. 

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4447
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
6
September 20, 2021 - 10:05 am
sp_Permalink sp_Print

Hi Tim,

Thanks for sharing your file. Unfortunately, the website structure is not consistent which means the table numbers you need to extract vary depending on the ticker. FB it's Table1 and for AAPL it's Table2. That's going to be very difficult to automate unless you know the table numbers in advance.

e.g. the third step in the query; Data2 is = Source{2}[Data] for AAPL and = Source{1}[Data] for FB

You could add this as another variable, but I'm not sure how you're going to be able to keep track of that.

Mynda

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Catalin Bombea, Aislinn Mellamphy, Lynnette Altomari, Roy Lutke, Dieneba NDIAYE, Tucker Oakley, Natasha Smith
Guest(s) 12
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 202
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Sopi Yuniarti
sandra parker
LAFONSO HERNANDEZ
Hayden Hao
Angela chen
Sean Moore
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Forum Stats:
Groups: 3
Forums: 24
Topics: 6215
Posts: 27244

 

Member Stats:
Guest Posters: 49
Members: 31894
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.