StockFetcher Forums · General Discussion · Converting A Resultant Number To A Percentage<< >>Post Follow-up
gruender
101 posts
msg #26209
Ignore gruender
4/11/2003 4:31:50 PM

Need advice please! I would like to get the dollar (difference) between ema(200) and close, and then convert this dollar difference into a percentage by dividing by the EMA(200). Below is what I used and correctly got the dollar difference put into a results column, but cannot get the percentage. Any ideas?

[close is above 3 and close is below 15 add column ema(200) and add column ema(200) minus close and add column ema(200) minus close divided by ema(200)]



gruender
101 posts
msg #26231
Ignore gruender
4/14/2003 7:51:25 PM

StockFetcher Tom, have you had a chance to review this request? If you don't understand my question, please let me know and I will try again.

Thanks, Joe


tomb
267 posts
msg #26236
Ignore tomb
4/15/2003 9:08:54 AM

Hi Joe,

Thanks for bringing this to our attention. First, StockFetcher doesn't support the nested math operations. This is something we hope to add, but at the moment, it is not possible.

As far as a solution to your problem, I might recommend something similar to the example below:

Fetcher[close is above 3
and close is below 15
and add column ema(200)
and add column ema(200) divided by close
]



Clearly this is not the exact solution that you are looking for, but the behavior should be similar. All cases where the EMA(200) is below the close, you will have a value less than 1. And, all cases where the EMA(200) is above the close, the result will be above 1.

Again, we realize the above isn't the exact solution, but maybe it helps!

Thank you,

Tom
StockFetcher.com Support



hballa
36 posts
msg #161214
Ignore hballa
7/11/2024 5:38:05 PM

Hi Tom, Thanks, In above script, for example TSLL , June 24 & 25 , after MACD cross over above zero line and williams -30 and above above 10 MA line. it exploded.Can you please modify script to capture stocks with the condition since last 3 or 5 days?

StockFetcher Forums · General Discussion · Converting A Resultant Number To A Percentage<< >>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.