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
Bookmarks