Jump to content
  • 0

Lookup Prices in Excel

Question

Hello,

I would like to be able to look up prices for a range of stocks and instruments in excel so I can create alerts in my spreadsheet.  Can someone please point me in the right direction on how to do this.  I haven't been able to find out how on the IG Community forum or IG Labs help - I'm sure it's there I'm just struggling.  I got the historical value sample spreadsheet to work for individual items, but would like to be able to have last prices updated live or even end of day would be fine for a range of items in excel.

Any help would be much appreciated.  Thanks

Regards,

Michael

Share this post


Link to post

5 answers to this question

Recommended Posts

  • 0
11 minutes ago, tradertoad said:

Hello,

I would like to be able to look up prices for a range of stocks and instruments in excel so I can create alerts in my spreadsheet.  Can someone please point me in the right direction on how to do this.  I haven't been able to find out how on the IG Community forum or IG Labs help - I'm sure it's there I'm just struggling.  I got the historical value sample spreadsheet to work for individual items, but would like to be able to have last prices updated live or even end of day would be fine for a range of items in excel.

Any help would be much appreciated.  Thanks

Regards,

Michael

You can insert "Stock Connector" from office store in the excel.

Regards

HS

Share this post


Link to post
  • 0

Hi Michael,

I'm working on an Excel Add-in (http://www.excelpricefeed.com/) which enables streaming and retrieval of live prices from IG Index (as well as other data providers such as Yahoo/IEX). If you are interested I could send you a trial version so you can see if it can be useful to you. It's a work in progress so it's not quite finished and I haven't worked out pricing etc yet.

Let you know if you are interested.

Cheers,

Andy

  • Like 1

Share this post


Link to post
  • 0
21 hours ago, andysinclair said:

Hi Michael,

I'm working on an Excel Add-in (http://www.excelpricefeed.com/) which enables streaming and retrieval of live prices from IG Index (as well as other data providers such as Yahoo/IEX). If you are interested I could send you a trial version so you can see if it can be useful to you. It's a work in progress so it's not quite finished and I haven't worked out pricing etc yet.

Let you know if you are interested.

Cheers,

Andy

Hi Andy,

I would be very interested thanks, that sounds great.  The Yahoo feeds used to be great until they cut off international markets.  I've got google sheets to work somewhat and know IG have a live feed just haven't worked it out.  If there is a way to send a personal message or something then please do.

Cheers,

Michael

  • Like 1

Share this post


Link to post
  • 0
On 05/12/2018 at 15:29, Seoudi said:

You can insert "Stock Connector" from office store in the excel.

Regards

HS

Thanks Seoudi, that works great for US stocks but doesn't seem to work for international stocks.  Thanks though all the same.

Cheers,

Michael

  • Like 1

Share this post


Link to post
  • 0
8 hours ago, tradertoad said:

Hi Andy,

I would be very interested thanks, that sounds great.  The Yahoo feeds used to be great until they cut off international markets.  I've got google sheets to work somewhat and know IG have a live feed just haven't worked it out.  If there is a way to send a personal message or something then please do.

Cheers,

Michael

Hi Michael,

I'll try to send you a personal message.

Cheers,

Andy

Share this post


Link to post

Your content will need to be approved by a moderator

Guest
You are commenting as a guest. If you have an account, please sign in.
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Member Statistics

    • Total Topics
      5,881
    • Total Posts
      25,489
    • Total Members
      31,832
    Newest Member
    ricknguyen
    Joined 19/12/18 02:39
  • Our picks

    • US Fed watch: APAC brief 19 Dec
      US Fed watch: The US Fed meeting has been kickstarted and the markets are shuffling around in anticipation. US equities at time of writing are putting in a mixed performance, though al major Wall Street indices remain trading below key technical levels. It comes following a day in which Asian and European markets sold-off in sympathy with Monday night’s rout in North American shares. A desire for safety has supported a bid in US Treasuries: they are higher across the board. Interest rates traders are also grinding away, pricing out point-by-point interest rates hikes from the Fed in 2019. The US Dollar has dipped as traders take safety in other haven currencies: the US Dollar Index is below 97, mostly courtesy of a play into the EUR and the Japanese Yen. The weaker greenback has provided a lift in gold prices, with the yellow metal trading just below support at $US1250 per ounce.


      The Fed’s biggest critic: Everyone has an opinion on what the Fed ought to do, it seems. The most powerful voice of all, US President Donald Trump, has certainly weighed in on the subject, Tweeting: “I hope the people over at the Fed will read today’s Wall Street Journal Editorial before they make yet another mistake. Also, don’t let the market become any more illiquid than it already is. Stop with the 50 B’s. Feel the market, don’t just go by meaningless numbers. Good luck!” Never mind that President Trump’s policies, from major tax cuts and his trade war have contributed to the Fed’s invidious position. The President clearly is noting his concern about one of his hitherto favourite measures of personal success: the health of the US stock market. Whether rightly or wrongly, market participants, as contained within the price action in global markets, appear to agree with President Trump.
      • 0 replies
    • Indicator update: Customising RSI levels
      On the back of client feedback we now offer the possibility to customise the RSI levels on desktop and mobile devices. To do so, click on the RSI label once you have enable the indicator on your chart. This will open a dialog box that will allow you to change the levels (which are set at the default levels of 30/70), as well as customise the period and the colour of the lines.
      • 2 replies
    • FOMC - Wednesday 1900 GMT
      Trend of boring FOMC meetings likely ending tomorrow, expect significant USD and index moves through the rate decision. 25 bps rise expected but by no means certain, Trump already on the warpath.
      • 0 replies
×