SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : Metastock 6.0 for Window
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Chris who wrote (3887)4/6/2002 4:27:24 AM
From: Lee Lichterman III  Read Replies (1) of 4056
 
I am trying to build an inflation adjusted price indicator. I have been playing around and can't seem to get the code right no matter what I try.

What I want is a way to take a start price from long ago, say CSCO in 1994 and then take the closing price on "X" date and have an indicator plot a line that shows that price multiplied by a constant, say 3% annual inflation rate to show what that price would be equal to in today's dollars.

I know it won't be perfect since inflation varies but it might be a good exercise to see where certain stocks would be in relation historically corrected for inflation.

I know you can take the Close times a number via

Mul(C,.03)

but how do I tell it to keep multiplying the previous result by .03 each year or 8.2191780821917808219178082191781e-5 each day over and over?

I have one in Excel but it was mainly a lot of hand jamming and want to add this to some charts for display thus I need it automated.

Any help appreciated.

Good Luck,

Lee
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News