HomeReady-2-GoPortfolioRankingScreenerStockETFToolsCommunityHelp
ForumsEmail UserPollsFeature RequestsGroups


  Index  | Recent Threads  | Who's Online  | User List  | Search
  Search  
Quick Go »
Thread Status: Normal
Total posts in this thread: 10
[Request a Feature] [Post new Thread]
[Add To My Favorites] [Watch this Thread]
Author
Previous Thread This topic has been viewed 632 times and has 9 replies Next Thread
DennyHalwes
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 28, 2004
Posts: 1532
Status: Offline
confused   When will we have actual open prices? Reply to this Post
Reply with Quote

Marco,

Will you give us an educated guess as to when you will be able to update the open prices to the actual open price?
I want to postpone re-running my ranking systems and Sims until that can be accomplished.

Denny cool
----------------------------------------
"The significant problems we face cannot be solved at the same level of thinking that we were at when we created them". Albert Einstein
[Jul 10, 2012 10:53:34 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
DennyHalwes
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 28, 2004
Posts: 1532
Status: Offline
Re: When will we have actual open prices? Reply to this Post
Reply with Quote

Bump

Marco?
----------------------------------------
"The significant problems we face cannot be solved at the same level of thinking that we were at when we created them". Albert Einstein
[Jul 18, 2012 11:01:45 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
marco


UNITED STATES
Joined: Jan 1, 1970
Posts: 3989
Status: Online

Re: When will we have actual open prices? Reply to this Post
Reply with Quote

It's two projects in one: updating prices around 10PM and bringing in the open prices from our IDC historical dump. It's the next project after we flush out the main bugs. Working on IndWeight/SecWeight now which is very important. Certainly by end of next week, hopefully sooner.
----------------------------------------
Portfolio123 Staff
[Jul 19, 2012 1:03:49 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
DennyHalwes
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 28, 2004
Posts: 1532
Status: Offline
smile   Re: When will we have actual open prices? Reply to this Post
Reply with Quote

Thanks Marco, that will be great!

Denny cool
----------------------------------------
"The significant problems we face cannot be solved at the same level of thinking that we were at when we created them". Albert Einstein
[Jul 19, 2012 1:42:26 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
z8735
Advanced Member


UNITED STATES
Joined: May 3, 2006
Posts: 261
Status: Offline

Re: When will we have actual open prices? Reply to this Post
Reply with Quote

Hi Marco, can you please update regarding this one, are the open prices prior to 2004 correct now?
Thanks, Z.
[Jul 30, 2012 11:21:33 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
marco


UNITED STATES
Joined: Jan 1, 1970
Posts: 3989
Status: Online

Re: When will we have actual open prices? Reply to this Post
Reply with Quote

There are two ways to do it, one involves updating Compustat data, the other mirroring the data then updating. Each has its own set of problems. We're asking Compustat what they recommend. Should have something end of this week.
----------------------------------------
Portfolio123 Staff
[Jul 31, 2012 12:45:33 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
DennyHalwes
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 28, 2004
Posts: 1532
Status: Offline
confused   Re: When will we have actual open prices? Reply to this Post
Reply with Quote

Marco,

Any update on actual open prices?
I am holding off re-running most of my Sims, Ports, and Ranking systems until we have open prices back to 1999.

Denny cool
----------------------------------------
"The significant problems we face cannot be solved at the same level of thinking that we were at when we created them". Albert Einstein
[Aug 8, 2012 5:53:17 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
marco


UNITED STATES
Joined: Jan 1, 1970
Posts: 3989
Status: Online

Re: When will we have actual open prices? Reply to this Post
Reply with Quote

Denny,

Compustat suggested we mirror the price data in our own database and update the open prices. Obviously they don't support/like clients manipulating their database, so that any changes that come from them do not over-write ours.

This has merits and drawbacks. I was leaning towards updating their data, so we don't have to worry about keeping two sets of data in synch. I seriously doubt they would make any updates to price data that is 4+ years old since it's not even their data (it's IDC)

However having our own copy of prices has one major advantage. We can populate the last bid/ask since we have that from IDC. This bid/ask spread could be used to automatically compute slippage for each stock. It's not the only way to have a variable slippage calculation (we could look at price, volume, etc) but it's probably the most accurate.

How would you rate that feature to help us decide which course to take ?

Thanks
----------------------------------------
Portfolio123 Staff
[Aug 11, 2012 1:28:11 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
DennyHalwes
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 28, 2004
Posts: 1532
Status: Offline
smile   Re: When will we have actual open prices? Reply to this Post
Reply with Quote

Marco,

I like the idea of using IDC’s data best. Have you considered using your own point in time Reuters’ data? I realize it only starts on 3/31/01.
It would be interesting to run a comparison test between your Reuters’ data and IDC’s data. We might be surprised by what you find!

Denny cool
----------------------------------------
"The significant problems we face cannot be solved at the same level of thinking that we were at when we created them". Albert Einstein
[Aug 11, 2012 2:25:04 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
DennyHalwes
Advanced Member
Member's Avatar

UNITED STATES
Joined: Apr 28, 2004
Posts: 1532
Status: Offline
confused   Re: When will we have actual open prices? Reply to this Post
Reply with Quote

Marco,

Will you give us an update of when we can expect to have actual open prices prior to 08/27/2004?

Thanks,
Denny cool
----------------------------------------
"The significant problems we face cannot be solved at the same level of thinking that we were at when we created them". Albert Einstein
[Sep 20, 2012 1:24:44 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
[Show Thread Printable Version] [Post new Thread]

Free Trial  /  Log In
Username or Email
Password
Stay logged in
Can't remember username or password?