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

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

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

Link to post

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
      15,175
    • Total Posts
      73,266
    • Total Members
      61,613
    • Most Online
      5,137
      14/01/21 09:51

    Newest Member
    McFish
    Joined 13/05/21 15:16
  • Posts

    • This is why I think using volatility as an important input is a much better way..... It's not about predicting the markets, it's about proactively preparing for what maybe around the corner. Follow me on twitter for more updates. Took me all night to model that price action and it paid off “ biggly”.    Take care out there  CA  
    • A higher than normal spread generally indicates one of two things, high volatility in the market or low liquidity due to out-of-hours trading. Before news events, or during big shock (Brexit, US Elections), spreads can widen greatly. A low spread means there is a small difference between the bid and the ask price. From google
    • I don't think it would be a problem trading during the weekend. You can trade whenever you want.  I learned how to do it on the cryptoinformator website. The highest income is brought by bitcoin. When looking at the value of the current 55,000 dollars, of course, everyone is thinking about investing in it. Forecasts vary, and many believe that by the end of 2021, they would have surpassed 100,000 dollars. The growth is projected to be based on the fact that real-world payment flow stock markets are still burdened by the current pandemic but is also based on the increasing acceptance of BTC as legal tender ( PayPal is bringing this option, and bitcoin is also coming to Wall Street soon).
×
×
  • Create New...