StockFetcher Forums · General Discussion · math<< >>Post Follow-up
billyspradling
13 posts
msg #108227
Ignore billyspradling
10/1/2012 9:37:00 AM

help please, how does one subtract one column from another
example, subtract column 5, row 1 from column 2 row 1 and add column results

thanks in advance!!!
Betty S.

Kevin_in_GA
4,599 posts
msg #108228
Ignore Kevin_in_GA
10/1/2012 9:51:47 AM

Each column is a separate variable or piece of data, so all you need to do is to define a new user variable as the difference between them.

For example, I create two new user-defined variables (doesn't matter what they are so I'll just use RSI(2) and RSI(4)):

Fetcher[
market is S&P 500
set{variable1, RSI(2)}
set{variable2, RSI(4)}
set{difference, variable1 - variable2}

add column variable1
add column variable2
add column difference
]



Now I could just forego the first two variables and make a single variable instead:

Fetcher[
market is s&p 500
set{difference, RSI(2) - RSI(4)}
add column difference

sort on column 5 descending
]



Note here that I simply used the values for variable 1 and 2 instead of defining them first. Also, I added a new line "sort on column 5 descending". Any added columns start at #5 and are assigned numbers based on the order they are used in the filter.

Hope this helps.

StockFetcher Forums · General Discussion · math<< >>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 2022 - 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


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.