Email:      Pass:    Pass?
Advertisements


Free Excel Forum

Live Feed Help.

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hello all,

First post here and also a new Excel user so please forgive me if I use incorrect terminology! Ok, so here goes. I'm trying to teach myself how to trade forex, and as part of my ongoing attempts to become profitable I am trying to analyse some of the price data in excel. I've managed to set up a live feed into Excel from my trading software using a DDE? Which works and is great but it just gives me current prices for the currency pairs and that's all.

So, my question is - Is there a way to take data from the live feed say, every hour, and form a table? Like a table that shows the prices for the last 24 hours and constantly updates itself? I'll leave it there for now and see if you guys and girls have any ideas. Thanks in advance,

Sam.


Similar Excel Video Tutorials

Helpful Excel Macros

Basic Web Query in Excel - Import Data from the Web into Excel
- Import data from the web into Excel with this macro. This is a basic web query macro that will import data from any web
Format Cells as a Currency in Excel Number Formatting
- This free Excel macro allows you to quickly and easily format a selection of cells in the Currency number format in Exce
Sort Data With Headers in Ascending Order in Excel
- Macro that sorts data that has headers in ascending order in Excel. This macro assumes that you data has headers on it.
Sort Data With Headers in Descending Order in Excel
- This Excel macro sorts data that has headers in descending order. This means that data is sorted Z to A and 10 to 1 - o
Filter Data to Show the Bottom 10 Percent of a Data Set in Excel - AutoFilter
- This free Excel macro filters a data set to display the bottom 10 percent of the data set in Excel. This is a great mac

Similar Topics







I have a spreadsheet that currently has a DDE link to live prices that are updated constantly (up to 3 times a second, possibly more).
There are 5 cells on the spreadsheet, A1:A5, and when A1 updates I have a macro that copies the value of all 5 to a , so building up the history of prices. That seems to work fine, but when I add some extra calculations (such as dynamic ranges for charts) the spreadsheet slows down, and I miss some of the live feed prices.
Is it possible to use the RTD function (which I believe temporarily stores unused data) with the feed I have for DDE (MT4|Dax!Last)
Regards


Hello,

>>>>Excel 2003 - snapshot of live data feed

We have an Excel 2003 spreadhseet that contains a live feed from reuters and updates regularly. My boss has asked if we can get an automated snapshot of the spreadsheet every evening at 5pm! So withpout manually capturing a JPEG using Snagit or something like that - I am unsxure how to autiomate this one - any ideas guys?!!!


Hi

I am having trouble importing the live prices into Excel 2007.

After looking on the web on how to do it, it says that you can do it from a program called MetaTrader - which I have got on my computer, and the feed comes from there.

So what it is telling me to do is to post this into the cells and it should work.
='MT4'|BID!EURUSD
='MT4'|ASK!EURUSD
='MT4'|HIGH!EURUSD
='MT4'|LOW!EURUSD

I have enabled the DDE server within Metatrader but with no luck on how to get it working.

Any help would be appreciated.

Thanks

Phil


I have a live data feed into excel, feeding share prices. I want the price to update in the next cell every time the price changes. Is this possible?


Hi everyone,
I'm brand new to programming in Excel, and currently building a system that will help me trade equity options (similar to trading stocks). So far, I've put together the ranking system I want to use based on a live data feed that updates in real-time (during market hours). For every possible trade in my 'universe' (currently about 600), Excel provides a live score (based on my formulas and weightings) as well as prices and other info about the trade (options strikes, symbols, expected return, etc.).

What I'd like Excel to be able to do is keep a separate sheet where a trade (row) that scores over an arbitrary threshold, say, 100 'points,' is recorded as a static line (instead of continuing to dynamically update), like a snapshot of that line. I'll use this list of trades to submit to my broker for trading.
If it was as simple as a 'triggered' copy - paste special - values, that would do just fine. The trigger would also need to see if that trade has already been recorded for the day, so I don't get an infinite list of the same trade.

After a trade makes it into this list, I'll need to compare it to what I already have in my portfolio (which I'll also need to build) so I don't become too heavily weighted in any one trade. (Just thought I'd let you know where this will be going, too).

