live price in excel cell

rdstagg

Active member
207 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
 

Glenn

Experienced member
1,040 118
It is possible.
I use Mytrack to feed live data into Excel. The values in the cells change constantly.
Glenn
 

rdstagg

Active member
207 3
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
 

ColinRiche

Well-known member
284 3
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
 

Glenn

Experienced member
1,040 118
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:

Glenn

Experienced member
1,040 118
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
 

rdstagg

Active member
207 3
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
 

Glenn

Experienced member
1,040 118
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
 

ColinRiche

Well-known member
284 3
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 ?
 

Glenn

Experienced member
1,040 118
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
 

ColinRiche

Well-known member
284 3
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:

Trader333

Moderator
8,641 969
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
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock