mmbandurin:
Let's keep this one on the list, this way maybe someone can make this
a little clearer for you. You emailed me the following:
About Quotes Plus Display Charts:
My My friends
File Version: 3,0,0,7 2,2,15,1
QP2 Release 3.1 2.2
Build 3,1,0,0 2,2,8,10
---------------------------------------
For example: =qp_close(date,"AGIX") excel function
---------------------------------------
11.20.06 12.8400 12.8359375
11.17.06 12.8500 12.84375
11.16.06 12.9000 12.8984375
11.15.06 12.9000 12.8984375
11.14.06 12.7200 12.71875
11.13.06 12.9200 12.9140625
The results that you are showing appear to be the type of differences
that you will get between the various versions of any program and are
the result of internal rounding and/or the use of different types of
variable in the programs.
You are using the qp21com.xla version of the add-in. It is possible
that your friend is using the older qp add-in. My take on this is
that until you and your friend are using the same versions of QP and
Excel you just have to live with these minor diffences.
To make these seem closer try formatting to two decimal places in
Excel using the number or money format.
This isn't rocket science and as such certainly rounding errors are
acceptable to most of us.
Dale
--- In [email protected], "optiontrader3290" <[EMAIL PROTECTED]>
wrote:
>
> mmbandurin:
>
> Are you using the scan program or Excel.
>
> From your earlier post it would appear that you are using the excel
add-
> in. My first thought is that you need to format the cells in your
> spreadsheet. However, if you are not getting the same results after
> formatting, I would need to know exactly what are you having
problems
> with.
>
> Please respond with an example of what you are doing, and I will
try to
> help further.
>
> Dale
> --- In [email protected], "mmbandurin" <mmbandurin@>
wrote:
> >
> > Help to understand. My friend too uses a database QP2,
> > only the old version.Results of the tenders at us differ
> > with quantity of decimal signs and
> > are not always equal at a rounding off.How to us to make even our
> data?
> > Thanks.
> >
>
