Linking Excel to live currency rates?

[VX Foxy]

Anyone know how to do it? Preferably free!

[jacobyte]

I don't think you can get free Forex data feeds - they command some hefty licences.

[sa_20v]

If you find a website that displays live prices, I'll build you a spreadsheet that does it.

[VX Foxy]

sa_20v said:

If you find a website that displays live prices, I'll build you a spreadsheet that does it.

Excellent, thanks! Yahoo say they do streaming prices - http://uk.finance.yahoo.com/q?s=GBPUSD=X - does that work?

[Golfman]

http://www.xe.com/ucc/ if it helps?

[amir_j]

without paying not sure.

Could always do a rough solution ie Data->Import External Data -> New Web Query and then automate to keep pulling in and moving around depending on how comfortable you are with macro/vba.

Edited by amir_j on Wednesday 12th November 22:18

[sa_20v]

amir_j said:

without paying not sure.

Could always do a rough solution ie Data->Import External Data -> New Web Query and then automare to keep pulling in and moving around depending on how comfortable you are with macro/vba.

Yup, that's what I was thinking - just refresh it with VBA.

[VX Foxy]

I have no idea what you guys are talking about! But a 'rough' solution would be fine

[amir_j]

VX Foxy said:

I have no idea what you guys are talking about! But a 'rough' solution would be fine

As per my post, follow those menu options and type in a web address and you can select bits of web pages to import in and options to refresh etc iirc.

Without vba(the more hardcore behind scenes programming) you may be a bit limited with regards to full automation though.

Lots of home currency traders about to be honest so should be an off the shelf product available, guy at work is in the 'paper trading' phase of his FX black box solution but wouldnt share as you can imagine.

Edited by amir_j on Wednesday 12th November 22:18

[shadowninja]

Um. Can't you just find live data off Oanda.com and locate the stream (speaking from a non-technical viewpoint)?

[sa_20v]

Having imported the data into Excel via a web query, and set the query to refresh once a second, I now don't see a point in using VBA - this only complicates issues, and unless you have to store data or create graphs from the live feed, this isn't required.

Btw - don't expect the data to update every second, it can only update if the information shown on Yahoo changes.

http://www.earlyentrepreneur.com/library/example1....

[VX Foxy]

sa_20v said:

http://www.earlyentrepreneur.com/library/example1....

That's brilliant! Thanks

Easy when you know how I owe you a beer!