Tenspeed39355
01-20-2005, 01:37 PM
I am using an indicator named RSI. RSI tells me if a fund is at a low MKT price.
Here is what I have done so far. In Book1, Sheet1,A1 I can enter a fund symbol.
I then do a copy in A1 then go to Book1, Sheet2 and enter Past Special, and link. I go back to Book1, Sheet1, B1 and do a link to K30 which is the RSI number. When I type in a new fund symbol in Sheet1,A1 the symbol in Book1,
Sheet2 changes to the new symbol and the RSI number in K30 changes and puts
the new number in Sheet1,B1. All this is what I want. Here is the problem I can
not slove. I want to put a number of fund symbols Sheet1,A1,A2,A3 and so on.
How can I get the RSI number to change when I do a pull down in B1. Is there a
way to get the RSI in K30 to change and put the new RSI in each symbol. Thanks in advance. I hope this makes some sense to you.
Max:yes
Here is what I have done so far. In Book1, Sheet1,A1 I can enter a fund symbol.
I then do a copy in A1 then go to Book1, Sheet2 and enter Past Special, and link. I go back to Book1, Sheet1, B1 and do a link to K30 which is the RSI number. When I type in a new fund symbol in Sheet1,A1 the symbol in Book1,
Sheet2 changes to the new symbol and the RSI number in K30 changes and puts
the new number in Sheet1,B1. All this is what I want. Here is the problem I can
not slove. I want to put a number of fund symbols Sheet1,A1,A2,A3 and so on.
How can I get the RSI number to change when I do a pull down in B1. Is there a
way to get the RSI in K30 to change and put the new RSI in each symbol. Thanks in advance. I hope this makes some sense to you.
Max:yes