Importing live data into excel?

I want to import live data into EXCEL and then manipulate it in several formulas i made when a certain even occurs id like to automatically set up several trades

Im currently using the FXCM trading platform but im open to other platforms

I have some conditional formats set up in excel

Is there a program that will allow me to do this?

I want this to be set up to run 24/7

Don't know how you do it in Excel but you can get live FXCM data into Wealth-Lab Developer (www.wealth-lab.com) from dataHQ (www.forex.dataHQ.com.au) and whatever you can do in Excel you can do better in Wealth-Lab.

Simon

thats most of what i was looking for thanks

You can use DDE feeds to get live quotes. Metatrader, Gain, and CMS VT have DDE feeds. I found CMS to be the most versatile because it DDE feeds for different time frames.

DDE feeds do not include historical data. You can write routines to capture the data, though.

The VT API works great with Excel and you can use it to request historical data as well as live quotes via events instead of DDE.

FXCM also offers DDE service at a monthly fee.
It comes with its own program & excel plugin.
You can get a free 30 day demo per request.
Good luck....

what does dde and api stand for?

DDE = Dynamic Data Exchange
API = Application Programming Interface

does wealthlab use easylanguage for programming?

Wealth-Lab uses a pascal based programming language.

Simon

A web search bring up a LOT of availabe options and tools for this, including one that interfaces with MT4 that is much easier to program (more powereful) EAs, Indicators and Scripts etc builder than with MQL4 directly
Here are a couple to check out, though I recently downloaded the powerful one that allowed for programming EA's etc interfaced with MQL4 but don't know where I put it at the moment. When (IF? )< 8) I find it again, I'll post it here, though if someone sent me a message/eMail about this, It will make it much easier and more likely that I can get back to here to post it.
Here are a couple of sources to check out:
- Fx1.Net
- FxDialogue.Com

.
Very nice Avatar BTW.
Again, FX1.net and FxDialog.com have free tick collecters.
One puts it into MT4 history files for back testing on weekends, the other logs them into Excel for WHY.
- TickColectorFinal.xls
- MT4Ticker.Exe/Zip

Coolio. Thanks for the links. What I need now is a price feeds and historical via a webservice either as xml or remote object.

I can probably make a web service out of MT4's dde and historic export as csv, but I'm hoping to avoid being my own data provider for my web app.

I'm new to the Forum so apologies if the question has been asked and addressed. I'd like to download histric FX data in Excel. What is the consensus for the 'best' source? Many thanks.

Does anyone have backup historical cmsfx charting data please?

i am looking for the above mentioned
TickColectorFinal.xls
MT4Ticker.Exe/Zip
can someone post the link where i could download them?

does this help?

http://www.fx1.net/wiki/pmwiki.php/MT4Ticker/MT4Ticker

I was searching for a reliable way to export historical Forex data into Excel, but hopefully this might help anyone in the same situation as me.

Firstly the data feed and application automations on the web are useless, they come in just come time frame, and due to the fact that Yahoo doesnt have indicator feeds, you can't really do much with the data.

I had almost given up until I stumbled across Marketscope 2.0's ability to export data from all graphs presents into excel, including any indicator levels.

It's in file>Export to Excel - or SHIFT+ALT+E for short.

It presents the data in a very simple format - and exporting to a fourth party software (i.e. SPSS, SAS as I've done is very easy)

Hope this helps!

Hello, to all!

I need help if You are willing to help. It’s about the small issue.
I need little tiny Excel VBA program.
(excel is yr 2007, but I think 2010 and maybe 2013 are practically more or less, the same)
In short:

1. Name of the workbook is Workbook1

2. Worksheet1 have a DDE link.
Cell A1 is being populated with new data every now and then.

3. In Worksheet2 I want each and all new values when they change in Cell A1 in Worksheet1, to be stored in column A from first row to bottom.
Every new value need to be stored in next row (cell):A1, A2, A3...
It has to be very fast and smooth. As little as possible computer resources consumption.
On button click - for ''on'' and ''off''.
(Solution for more than one cell, separately, but in the same code e.g. for A1, B5, C10..., even better.)


In short, that’s all folks!

I already have other solutions with timers but I want this one. Don’t know how to do it!
For those who help, I'm willing to share other codes.
(I have some similar as requested code, code examples also, but I don't know if they are of any use.)

If You want other help from me and if I can help You, just ask.
For bigger problems, and future software’s, and bigger VBA constructions, who knows...



Thank You very much for Your time and effort!

Please answer via p.m.

Use SetLinkOnData method
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

yea, I also looking for similar function to extract weekly open and close price to excel. Anyone can help?