logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
alcontes  
#1 Posted : Tuesday, April 13, 2010 7:16:29 AM(UTC)
alcontes

Rank: Newbie

Groups: Registered, Registered Users
Joined: 4/13/2010(UTC)
Posts: 3

I would create an indicator for plotting current rally from 05/02/2010 to today, back from low of 03/09/2009 in rate of change using S&P-500 data.Thanks

Alfonso

wabbit  
#2 Posted : Tuesday, April 13, 2010 7:25:40 AM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
You can use Google Translate to convert your language which may give us a better opportunity to understand more fully what help you need.

--

È possibile utilizzare Google Translate per convertire il vostro linguaggio che può darci una migliore opportunità di comprendere più pienamente che cosa avete bisogno di aiuto.

Click here

wabbit [:D]
alcontes  
#3 Posted : Wednesday, April 14, 2010 3:12:20 AM(UTC)
alcontes

Rank: Newbie

Groups: Registered, Registered Users
Joined: 4/13/2010(UTC)
Posts: 3

I want to create an indicator that shows the percent rally past with those of today
wabbit  
#4 Posted : Wednesday, April 14, 2010 3:57:44 AM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
I still don't understand what it is you are looking for?

Maybe you could attach an annotated chart for demonstrate what you need; other than that, the usual advice applies, read the MS Users Manual and attempt to code this for yourself, posting your best attempt here if you get stuck.



wabbit [:D]

alcontes  
#5 Posted : Wednesday, April 14, 2010 4:12:00 AM(UTC)
alcontes

Rank: Newbie

Groups: Registered, Registered Users
Joined: 4/13/2010(UTC)
Posts: 3

I want to put the minimum of S&P-500 ,the 02/08/2010 from minimun of 07/10/2009 so you can compare the rise of this year with last year. so as to superimpose the two increases from a single minimum.
wabbit  
#6 Posted : Wednesday, April 14, 2010 5:51:47 AM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
You will need to employ the ValueWhen() function, with the time and date functions to define the start date(s). You will also need to call these values using the Security() function if you want to display the index values on the constituent charts.


wabbit [:D]

Users browsing this topic
Guest (Hidden)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.