% from high quote

[FTSE Beater]

Hi All

I've seen this before, but I can't seem to find it on my Quote Window list.

What it is, is a field figure that is taken from the stocks high and low and works out what % the current price is in relation to the High / Low. So if a stock is at it's low it shows 0 and if it's at it's high it shows 100.

Hope that makes sense. I've seen it before on one of Alan Farley's course so I know it exists....somewhere.

Any help would be great.

[JayF]

FTSE Beater,

This should take care of your needs.

http://forum.esignalcentral.com/showthread.php?s=&threadid=3116&highlight=%2Arange

[FTSE Beater]

Hi Jay

Thanks for that. Is there anyway of getting that information into a Quote window though

Thanks

[ACM]

FTSE Beater
Not that I am aware of
Alex

[JayF]

Unfortunately, not yet. I'm hoping the functionality will be there in 8.0 (Q1, 2004).

You can calculate this in real-time in Excel using DDE. Here's an example...

=WINROS|LAST!'ES Z3' - WINROS|LOW!'ES Z3' / WINROS|high!'ES Z3' - WINROS|LOW!'ES Z3'

[dloomis]

This can be done in the cursor window or the price window with a routine called themometer.efs by Alex.

[FTSE Beater]

Hi all

Thanks for your replies.
I think Excel is the best option

[FibbGann]

When using this reference in excel... Say this code was in column "B" and my symbols are in Column "A" is there a replacement for the "ES Z3" that would automatic refer to the symbol in column "A"? This way one wouldn't have to type in the symbol every time to get the % range? Also, if one could refer a 3rd party that can build some DDE code for esignal?


=WINROS|LAST!'ES Z3' - WINROS|LOW!'ES Z3' / WINROS|high!'ES Z3' - WINROS|LOW!'ES Z3'


Thanks,

Fibbgann

[FibbGann]

Just checking back to see if anyone knows the answer to my prior question.

Fibbgann

[ACM]

FibbGann
You might want to try this thread.
Alex