StockFetcher Forums · General Discussion · mid price?<< >>Post Follow-up
30knotwind
9 posts
msg #105468
Ignore 30knotwind
3/16/2012 11:56:26 AM

I want to do some calculations on the middle price, i.e. the average between the high and the low of each day. Does Stock Fetcher have a function for that? Something like MID(1) would be the average price of today's range.

duke56468
683 posts
msg #105470
Ignore duke56468
3/16/2012 12:21:30 PM

Maybe this

Fetcher[
Market is S&P 500
set{t,high-low}
set{mid,t/2}
add column mid
]



30knotwind....are you a kiteboarder or a windsurfer?

30knotwind
9 posts
msg #105471
Ignore 30knotwind
3/16/2012 12:28:31 PM

Thanks, I'll give it a try. Ideally I want to check if today's low is above yesterday's midpoint. I'll work on that with this. IMO, seems like MID would be included with OPEN, HIGH, LOW, CLOSE, as is often the case on other charting packages.

I am a windsurfer in Portland/Hood River, OR. You? My blog is http://gorgewindsurfing.blogspot.com/

Thanks!
Chris

stockfetcher
980 posts
msg #105472
3/16/2012 12:31:16 PM

You can also try:

Fetcher[
low is above day position(0.50,1) 1 day ago
]



Day Position

StockFetcher.com Support

30knotwind
9 posts
msg #105474
Ignore 30knotwind
3/16/2012 12:40:09 PM

Can I see it on the chart? On other packages I have taken the one day moving average of the MID price and offset it one day forward. When charted, it is easy to see if the low is holding above the previous day's MID.

stockfetcher
980 posts
msg #105475
3/16/2012 12:43:52 PM

Fetcher[
set{mydpos, day position(0.50,1) 1 day ago}
and draw mydpos on plot price
low is above mydpos
]



StockFetcher.com Support


30knotwind
9 posts
msg #105476
Ignore 30knotwind
3/16/2012 12:50:25 PM

Thanks SF, that looks pretty good. DAY POSITION seems like what I was looking for, just a bit more customizable than expected.
Chris

duke56468
683 posts
msg #105477
Ignore duke56468
modified
3/16/2012 12:55:58 PM

30knotwind....I'm a geriatric kiteboarder on South Padre Island.

30knotwind
9 posts
msg #105478
Ignore 30knotwind
3/16/2012 1:10:05 PM

Duke, sounds like a good set-up! Happy sailing!
C

StockFetcher Forums · General Discussion · mid price?<< >>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.