Forum

I noticed when I pull out the either

ticker.GetProperty("Last Trade")
or
ticker.GetProperty("Last Update")

The value is a number that I can use with VBScript functions like Hour(), Month(), Day() etc.

[2724] DebugTrace: Last Updated [2006-6-10 11:46:44]
[2724] DebugTrace: Last Trade [2006-6-10 16:54:0]

In the above trace you can see that last update is Saturday at 11:46am. It shows Last Trade as the same date, but some time in the future. Right now as I write this it is 11:58am.

I'm guessing that the time is from the previous day of trading on Friday. Is there a way to get a full date & time stamp of the last trade?

Here's the script.

sLastUpdate = ticker.GetProperty("Last Update")
sLastTradeTime = ticker.GetProperty("Last Trade")

ts = sLastUpdate
sMyDate = Year(ts) & "-" & Month(ts) & "-" & Day(ts) & " " & Hour(ts) & ":" & Minute(ts) & ":" & Second(ts)
Application.DebugTrace "Last Updated [" & sMyDate & "]"

ts = sLastTradeTime
sMyDate = Year(ts) & "-" & Month(ts) & "-" & Day(ts) & " " & Hour(ts) & ":" & Minute(ts) & ":" & Second(ts)
Application.DebugTrace "Last Trade [" & sMyDate & "]"

Any thoughts?
Thanks.
-Steve

 

-Steve

PSS is reporting the last trade value that is returned to us by the prophet.net interface, so if they are reporting the wrong date then I will notify them. I will have to try to reproduce the problem next weekend to confirm.
      
Anatoly Ivasyuk
DTLink Software

Thanks for looking into it.

-Steve
      
-Steve

Maybe I'm missing something? I'm sitting here watching the stream data in one of the portfolios. Lots of updates happening as expected. Last Trade is stuck at 15:28:00 and Last Update is stuck at 06/13 12:44

They just aren't changing even though I see lots of trades coming in.

PSS
version 7.3.1 (build 293) server parameters 2.6.7 serial #36298

-Steve
      
-Steve

How many tickers do you have in that portfolio? Are the price or bid/ask fields changing for those tickers?
      
Anatoly Ivasyuk
DTLink Software

I had three.

MSFT, AMZN and ACXM

I'm not sure about Bid/Ask specifically. Lots of #'s where changing on the screen, but was focused on the Update and Trade time which was not changing. When I look back at the log I generated, the Bid and Ask times where changing, but I'm not sure about what was on the screen.

When I get back home tomorrow I'll let it run again and see about Bid/Ask on the screen.

-Steve
      
-Steve

I'm doubting what I saw now on my laptop? I watching in my desktop at home at the updates are working... however...

I have the following Columns.
Symbol, Price, Change, High, Low, Volume, Last Update, Last Trade, Bid, Ask and Last Size.

I am getting frequent changes on Price, Change, Volume, Bid, Ask and Last Size.

The Last Trade value seem to be accurate to the minute, not the second. All LastTrade times have XX:XX:00 where 0 never changes, even though there are many trades every minute.

Must be a resolution thing from Prophet?

 
      
-Steve

> Must be a resolution thing from Prophet?

Actually no, this one is our fault, and it's already fixed in the upcoming PSS 7.3.2 release.

-Anatoly
 
      
Anatoly Ivasyuk
DTLink Software