LinkBack URL
About LinkBacks
Hi, I've been trying to make my Excel Professional 2010 to receive values from online arrays. I can't get it to do so. Is there a method to do this? I.E =valuewebsite.com(last, "Market")
Hi, I've been trying to make my Excel Professional 2010 to receive values from online arrays. I can't get it to do so. Is there a method to do this? I.E =valuewebsite.com(last, "Market")
You won't be able to write an Excel formula that reads directly from a website. However, you could possibly create a web query to read the source data.
• Data.From_Web
...and follow the prompts to see if you can access what you need.
Does that help?
I'm not sure I follow. You want me to dedicate a web site that basically allows Excel to read it?Originally Posted by Ron Coderre
Hmmm....that question makes me believe that I completely misinterpreted what you're looking to do.
Your example appeared to be a pseudo-formula that reads values from a website. Can you define what you mean by an "online array"?
Say the market price of some Sunglasses on Ebay are 20$ today at a very specific URL.
Every 24 hours the price updates. I want the price in my excel to fetch that price every time I load the document.
Bump
10charcs
There might be a way to do what you want, but it depends on the structure of the source website. Can you post a URL that is representative of the one(s) you're interested in, with a comment about what you data you want?
as Ron said set up a web query to wherever that price is stored ,if its stored where excel can read it of course. details here
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
http://services.runescape.com/m=item...tem.ws?obj=211
It would be the "Current guide price"
As for you Martin, I'll look into that.
You're using Excel 2003, so here are the steps to initiate the web query.
Note: That website has no tables, so you'll need to download all of the text and parse out the guide price.
• Data.Import_external_data.New_Web_Query
• Paste the URL into the Address bar
• Click: Go
• Click: the checkmark in the upper left of the page to select the entire page
• Click: Import
• Select where you want the data placed and click OK
The data will be placed in the column you selected
To pull the guide price...use this formula (assuming the data is in Col_A):
=--RIGHT(INDEX(A:A,MATCH("*guide price*",A:A,0)),6)
Whenever you like, right-click on the data section and select: Refresh
Is that something you can work with?
Yes, thanks.You're using Excel 2003, so here are the steps to initiate the web query.
Note: That website has no tables, so you'll need to download all of the text and parse out the guide price.
• Data.Import_external_data.New_Web_Query
• Paste the URL into the Address bar
• Click: Go
• Click: the checkmark in the upper left of the page to select the entire page
• Click: Import
• Select where you want the data placed and click OK
The data will be placed in the column you selected
To pull the guide price...use this formula (assuming the data is in Col_A):
=--RIGHT(INDEX(A:A,MATCH("*guide price*",A:A,0)),6)
Whenever you like, right-click on the data section and select: Refresh
Is that something you can work with?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks