web data

Hi, I'd like to be able to update the data from the web based on a cell URL link. The reason for this is if you look at the example below there is a specific date, this date will change over time (as only require a certain amount of history, say 1 year). So ideally the web lookup would be...

Hi there, I am looking for a wizard to help me out on this one. I've created a rather advanced Excel workbook that tracks stocks (analyses, gives alerts, atc). The only thing missing is real time stock prices. I have tried many many things to get real time stockprices in my spreadsheet (power...

Hi all, I have a code for getting data from a specific website. But when I run it I get an error (Compile Error: User-Defined Type Not Defined) at "Dim html As New HTMLDocument" Can somebody please help me with this problem? Sub Get_Web_Data() Dim request As Object Dim response As String Dim...

I have set my workbook to retrieve data from a website which gives prices of stocks. It refreshes hourly. I then have some cells that make calculations based on the stock prices using a simple formula. I am trying to make it so that every time the data refreshes, it recalculates based on the...

I am using Excel 2016 as a means to capture data from a piece of equipment that has a web IP address/USB port. If I use a web browser, the URL would be http://127.0.0.1:44789/evox/bacnet/2/0/51/117 and would get back a response <int< font=""> xmlns:trane="</int<>trane:evox"...

HiI was use an external web link in my windows excel to download latest changes in stock through:Data>From Other Sources>From XML Data ImportAnd The link is :http://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx?d=0Does anyone has any idea that how can i use this link in Macintosh excel...

I need to try and set-up PowerQuery to an internal web report viewer. The report viewer requires dates to be selected before showing any results. I am trying to avoid back-end access via SQL, so I was wondering is there is a way to pull the necessary data with specific date parameters?

I'm using Excel 2003 and 2010 and trying to import the main table from the following link:Nasdaq New Highs & Lows - Markets Data Center - WSJ.com The targeted table is labeled atop "New 52-Week Highs:" When I use the "New Web Query" menu function and insert the link, the first unusual...

Hi I am new to excel and i have a situation where i have a pan data in column A... say A1, A2 and so on. I want these PAN numbers to pull out data from the website "https://www.mahaonline.gov.in/NSDG/PANDetails/MahaonlinePAN.aspx" and put the result on other sheet in same work book, each PAN...

Hi, I am trying to get some numbers out of a string of data that is external from the web so it will be continually updating. For example I will have a value like this: (Number of Records: 3772). But when I refesh it the value could be (Number of Records: 384) so I need this to update with...

Hi, I'm new to VBA (and to this forum) and was wondering if someone could help me with a problem getting some web page data into Excel 2010 using VBA. Basically the scenario I am trying to create is very similar to this YouTube tutorial. Excel VBA Pull Data From A Website - YouTube My...

**I just realized I posted this in the wrong forum, sorry for the rookie mistake, but I don't know how to move it** Is it possible to import data that is retrieved after submitting a webform without using copy/paste? I'd like to be able to automatically pull the data table into excel on this...

Hi all, I cannot seem to get external web data function, i am using Excel Office 2011 Mac, the option does not seem to be there??? I need live currency exchange rates to be automatically updated into a table i have created. can this be done on mac 2011?

Weird one for my first post on this forum but here goes!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have a friend who works as a travelling support worker (ie she drives to a number of different disabled people’s homes every day) come...