live price in excel cell

rdstagg

Active member
Messages
207
Likes
3
Is it possible to have a live price updating in an excel cell?
I use a spreadsheet to manage trades and it would be useful to have the live price flickering away or updating say every 5 mins.

I don't think its possible but if anyone does know a way I would be grateful for some help

Russell
 
It is possible.
I use Mytrack to feed live data into Excel. The values in the cells change constantly.
Glenn
 
do you know the code for the cell - could you copy an example?

Glenn said:
It is possible.
I use Mytrack to feed live data into Excel. The values in the cells change constantly.
Glenn
 
i have live data in excel but how can i repeat the following macro to automatically
move the data down the page every 5 minutes as it does in sierra ?
i can use the "Now" and "Minute" excel references for the timing

Sub Macro1()
Rows("1:1").Select
Selection.Insert Shift:=xlDown
End Sub
 
You could use on time run for macros or external data refresh box
 
rdstagg said:
do you know the code for the cell - could you copy an example?

You need to load the Mytrack add-in into Excel. mt.xla.
The cell code is easy enough.
I use it for Options prices and open interest.

Example. To get the Bid price for a particular ticker.
The ticker for FTSE100 July Calls at 4025 is ESX-L GM.
I have this ticker in a table of others. This one is in cell C43.
To get the Bid Price for this ticker into cell G43, the code is =mtBid(C43)

Glenn
 
Last edited:
ColinRiche said:
i have live data in excel but how can i repeat the following macro to automatically
move the data down the page every 5 minutes as it does in sierra ?
i can use the "Now" and "Minute" excel references for the timing

Sub Macro1()
Rows("1:1").Select
Selection.Insert Shift:=xlDown
End Sub

It would seems easy enough to produce the code for the shift using the Record Macro feature.
e.g Highlight the cells you want to shift down
Copy and paste them one row lower.

Glenn


Glenn
 
The code for the cell will be dependant upon the data source you are using.


Paul
 
is my track a subscription data feed?

Glenn said:
You need to load the Mytrack add-in into Excel. mt.xla.
The cell code is easy enough.
I use it for Options prices and open interest.

Example. To get the Bid price for a particular ticker.
The ticker for FTSE100 July Calls at 4025 is ESX-L GM.
I have this ticker in a table of others. This one is in cell C43.
To get the Bid Price for this ticker into cell G43, the code is =mtBid(C43)

Glenn
 
rdstagg said:
is my track a subscription data feed?

Yes. Sorry I thought you knew.
Cost varies depending on which exchanges you need data from.
Mytrack silver service is $19.98 per month. Add on exchange fees.
www.mytrack.com

Glenn
 
Glenn said:
It would seems easy enough to produce the code for the shift using the Record Macro feature.
e.g Highlight the cells you want to shift down
Copy and paste them one row lower.

Glenn


How does that help automate a shift down every 5 minutes ?
 
ColinRiche said:
How does that help automate a shift down every 5 minutes ?

You previously said "i can use the "Now" and "Minute" excel references for the timing "
So I assumed you already had a routine for the timing part.
Is that not the case ?

If you have a routine, then you could embed it in the macro that you record to do the shift.
If you don't ,then I'd have to go and look from scratch.

Many many years ago I was a Programmer.
Up on the wall was a big sign "Do Not Assume !".
I've been assuming too much today it seems :)
Glenn
 
i better make myself clear....

Excel is completely dynamic and as far as i can see has no way to store variables
except with the use of macros or VB etc.

eg.
Lets suppose i want an alert when a new high is made i might use the following...

= if Last > High then Alert

But this would never alert cos as soon as the Last cell has made a new High
the value is entered in the High cell - any other calculation would have a circular action

So when you have a live data feed into excel all referenced cells are affected
The way sierra gets around this is to shift the live data down and thus storing it for chart use etc.

Unless i am wrong there's only 2 ways to do it - the shift down method macro or variables in vb/macro

it would be easy if there was a comand that tracks if a cell changes
 
Last edited:
It depends on the datafeed because some datafeeds include "Last" and "High" as data that can be displayed so it would be possible if that is the case.


Paul
 
I can only tell that it was not for D4Free the last time I enquired (about a year ago) .They did not then have have DDE capability in their offering and said they were unlikely to include it

dick_dastardly said:
Does anyone know if it is possible to extract price data from a SB Co data feed using Visual Basic and if so how ?
 
In the D4F blotter, there is a print blotter option. Has anyone managed to get it print to file? It would be quite good to be able to get the executions info out as a txt file or similar.
 
Top