0

Is there a MS-excel function that allow to link data from the web?

I am tryning to create a model based on MS-excel spreadsheet with financial data.

How can I update the cells with the today value of a single debenture/equity found/stock? I think I have to use hyperlink but I do not understad how to find those data from a webpage.

All data I need are free available online

5
  • Please note that Super User is not a script writing service. If you tell us what you have tried so far (including any scripts you are using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
    – DavidPostill
    Jun 14, 2016 at 16:29
  • 1
    I was asking if there is an excel function that link data from the web to a cell. I re-write the question in a better way. I am not able to write script or using VBA functions
    – Ale
    Jun 14, 2016 at 16:44
  • Then you should employ someone to do the work or learn yourself.
    – DavidPostill
    Jun 15, 2016 at 17:38
  • @DavidPostill as suggested I studied (also with the help of other user from the web). Now you can see the solutions that works for me, and I hope also for other users
    – Ale
    Jun 16, 2016 at 12:28
  • Well done. Nice answer :)
    – DavidPostill
    Jun 16, 2016 at 12:55

1 Answer 1

2

This is a solution with office 2007 that I would like to share:

  1. select "data" section an then click "from web" step_1
  2. it opens a new web-query where you have to insert the web address of the page with the data you need step_2
  3. if the data you need are included in a table you can import only that table, because tables are highlighted by a green arrow (otherwise you can import all the page) step_3
  4. before choosing the cell where import tha data you can use option tab as you need step_4_option_tab

The screenshot are from my regional version of office

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .