+ Reply to Thread
Results 1 to 2 of 2

Receive/Listen webhooks in excel vba OR fetch data from popped-up alert dialogue box

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    240

    Receive/Listen webhooks in excel vba OR fetch data from popped-up alert dialogue box

    Hello!

    I am trying to pull alerts data from tradingview.com which is a stock/crypto charting website in excel for making an alogrithm for trading. I have been searching for a functionality to receive data coming from webhooks and store it in microsoft excel file stored in local computer. I am not even sure if this can be done in vba and need some inputs from you guys on whether this can be done and if yes, please advie where should i begin.

    I also thought of an alternate solution. Instead of listening for alerts via webhook, get a particular string from an alert box that popsup in trading view website in regular intervals. I fetched few things from the browser developer console but unable to get the details in excel. Here is what I get from the popped up alert dialogue box. I am also putting a pic of it.

    Copied JS Path
    document.querySelector("#overlap-manager-root > div > div > div.dialog-2AogBbC7.popupDialog-35doN71j.popupDialog-75kt7HYT.dialog-UM6w7sFp.rounded-UM6w7sFp.shadowed-UM6w7sFp > div > div > div.content-35doN71j > p.content-jnmUvQKm")

    Copied XPath
    //*[@id="overlap-manager-root"]/div/div/div[1]/div/div/div[2]/p[2]

    Copied full XPath
    /html/body/div[5]/div/div/div[1]/div/div/div[2]/p[2]

    Please share some inputs

    Thanks
    Attached Images Attached Images
    Last edited by sabha; 05-29-2021 at 10:18 AM. Reason: Providing more clarity

  2. #2
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    240

    Re: Receive/Listen webhooks in excel vba OR fetch data from popped-up alert dialogue box

    Hi!
    Is it possible in excel to listen for events from regular alerts given in dialogue box of a website in chrome or any other browser? I am still searching on a way to do it and need to know if it worth spending time on it.
    Kindly reply. Thank you

+ 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. Can VBA/Excel listen for server responses?
    By BeefNoodleSoup in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2012, 04:16 PM
  2. Excel REFUSES to Listen to me regarding Date formatting
    By Phil_V in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2008, 10:28 AM
  3. Listen to Your Customers
    By Sprinks in forum Excel General
    Replies: 0
    Last Post: 07-25-2006, 12:55 PM
  4. [SOLVED] VBA does not receive Excel Events
    By EBenson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2006, 03:50 PM
  5. How to receive e-mail using Excel VBA
    By Leonardo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2006, 07:50 PM
  6. Replies: 2
    Last Post: 08-01-2005, 10:05 PM
  7. Wanna listen to music while surfing...
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-18-2005, 05:05 AM
  8. help with VBA scipt to listen to sheet
    By RompStar in forum Excel General
    Replies: 0
    Last Post: 05-24-2005, 07:20 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