Jump to content
  • 0

Lookup Prices in Excel


tradertoad

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

Link to comment

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

Link to comment
  • 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
Link to comment
  • 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
Link to comment
  • 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

Link to comment
  • 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

Link to comment

Join the conversation

You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
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.

  • General Statistics

    • Total Topics
      16,214
    • Total Posts
      77,597
    • Total Members
      64,370
    • Most Online
      7,522
      10/06/21 10:53

    Newest Member
    NIVA
    Joined 15/10/21 18:32
  • Posts

×
×
  • Create New...