InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
Subscribe Login/Register
S&P 500
5,464.62
(
-0.16%
)
US TECH 100
19,220.00
(
-0.20%
)
Dow Jones
39,150.33
(
0.04%
)
Brent Oil
84.39
(
0.00%
)
Bitcoin
64,231.81
(
0.22%
)
Post# of 47132
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Adam

Send PM Follow Ignore
Followers 2
Posts 1276
Boards Moderated 0
Alias Born 11/10/2003

Adam

Re: Vitaali post# 44222

Monday, 02/24/2020 11:51:49 AM

Monday, February 24, 2020 11:51:49 AM

Post# of 47132
Hi Vitali, I did the spreadsheet modification a long time ago but my formula for the PC multiplication factor is as follows:

1+ (date1-date0)/365 * %inc/100

where date0 is the initial date, date1 is the next date, and %inc would be 20 in your case.

My date is in format 2/24/20 and you must define that as a date in Excel

In other words if you subtract two dates in excel it's equal to the number of days difference.

Adam
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.

Sign Up