StockFetcher Forums · General Discussion · need help with this one, tried everything with no results, THANKS IN ADVANCE<< >>Post Follow-up
billyspradling
13 posts
msg #63616
Ignore billyspradling
6/12/2008 9:36:18 PM

show the % gain or loss of all stocks 1 month ago and add colum {1 month ago}
show the % gain or loss of all stocks 2 month ago and add colum {2 month ago}
show the % gain or loss of all stocks 3 month ago and add colum {3 month ago}
show the % gain or loss of all stocks 4 month ago and add colum {4 month ago}
show the % gain or loss of all stocks 5 month ago and add colum {5 month ago}
show the % gain or loss of all stocks 6 month ago and add colum {6 month ago}
show the % gain or loss of all stocks 7 month ago and add colum {7 month ago}
show the % gain or loss of all stocks 8 month ago and add colum {8 month ago}
show the % gain or loss of all stocks 9 month ago and add colum {9 month ago}
show the % gain or loss of all stocks 10 month ago and add colum {10 month ago}
show the % gain or loss of all stocks 11 month ago and add colum {11 month ago}
show the % gain or loss of all stocks 12 month ago and add colum {12 month ago}



in other words i would like to see the gain or loss of all stocks and post them in columns jan feb mar etc etc etc

THANK A MILLION
BILL

nikoschopen
2,824 posts
msg #63619
Ignore nikoschopen
6/13/2008 1:42:31 AM

Fetcher[
date offset 9
set{ROI, sum(day change,22)}

add column ROI 88 days ago{January (%)}
add column ROI 66 days ago{February (%)}
add column ROI 44 days ago{March (%)}
add column ROI 22 days ago{April (%)}
add column ROI{May (%)}
]


Note the number used for the "date offset". I used 9 because the month of May ended nine trading days ago. You will need to manually count the days since the end of the previous month and change this number accordingly.

guru_trader
485 posts
msg #64165
Ignore guru_trader
6/22/2008 12:35:45 AM

Fetcher[
date offset 5/30/2008
set{ROI, sum(day change,22)}

add column ROI 88 days ago{January (%)}
add column ROI 66 days ago{February (%)}
add column ROI 44 days ago{March (%)}
add column ROI 22 days ago{April (%)}
add column ROI{May (%)}
]



StockFetcher Forums · General Discussion · need help with this one, tried everything with no results, THANKS IN ADVANCE<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus