I use scatter charts and trendlines a lot to derive formulas from real data.. Excel then prints the formula it used on the chart. However, when I use this formula with the same data set the values always differ and I have to massage the formula to make it represent the data. What am I doing wrong here?

Thanks for your help.

]]>

Please provide me the sample material (Test bank of few chapter)so that i can purchase?

Please answer me the price as well.

]]>

A1= 0.0001473

A2= 0.0001620

I want to find the difference when I have a Long Sale and the Difference

when I have a Short Sale. I then want to calculate the % Profit/Loss for

a Short Sale and a Long Sale.

In a long position If my entry price is A1 and my Exit Price is A2, I am

using these two formulas:I

Long Sale A1-A2 = Profit/Loss

Short Sale A2-A1 = Profit/Loss

If I have a Stop Loss of 10% on my Entry amount I calculate these values

for a Long and Short position:

Long Stop Loss 0.0001620

Short Stop Loss 0.0001326

What is the formula to calculate my profit or loss for a Long and Short

position based on the values in cells A1 and A2?

I'm currently using (A1-A2)/A2 for the Long position

and

(A2-A1)/A1 for the Short position, but if I get stopped out at exactly

my 10% value above, I would expect to have a 10% loss. The formulas

above are not returning a 10% value.

Any help would be appreciated.

]]>

Please find attached sheet

I would need to create two pivot table with the below column headings

Pivot table 1

Column heading- Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16

Pivot table 2

Column heading 2015 2015 TOTAL 2016

Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16

I tired converting my raw date column to DATE(YEAR(B#),MONTH(B#),1), but it is not working

PLease advise

and does a few calculations for profit/loss and stop loss calculations.

While a trade is ACTIVE, I want to monitor just the ACTIVE trades on

another Tab.

On this new Sheet called ACTIVE TRADES I have values for:

Risk, Initial Price, Initial Stop Loss, Current Price, Modified Stop

Loss. I am populating this Active Trades Sheet by determining, if the

Exit Price from my All Trades Sheet is empty. If this value is blank,

then the trade is considered active. This is working just fine for me.

However, the other values for Risk, Initial Price, Initial Stop Loss are

showing in their respective columns, because I have formulas that

populate regardless to the value shown in Exit Price. Is there a more

elegant way to just track my Active trades on another Sheet within the

same Workbook, without doing what I have done above.

I've been doing some research on arrays and vlookup, but I'm not sure if

these are the proper methods to do what I want to do.

]]>

Using Excel from, I think, 2007, and Windows 10.

Haven't used in a while, and I am probably forgetting things, but

this is really confusing me.

If anyone can help me out, would be most appreciative.

Plotting Blood p:

Column A has dates.

Column B has pressure.

Really a simple setup.

Scatter graph is desired, with straight lines between the actual points.

Lets say I have 10 dates.

If I select these 10 to plot, no problem.

Does it all nicely.

But if I select, e.g., 15 rows to Plot, with

the last five being Blank, it won't do it.

In the "Select Data", the dates only show for the first case, where

there is actual data in the cells.

What am I missing (as usual), or doing wrong ?

I would really like to have the resultant graph set up

to encompass a wide range of dates, even though we may have no data

filled in (yet) for many of them.

Happy Holidays, and thanks,

Bob

]]>