Announcement

Collapse
No announcement yet.

How do I access a static "Prev" price in Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do I access a static "Prev" price in Excel

    I'm using the SynTools dde to in Excel to access the Previous Closing price data (e.g. =WINROS|PREV!GE). The problem is, during pre-mkt, PREV shows the closing price from the day before yesterday (not yesterday's close). I'd have to use LAST during pre-mkt to get yesterday's close. But after the mkt opens, I'd have to manually switched to PREV to get yesterday's closing price. Is it possible to have PREV (or another identifier) to access yesterday's closing price throughout the day, including pre-mkt?

    Also, along the same topic, the O-H-L prices pre-mkt are also yesterday's prices as well. I think, they should be N/A during pre-mkt when the stock hasn't started trading yet.

    Thanks.
Working...
X