Jump to content
  • 0

Lookup Prices in Excel


Guest tradertoad

Question

Guest tradertoad

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

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

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

Link to comment
Guest tradertoad
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

Link to comment
Guest tradertoad
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

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

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

Archived

This topic is now archived and is closed to further replies.

  • image.png

  • Posts

    • The digital landscape is undergoing a profound transformation as attention, once a freely given commodity, is increasingly recognized as a valuable asset. Layer3 is at the forefront of this revolution, pioneering a new economy where attention can be owned, traded, and monetized   This innovative approach empowers individuals to monetize their engagement, providing unprecedented control over personal data. Simultaneously, advertisers benefit from transparent metrics that optimize campaign performance. Content creators are presented with diverse revenue avenues beyond traditional advertising, while the overall ecosystem experiences a more equitable distribution of value.   The implications of Layer3 extend across various sectors. Social media platforms, for instance, can leverage this technology to revolutionize user engagement and monetization strategies. Tokenomics play a crucial role in driving Layer3's economy, incentivizing participation and rewarding value creation. While challenges such as data privacy and market volatility exist, the potential benefits of Layer3 are immense   Anticipation is building as its native token $L3 is on Bitget Pre-market as users await its listing on the exchange. This milestone is expected to significantly increase the token's visibility and accessibility, potentially driving substantial growth and attracting new investors. As the countdown begins, the crypto community watches with keen interest, eager to see how Layer3 will perform in this new chapter.
    • I've been exploring the world of play-to-earn gaming recently, looking for something that's not just about endless grinding but actually offers a fun and rewarding experience. OGC really stood out to me because it combines gaming with a sense of community in a unique way. OGC isn't just a game; it's a platform where you can play, earn, and even help shape its future. You're not just a player; you're part of a community with a voice. The idea of earning crypto while playing games is exciting, but what makes OGC special is its focus on community involvement. Your feedback can directly influence the development of the game, which is a big deal. I've also heard that the OGC token is available for pre-market trading on Bitget. While I'm still getting to know the platform and its features, it's definitely something to keep an eye on. Has anyone else tried OGC? What has your experience been like? I'd love to hear your thoughts and any tips you might have.
    • I am anticipating the impact of this listing on Mongy. 
×
×
  • Create New...
us