Howard, Thanks. That did exactly what I wanted. Donald F Lindberg -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Howard Hansen Sent: Wednesday, September 05, 2007 8:07 AM To: [email protected] Subject: Re: [quotes-plus] Importing my Quotes Plus Data into Excel
Use the value of 0 to access the data for the most recent data for a particular stock in the Quotes Plus database. The value of Day goes from 0 to approximately -2500 . An index of -2500 refers to the oldest data in the Quotes Plus database. Example: =qp_close(0, A4) gets the most recent closing price for the stock symbol stored in cell A4 and =qp_date(0, A4) gives you the closing price date. =qp_close(-5, A6) gets the closing price 6 days back in the database for the stock symbol stored in cell A6 and =qp_date(-5, A6) gives you the date that corresponds to 6 days back in the Quotes Plus database. Howard Don Lindberg wrote: > > Gary, > > Thanks, I found it and it works great. One question though. Several of > the functions ask for a value DAY. The only thing that seems to work > is an actual date, but I want it to reference the current date each > time I update. I have tried pointing it to a cell that has the TODAY() > function, but it doesn't like that and errors out. So how do I put a > dynamic date into these functions? > > Thanks, > > Donald F Lindberg > > ------------------------------------------------------------------------ > > *From:* [email protected] > [mailto:[EMAIL PROTECTED] *On Behalf Of *gary > *Sent:* Tuesday, September 04, 2007 6:16 PM > *To:* [email protected] > *Subject:* Re: [quotes-plus] Importing my Quotes Plus Data into Excel > > Hi > > It's described in the help file. Just go to start - programs - quotes > plus - QP Help File. > > Look in the Integration with Microsoft Excel section. > > Basically, just load the qp21com.xla file that's in the C:\Quotes Plus > Data\Excel directory. > > Then all of the qp functions will be available in your spreadsheets. > > Best regards > > Gary > > ----- Original Message ----- > > *From:* Don Lindberg <mailto:[EMAIL PROTECTED]> > > *To:* [email protected] > <mailto:[email protected]> > > *Sent:* Tuesday, September 04, 2007 6:03 PM > > *Subject:* [quotes-plus] Importing my Quotes Plus Data into Excel > > I have seen referances to the ability to directly import data from > the > QP database to Excel, but have not been able to find out how to do > this. Can someone explain the process to me and tell me for add-in or > other program I may need? > > Thanks in Advance, > Don Lindberg > > Yahoo! Groups Links
