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: 5
[Request a Feature] [Post new Thread]
[Add To My Favorites] [Watch this Thread]
Author
Previous Thread This topic has been viewed 705 times and has 4 replies Next Thread
ene100
Member


UNITED STATES
Joined: Sep 9, 2009
Posts: 17
Status: Offline

confused   Is there a way to pull the historical close, adjusted for future splits? Reply to this Post
Reply with Quote

So the Price function backs out any future splits in order to get the actual close price at the time. Is there any way to pull the split-adjusted close? I know that in Screening, "start" and "end" give the split-adjusted close prices for those two dates, but if I then make a custom report that also has Price in it, the basis is different so the "start" and "end" prices aren't comparable with "Price". I searched the function reference but didn't see anything... have I missed it, or is it missing?

Thanks!
[Sep 6, 2010 1:50:38 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
marco


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

Re: Is there a way to pull the historical close, adjusted for future splits? Reply to this Post
Reply with Quote

There's no function at the moment that gives the a price in the past fully adjusted for future splits.
----------------------------------------
Portfolio123 Staff
[Sep 9, 2010 10:27:04 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
ene100
Member


UNITED STATES
Joined: Sep 9, 2009
Posts: 17
Status: Offline

Re: Is there a way to pull the historical close, adjusted for future splits? Reply to this Post
Reply with Quote

Ok, so then it sounds like the best way to get, for example, a 10-day moving average that isn't screwed up by splits is to run a screen with "Price" as one of the fields, on each of the last 10 days. Let me know if there's a cleaner solution... cheers.
[Sep 9, 2010 5:33:58 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
marco


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

Re: Is there a way to pull the historical close, adjusted for future splits? Reply to this Post
Reply with Quote

You didn't mention mov avg before. Mov avgs works just fine. What are you trying to do?
----------------------------------------
Portfolio123 Staff
[Sep 9, 2010 5:38:56 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
ene100
Member


UNITED STATES
Joined: Sep 9, 2009
Posts: 17
Status: Offline

Re: Is there a way to pull the historical close, adjusted for future splits? Reply to this Post
Reply with Quote

I wasn't sure if the moving average function was properly accounting for splits or not. Glad to hear that it does. Is that also true of the per-share ratios such as CashFlPSTTM for example? Thanks.
[Oct 10, 2010 5:25:17 AM] 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?