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

6 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
  • 0

Hi,

The Add-in is now available and can be downloaded at: http://www.excelpricefeed.com/userguide/download

Contact me either via my website or private message and I can send you an Activation Code for a free 20 day trial.

The Add-in currently provides live and streaming prices to Excel cells via simple formulas such as: =EPF.IG.Stream.Bid("CS.D.GBPUSD.TODAY.IP")

I am looking at adding historical data access as well as other functionality depending on user feedback.

Hope you find it useful.

Andy 

Capture.PNG

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
      6,063
    • Total Posts
      26,586
    • Total Members
      33,661
    Newest Member
    Matthew_123
    Joined 18/01/19 16:12
  • IG London Art Fair

  • Our picks

    • What's wrong with predictions?
      Join the IG conversation on Community. "There's lots of talk about 'the smart money' banks, institutions, pension funds and the like but not much about the others side of the coin, 'the dumb money', why is that - it's because they just aren't influential to the market. The collective size of the dumb money is dwarfed by the big money to the point of being irrelevant."
        • Great!
        • Like
      • 2 replies
×