I'm sure I left out some important details, so please ask away! Thanks for your help!

-Tony


hello everyone, i am just learning vba and my ideas are way ahead of my vba programming capabilities. here is my new idea, something i hope is possible with vba:

i import live feed data into excel spreadsheet from my trading program, and it looks something like this "=TOS!msft" in each cell.

so if i have a few cells in the first row of such data, which changes maybe every second (sometimes more often)....is there a way for VBA to look for any changes (in any of the cells) and if it spots a change, it pushes the values before the change took place to the 2nd row, so the "freshest" data is on the first row. and once that changes again, it'll push that to the 2nd, and the 2nd row to the 3rd...and just do this all day long and make a little database.

i dont even know where to begin with something like this, so hopefully someone will be able to tell me if this is possible and if it is, how difficult of a project it would be.


thank you all!


Hi,
I have created a worksheet_calculate formula and it keeps giving me a headache... hope you can help
In my spreadsheet I am having live stock market data linked into the spreadsheet. On a separate worksheet I have an if statement that goes something like this...
+if(Sheet1!B4>15,True,false)
cell B4 is the stocks price and it keeps updating every second (because it's a live feed)
I have the if statement and worksheet_calculate in sheet2 (seperate from the live data feed)

The worksheet_calculate is simply this...

Private Sub Worksheet_Calculate()
Worksheet_Change Range("$A$1")
End Sub

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = Range("$A$1").Address Then
If Target.value = True Then
MsgBox "Buy"
End If
End If
End Sub

This does work however because the stock price (cell B4) keeps updating it keeps updating the if statement over and over again and causing the worksheet_calculate to fire off a million "Buy" Message boxes.
Is there a way to only have one message box pop up when the price goes over $15?
Thanks for your help
John



Hi guys,

I new to excel so bear with me. I'm not sure if someone here uses MT4 and excel.

I can get live data from a Metatrader forex chart through DDE link to excel, for me to get live data streaming into excel I need to put these code in indivdual cells:

=MT4|BID!EURUSD
=MT4|ASK!EURUSD
=MT4|HIGH!EURUSD
=MT4|LOW!EURUSD
=MT4|TIME!EURUSD

But what I want to do is to record this live data into excel so I can use this data to manipulate later on such as build different time candles etc...

I really want to download past meta trader history and Metatrader history is there to download but I not sure if I can run it together with the live feed to get a continuous stream of data with looking at past history, also not sure if this is truly difficult to do in excel.

Anyway I hope I make sense


Hi,

In one excel cell I have link to forex broker live data feed(ticks, prices) that is refreshed every second.

I would like to know is it possible to export those ticks to txt or csv file - when new tick arrive write them to the txt file.

Example:
Time: 08:05:25 Cell A1: 1.2555
Time: 08:05:26 Cell A1: 1.2554
Time: 08:05:27 Cell A1: 1.2558
Time: 08:05:28 Cell A1: 1.2556

txt file:
08:05:25 - 1.2555
08:05:26 - 1.2554
08:05:27 - 1.2558
08:05:28 - 1.2556

Thanks!


Hi,

I want to know how I can get a cell to display the live and continuously updating price of a stock on CNBC. Using Best Buy for an example at this link: http://www.cnbc.com/id/15837290?q=bby . How could I do this? Any help would be much appreciated.

Thanks

---What I need is the "Last Trade" price in the top box.


Hello

I did a search prior to posting and could not find exactly what I was looking for.

I have an Access DB that houses our company information. We also use the DB (in form view) as our CRM software, so the data changes daily. I am looking to generate reports in Excel pulling the data live from the Access DB.

Is there a way (the simpler the better but I will learn whatever it takes) to set up a data "feed" from the table in Access to be fed to tables in Excel with formulas in place?

I found an Excel 2007 plugin and am trying it out now but figured I would ask if it does not work.

thank you

John


Hi everyone. I am trying to figure out a way to tab delimit an excel file but without changing the columns. Usually I just save the excel file as a tab delimited file, then I open up the tab delimited txt file that I've just created with excel, and I go through the Wizard to open the file in excel. However, I've noticed when working with a particular file recently that has asterisks like * and strange parenthesis marks like 〔〕, the columns show up moved over and out of order in the columns, and I get question marks in place of the parenthesis. How can I tab delimit the file and maintain the same columns -- especially for the ones that begin with "Prices A" or "Prices B"?

For instance, an example would be an original excel doc like this:

0103.92 Weighing 50 kg or more
011 *〔1〕Per each, not prices Prices A: standard Prices B:
Prices A: standard import prices for live swine specified by
Prices B: the prices specified by *〔1〕 in this sub-heading
012 *〔2〕Per each, more than the upper limit prices for the
Prices A: mentioned in *〔1〕
Prices B: the rates specified in this sub-heading *〔3〕
020 *〔3〕Per each, more than the gate price of live swine, in
01.04 Live sheep and goats
0104.10 000 Sheep
0104.20 000 Goats


The resulting txt to excel file that I'm getting looks like this:

0103.92 Weighing 50 kg or more
011 *?1?Per each, not more than the upper limit
Prices A: standard import prices for live swine specified by the sub-paragraph 1
Prices B: the prices specified 19,508 yen/each
Prices A: standard import prices for live swine
Prices B: the prices specified by *?1? in this
012 *?2?Per each, more than the upper limit prices
Prices A: mentioned in *?1?
Prices B: the rates specified in Per each, the difference between the standard
Prices A: mentioned in *?1?
Prices B: the rates specified in this sub-heading
020 *?3?Per each, more than the gate price of live
01.04 Live sheep and goats
0104.10 000 Sheep
0104.20 000 Goats

Any thoughts would be great. Thanks!


Good day all,
I hope I can gain some assistance from you guys in relation to this subject.

I have a dynamic data feed into excel (cell references a1 to h1).
The width of this data feed is static. However the depth differs, because the feed has 3 parts, and each part can be a different depth, depending on the amount of rows contained in each part of the data feed.

I cannot segregate the data feed into 3 separate entities.

I have some cells immediately to the right of this feed. These cells have formulas and formatting in them that relate to the corresponding rows in the data feed in each section.

My problem is that when the data feed updates and displays a large amount of data in any section, my cells containing the formulas and formatting to the right of the feed becomes mis-aligned with the corresponding row of the data feed, and the formula references loose their source/target.(Absolute referencing does not fix this problem).

Is there a way I can lock my cells on the right to each data feed section so they align to the corresponding row in the data feed?

Example:
To start with:
first data feed contains 10 rows.
second data feed contains 10, and
third data feed contains 10 rows.

When the data is updated, i could have section 1 with 15 rows, section 2 with 9 and section 3 with 12. I want my formulas and formatting to shrink and/or grow with the depth of each section.

I hope I explained it Ok? Please assist if possible..


How to get live updates from the Net?

I am trying to keep a track of my Stock prices from a particular site..
I want to make it interactive by linking it to a website however I do not know how this can be made possible...

Can someone please post an example as I do nit have any ideas...


How to get live updates from the Net?

I am trying to keep a track of my Stock prices from a particular site..
I want to make it interactive by linking it to a website however I do not know how this can be made possible...

Can someone please post an example as I do not have any ideas...


Hi there - using excel 2003.
I am using DDE to get currency prices from MT4 platform.

formula in cell D3 is =MT4|ASK!EURUSDm

I am trying to do a conditional format so that colors change depending on whether price has moved up (blue) or down (red)

I thought i could go to Conditional format and do the following :

If Cell Value (greater than) =D3 then turn blue
and
If Cell Value (less than) =D3 then turn red

this didn't seem to work.

Anybody have any ideas?

Do i need to include something in the formula which looks at (old cell value)???

Thanks in advance.


hi,
i am finding it hard to explain my problem.

i have an excel sheet which is calculating portfolio returns using a live feed for prices from bloomberg.

i want to know if it is possible if i can create a macro to copy the number in one cell that is continuously being updated to a column in another sheet keeping old values in the column too.

i am sorry for this idiotic explanation. but i will give an example.
suppose that at the moment the total return is 10%, i want the macro to copy this number into a new column and when the value is refreshed which is after 2-3 seconds then the macro will copy the new figure (lets say 12%) into the same column as before but below the last figure. So in the end i will have a column with all the numbers representing the change of total return over the day/week. so i can create a graph later on with how the portfolio is performing.

is that clear enough?

please help. thanks a lot


I have dynamic data that is automatically updated by a live feed. It updates cells m3:m32.

I currently have a code that plays a sound whenever a value in any of the cells is greater than a certain threshold and another code that plays when any of the cells goes below a certain threshold.

The problem is the sound continues to play each time the live feed is updated and the cell condition is correct.

I want the sound to play once for example when a cell value first goes less than 4, but then dont play again if it continues to be under 4. However, if a new cells value goes to less than 4, I want the sound to play.

The problem at the moment is my code limits the sound to play once but it applies to the total cell range not the individual cells so if a 2nd cell's value drops below 4 it wont play.


I have live forex prices coming into a cell from a DDE server and I want
to record a 5:00pm price into a different cell

Iam using the formula =MT4|BID!EURUSD to get the live prices.

I just want to record a price at a specific time into a different cell

and I am not sure how to do that


I have a cell (B4) that gets a live data feed. I would like something to run that logs the values from that B4 cell into another column every 2 minutes. I am still pretty green at using VBA so please keep that in mind. Thanks!


My worksheet has a data feed of market prices into cell A3. Is there a way of recording all the prices as they change in columns B3 to IV3?


Ive been trying to web query live,gold price $1369.30 and silver price $26.14 from a table here



http://www.cmi-gold-silver.com/gold-...ot-prices.html


My attachments show what Ive been getting .Can anyone help?


thanks


I have written the below formula into cell b7 of my workbook. Works great no problems. Now I am trying to put this formula into a macro to place it back into the cell every time I run it.

(reason being the data changes in ex pit live.xls every day and I was planning to copy paste values over the top every day)

Why can't i record it? is it because i have "" inside of the formula?

Any ideas how i can fix this, or even replicate what the formula is doing?




=IF(IF(ISNA(INDEX('[Ex Pit Live.xls]Sheet2'!$A$5:$K$28,MATCH($A7,'[Ex Pit Live.xls]Sheet2'!$A$5:$A$30,0),MATCH("aga",'[Ex Pit Live.xls]Sheet2'!$A$4:$K$4,0)))=TRUE,0,INDEX('[Ex Pit Live.xls]Sheet2'!$A$5:$K$28,MATCH($A7,'[Ex Pit Live.xls]Sheet2'!$A$5:$A$30,0),MATCH("aga",'[Ex Pit Live.xls]Sheet2'!$A$4:$K$4,0)))=0,"",IF(ISNA(INDEX('[Ex Pit Live.xls]Sheet2'!$A$5:$K$28,MATCH($A7,'[Ex Pit Live.xls]Sheet2'!$A$5:$A$30,0),MATCH("aga",'[Ex Pit Live.xls]Sheet2'!$A$4:$K$4,0)))=TRUE,0,INDEX('[Ex Pit Live.xls]Sheet2'!$A$5:$K$28,MATCH($A7,'[Ex Pit Live.xls]Sheet2'!$A$5:$A$30,0),MATCH("aga",'[Ex Pit Live.xls]Sheet2'!$A$4:$K$4,0))))


Getting the following error message:

"Unexpected error in Create XLMD err number = 429"

When I get this message, I can't open the workbook. I can see the workbook, but it's frozen and unresponsive.

The workbook is tied into a data feed from a major financial services information provider, which gives me live stock quotes and much more.

I know it has something to do with the feed, because I only get this message on the workbooks tied into the feed. Other excel workbooks are operating just fine.

Any suggestions?


What is the more reliable way to get live data in a cell?

Using a charting software, MultiCharts, I want to send prices info. My goal is to connect that live info to an Excel cell. Updated twice per second is sufficient.

At the moment, I have succeeded to sent a string of data from Multicharts directly to a designated cell. It work well until I'm working with Excel. Then, once in a while the link is stopped.

I did try to use global variable and use Excel to read from them. Problem, I was using all the resource only for that loop and Excel crashed.

I read that DDE solution is out of date and unreliable.

Witch way is more appropriate and stable for Excel and my charting software.

This is a bit of a philosophical question. A bigger but interesting project than i taught

Martin