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

    • Since the beginning of 2024, memecoin and AI projects have taken the crypto space by storm. Many memecoins have seen incredible adoption, with their market caps surging exponentially over the past few months. Notable examples include WIF, PEPE, and BOME, among others. Traders have shifted their focus to memecoins, drawn by their remarkable profit potential, surpassing even that of traditional BTC and altcoins. While trading memecoins can be highly lucrative, it is crucial to acknowledge the associated risks and conduct thorough research (DYOR). Some memecoins, like CAF and HMTT, have seen significant declines, resulting in substantial losses for traders. Identifying the right memecoin and the optimal time to trade is essential. As a trader always on the lookout for promising tokens, I recently discovered a memecoin with substantial potential: $LAIKA. Unlike others driven purely by social media hype, $LAIKA offers real utility. Its features include a mobile game, Laikaverse, LAIKA wallet, and DeFi (NFT staking), all contributing to its unique value proposition. Since its listing on Bitget a few hours ago, $LAIKA's price trend has been bullish. Several upcoming events provide traders with opportunities to enhance their holdings. I believe $LAIKA has the potential to emulate the success of $****, $WIF, or $DOG, but it's imperative to conduct your own research and avoid fear of missing out (FOMO). Personally, I see $LAIKA as a promising investment and would love to hear the opinions of other memecoin enthusiasts on this token.
    • Iinteresting, I've been watching the memecoin space for a while, and DOGE's success is hard to replicate. But a fast-growing project with a team that has some clout, especially with the Dogecoin Wallet founder on board, piques my interest. Right now, I'm actually busy exploring the treasure trove event on Bitget. The reward pool sounds pretty enticing, and with everything going on in the market, some extra crypto wouldn't hurt haha. I'll have to check out $JUNGLE more closely after I finish up with this event. Launching on Bitget is a good sign, and if they can truly capture that "sincerity and bravery" spirit, it could be something special
    • Awesome news for us Bitget users, especially those of us who already love the Bitget Wallet. I've been using it for a while now, and having everything from swapping to NFTs in one place is super convenient. Finally having a BWB token for the Bitget Wallet makes perfect sense. I'm excited to see how it fuels the growth of the whole ecosystem
×
×
  • Create New...
us