Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : TA-Quotes Plus -- Ignore unavailable to you. Want to Upgrade?

To: Nine_USA who wrote (8935)	3/12/1999 9:30:00 AM
From: John Schott	Read Replies (1) \| Respond to of 11149

Price on Date I think you might have one of two questions: * To get the price on a date, you really can do it, but as far as I've experienced during a trial last week for another purpose, there is a catch. (Having said that, someone else here will come up with a more elegant way) If you run say: Close(-512) or Date (-512) you'd get the close or date from 512 market days ago. Trouble is, "512 days ago" changes to a different date every market day. Trouble is also, calculating "market days ago" to get a date isn't a QP2 function - and doing it using excel has errors due to holidays, etc. So what I did was a kluge that worked. I did a QP2 run that printed out the date for (-x) where -x was a range of dates to find out the correct x. (Using a manually adjusted (-i) in the form of (-i-x) you can readjust this for any future date you run this on - getting a price list for a group of dates (which is what I was doing when I did this last week)). * If you are really wanting to do TA tests, you can do them in the same manner. Again, the only problem is that, if you want to test specific dates as opposed to just -x days ago, you have to make a daily adjustment. The Help on Date() shows only a (0) day date, but any minus number will work. Setting i as an interger variable is shown well. If you want to calculate -x, one what is to make a QP2 report in ASCII that dumps the date out. Then read the report in Financial Suite Beta, QP2 or excel and get the line count number of the dates you want.