Pivot tables should work buddy
Handy tips:
Select date as field, click in column, then go design tab & use group data and choose months.
Then drag down returns 3 - set one as average, another as min and max.
Refer to attachment.
sorry the first sheet was missing the middle formula - use this one: View attachment 54172
Instead of confirming the formula with the Enter key, you need to use the triple combo Ctrl-Shift-Enter.SUMIF(F21:F69*(E21:E69+L21:L69)+J21:J69*(I21:I69+M21:M69),K21:K69>today()-30))
I tried the above but I have an error...I know that what your saying is correct, I am just not implementing it correctly.
How would I calculate a max drawdown in excel. say ive got 50 trades and 50 results from those trades ranging from say -10 to +100. How would I calculate maxDD?
Hi Gurus.
How would I use two cells in an IF statement,
for example IF A1=MON and B2 <1 then B2
My Excel knowledge is very basic. Could someone please advice.
Is there is a way to separate rows by the colours? As attached.
1. Insert a header row above all the data. Call them Code and Company Name (Or Paul and Mary if you so desire).
2. Highlight all the data including the header row, and apply auto filter (Keyboard shortcut Ctrl-D, F, F).
3. Click the drop down arrow and select sort by colour.
This is a very useful method to do temporary sorting of data.
Nice! Thanks.
This sorts out one colour at a time so just have to go through step 3 until all colours are individually sorted.
Have just done a forced upgrade to a new setup - and with that comes an upgrade to Office 2013. I run a data feed (webIress) into excel, but since upgrading I can't seem to get the add-in to show up.
Does anyone else have experience with getting the add-in to work in Excel 2013?
So far it looks like I'll be rolling back to 2010.
I too have been rolling back to 2010.
Many features of the new version aren't backwards compatible. After finding some changes that rendered activation of worksheets within workbook unusable, I simply gave up looking for a solution and reverted to the version that was consistently doing what my (macro) programs told it to do.
Meanwhile, I have verified that 2010 is also still working beautifully under Windows 10. Suits me.
I too have been rolling back to 2010.
After finding some changes that rendered activation of worksheets within workbook unusable, I simply gave up looking for a solution and reverted to the version that was consistently doing what my (macro) programs told it to do.
I installed it a few weeks ago but reverted back within half an hour as it was so slow that I was having lag between hitting the keyboard and seeing characters appear on the screen - very frustrating.
I have some statistical analysis that i need done on a few markets. Is there anyone that feels they have the Excel skills to do this if i provide the data?
Of course i would be assuming there would be an hourly rate for this work.
Please PM if you can back-test basic strategies or compile statistics using Excel.
Cheers,
CanOz
Hi Can,
Price series data, or more like economic data and ratios etc?
All price series data...
I've actually found an eLancer. There is another forum where they share stats on thier markets, a bit of a combined quantitative study thread...very helpful. I'd be willing to contribute what i pay to have done if other commit to doing the same.
CanOz
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?