Altes Elliott-Wellen-Forum - Excel-Jeanie-Text

Toby0909

23.03.2007, 17:47

Excel-Jeanie-Text

Thread gesperrt

-->Hab ich mir jetzt auch mal geholt und muss ich hier nun mal testen, ob es geht:

Analysen <table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt;"> <colgroup><col style="font-weight:bold; width:30px;" /><col style="width:95px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:26px;" /><col style="width:80px;" /><col style="width:26px;" /><col style="width:50px;" /><col style="width:58px;" /><col style="width:40px;" /><col style="width:93px;" /><col style="width:80px;" /><col style="width:21px;" /><col style="width:40px;" /><col style="width:27px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt;"><td > </td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td><td >Q</td><td >R</td><td >S</td><td >T</td><td >U</td><td >V</td><td >W</td><td >X</td><td >Y</td><td >Z</td><td >AA</td><td >AB</td><td >AC</td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center;" >12</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt;"> </td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt;">Max</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt;">Min</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center;" >13</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt;">Wochenanzahl</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:right;">3</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:right;">9</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center;" >14</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt;">Portfoliostart</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt; text-align:right;">100</td><td style="background-color:#ffff99; font-weight:bold; font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-weight:bold; font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center;" >15</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center;" >16</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;">DD-Berechnung</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center;" >17</td><td style="font-size:8pt;">Wochenwert</td><td style="font-size:8pt;">Maximum</td><td style="font-size:8pt;">Minimum</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;">Datum</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;">Signal</td><td style="font-size:8pt;">Signal</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> Portfolio </td><td style="font-size:8pt;">Entwicklung</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> SH </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;">Datum</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;">Wochenwert</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;">Maxwert</td><td style="font-size:8pt;"> DD in Euro </td><td style="font-size:8pt;">DD in %</td><td style="font-size:8pt;">Max DD</td><td style="font-size:8pt;">Max DD in %</td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center;" >18</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center;" >19</td><td style="background-color:#ccffff; font-weight:bold; font-size:8pt; text-align:right;">114,12</td><td style="font-size:8pt; text-align:right;">0</td><td style="font-size:8pt; text-align:right;">0</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">31.12.1971</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">-1</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">                     100,00 â‚¬ </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">        -     </td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">31.12.1971</td><td style="font-size:8pt;"> </td><td style="background-color:#ccffff; font-weight:bold; font-size:8pt; text-align:right;">473,5</td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td><td style="font-size:8pt;"> </td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center;" >20</td><td style="background-color:#ccffff; font-weight:bold; font-size:8pt; text-align:right;">116,05</td><td style="font-size:8pt; text-align:right;">114,12</td><td style="font-size:8pt; text-align:right;">114,12</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">07.01.1972</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">1</td><td style="font-size:8pt;">Kaufen</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">                     100,00 â‚¬ </td><td style="font-size:8pt; text-align:right;">0,00%</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">          1   </td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">07.01.1972</td><td style="font-size:8pt;"> </td><td style="background-color:#ccffff; font-weight:bold; font-size:8pt; text-align:right;">476,8</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">                100,00 â‚¬ </td><td style="font-size:8pt; text-align:right;">                         -     </td><td style="font-size:8pt; text-align:right;">0,00%</td><td style="font-size:8pt; text-align:right;">                         -     </td><td style="font-size:8pt; text-align:right;">0,00%</td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center;" >21</td><td style="background-color:#ccffff; font-weight:bold; font-size:8pt; text-align:right;">116,74</td><td style="font-size:8pt; text-align:right;">116,05</td><td style="font-size:8pt; text-align:right;">114,12</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">14.01.1972</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">1</td><td style="font-size:8pt;">Kaufen</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">                     100,00 â‚¬ </td><td style="font-size:8pt; text-align:right;">0,00%</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">        -     </td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">14.01.1972</td><td style="font-size:8pt;"> </td><td style="background-color:#ccffff; font-weight:bold; font-size:8pt; text-align:right;">476,8</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">                100,00 â‚¬ </td><td style="font-size:8pt; text-align:right;">                         -     </td><td style="font-size:8pt; text-align:right;">0,00%</td><td style="font-size:8pt; text-align:right;">                         -     </td><td style="font-size:8pt; text-align:right;">0,00%</td></tr><tr style="height:15px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center;" >22</td><td style="background-color:#ccffff; font-weight:bold; font-size:8pt; text-align:right;">117,21</td><td style="font-size:8pt; text-align:right;">116,74</td><td style="font-size:8pt; text-align:right;">114,12</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">21.01.1972</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">1</td><td style="font-size:8pt;">Kaufen</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">                     103,88 â‚¬ </td><td style="font-size:8pt; text-align:right;">3,88%</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">        -     </td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">21.01.1972</td><td style="font-size:8pt;"> </td><td style="background-color:#ccffff; font-weight:bold; font-size:8pt; text-align:right;">495,3</td><td style="font-size:8pt;"> </td><td style="font-size:8pt; text-align:right;">                103,88 â‚¬ </td><td style="font-size:8pt; text-align:right;">                         -     </td><td style="font-size:8pt; text-align:right;">0,00%</td><td style="font-size:8pt; text-align:right;">                         -     </td><td style="font-size:8pt; text-align:right;">0,00%</td></tr></table> <table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000;"><tr><td >Formeln der Tabelle</td></tr><tr><td ><table border ="1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Zelle</td><td >Formel</td></tr><tr><td >H19</td><td >=MAX(INDIREKT("g"&A18):INDIREKT("g"&B19))</td></tr><tr><td >I19</td><td >=MIN(INDIREKT("g"&A18):INDIREKT("g"&C19))</td></tr><tr><td >P19</td><td >=H14</td></tr><tr><td >H20</td><td >=MAX(INDIREKT("g"&A19):INDIREKT("g"&B20))</td></tr><tr><td >I20</td><td >=MIN(INDIREKT("g"&A19):INDIREKT("g"&C20))</td></tr><tr><td >M20</td><td >=WENN(G20>H20;1;WENN(G20<I20;-1;M19))</td></tr><tr><td >N20</td><td >=WENN(M20=(1);"Kaufen";"Verkaufen")</td></tr><tr><td >P20</td><td >=WENN(M19=-1;P19;(W20-W19)/W19*P19+P19)</td></tr><tr><td >Q20</td><td >=P20/$P$19-1</td></tr><tr><td >Y20</td><td >=MAX($P$19:P20)</td></tr><tr><td >Z20</td><td >=WENN(P20<Y20;Y20-P20;0)</td></tr><tr><td >AA20</td><td >=Z20/Y20</td></tr><tr><td >AB20</td><td >=(MAX($Z$20:Z20))</td></tr><tr><td >AC20</td><td >=(MAX($AA$20:AA20))</td></tr><tr><td >H21</td><td >=MAX(INDIREKT("g"&A20):INDIREKT("g"&B21))</td></tr><tr><td >I21</td><td >=MIN(INDIREKT("g"&A20):INDIREKT("g"&C21))</td></tr><tr><td >M21</td><td >=WENN(G21>H21;1;WENN(G21<I21;-1;M20))</td></tr><tr><td >N21</td><td >=WENN(M21=(1);"Kaufen";"Verkaufen")</td></tr><tr><td >P21</td><td >=WENN(M20=-1;P20;(W21-W20)/W20*P20+P20)</td></tr><tr><td >Q21</td><td >=P21/$P$19-1</td></tr><tr><td >S21</td><td >=WENN(M21=M20;0;1)</td></tr><tr><td >Y21</td><td >=MAX($P$19:P21)</td></tr><tr><td >Z21</td><td >=WENN(P21<Y21;Y21-P21;0)</td></tr><tr><td >AA21</td><td >=Z21/Y21</td></tr><tr><td >AB21</td><td >=(MAX($Z$20:Z21))</td></tr><tr><td >AC21</td><td >=(MAX($AA$20:AA21))</td></tr><tr><td >H22</td><td >=MAX(INDIREKT("g"&A21):INDIREKT("g"&B22))</td></tr><tr><td >I22</td><td >=MIN(INDIREKT("g"&A21):INDIREKT("g"&C22))</td></tr><tr><td >M22</td><td >=WENN(G22>H22;1;WENN(G22<I22;-1;M21))</td></tr><tr><td >N22</td><td >=WENN(M22=(1);"Kaufen";"Verkaufen")</td></tr><tr><td >P22</td><td >=WENN(M21=-1;P21;(W22-W21)/W21*P21+P21)</td></tr><tr><td >Q22</td><td >=P22/$P$19-1</td></tr><tr><td >S22</td><td >=WENN(M22=M21;0;1)</td></tr><tr><td >Y22</td><td >=MAX($P$19:P22)</td></tr><tr><td >Z22</td><td >=WENN(P22<Y22;Y22-P22;0)</td></tr><tr><td >AA22</td><td >=Z22/Y22</td></tr><tr><td >AB22</td><td >=(MAX($Z$20:Z22))</td></tr><tr><td >AC22</td><td >=(MAX($AA$20:AA22))</td></tr></table></td></tr></table> Excel Tabellen im Web darstellen >> <a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>

Toby

Toby0909 23.03.2007, 17:48 @ Toby0909	ja ist das geil.... und so einfach! owT (o.Text)
	-->

Toby0909 23.03.2007, 17:49 @ Toby0909	@Uwe - ich kann das jetzt auch! owT (o.Text)
	-->

Excel-Jeanie-Text

ja ist das geil.... und so einfach! owT (o.Text)

@Uwe - ich kann das jetzt auch! owT (o.Text)