+ Reply to Thread
Results 1 to 2 of 2

Power Query and parameter Passing - Excel 2010

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    346

    Power Query and parameter Passing - Excel 2010

    Dear Experts,

    I am trying to create a live trade screener for home use

    1. the URL https://in.tradingview.com/screener/ I need get it from power query but it is not coming.
    2. Then I need to pass value to search box of the URL from excel.

    My query: Why is power query returning no data
    Can anyone help me get this from VBA in LIVE MODE

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Power Query and parameter Passing - Excel 2010

    Look at this link and scroll down to "Power Query Web Limitation"

    I don't believe that the data you are trying to get is formatted as a table while it appears to be in HTML format. Hopefully, someone else with more web experience can comment on this.

    https://www.myonlinetraininghub.com/...th-power-query
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create a Parameter Query for US Stocks in Power Query
    By alansidman in forum Tips and Tutorials
    Replies: 0
    Last Post: 10-24-2020, 06:36 AM
  2. [SOLVED]Excel 2010 Passing form control as parameter fails
    By tfurnivall in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2014, 01:03 AM
  3. Passing Excel Parameter to ODBC mysql query
    By bearclaw in forum Access Tables & Databases
    Replies: 3
    Last Post: 01-18-2013, 05:13 PM
  4. Using Parameter Query in Excel 2010 Report
    By Helal in forum Excel General
    Replies: 0
    Last Post: 10-03-2012, 11:04 AM
  5. Passing date parameter in sql query
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-09-2011, 03:47 AM
  6. passing parameter to a ms query
    By redf1re in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-07-2006, 06:45 PM
  7. Passing parameter to a query
    By Dwaine Horton in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-25-2005, 10:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1