|
發表於 2011-4-6 00:21:32
|
顯示全部樓層
<P>雖然圖看不到,不過校長的解說非常清楚</P>: g: U! c' h/ l6 a6 D
<P>加上 <A href="http://www.ntd2u.net/viewthread.php?tid=4571">這一篇“黃金切割率的線性與半對數excel表”</A></P>
. U# i; L2 E5 L* \7 g' x+ K<P>昨天因為剛入學無法下載那篇的Excel,就自己依樣畫葫蘆寫了一個一樣的Excel</P>
/ p- u* a" o/ M' [1 |4 I<P> </P>
7 X' M' W1 ~7 ?+ @8 S+ O/ @<P>這裡把公式整理一下:</P>
7 L* m& d2 E/ X/ M0 e0 C9 m. |<P>A-低點 B-高點</P>9 k9 F+ P t6 o- ]' V- |1 e
<P>從 A--》B 回檔目標點的股價對數算法:</P>
% s2 `2 u( f2 W. a p4 i1 H<P> </P>
* g; b* @. j* `! b1 ^<P>A-->B區間回檔 0.191: 10^(LOG(B)-((LOG(B)-LOG(A))*0.191))</P>
3 z0 u0 s7 \: p E<P>A-->B區間回檔 0.382: 10^(LOG(B)-((LOG(B)-LOG(A))*0.382))</P>( @& O' C* Q5 h$ E' u3 ~
<P>A-->B區間回檔 0.5: 10^(LOG(B)-((LOG(B)-LOG(A))*0.5))</P>
0 C. k; l! `2 O4 q$ ]<P>A-->B區間回檔 0.618: 10^(LOG(B)-((LOG(B)-LOG(A))*0.618))</P>
3 w2 v" `" a2 v7 K<P>A-->B區間回檔 0.809: 10^(LOG(B)-((LOG(B)-LOG(A))*0.809))</P>
* o' A. m; R! e6 h<P> </P>" R1 C; y n9 ` ]3 }* x E9 s' t, q
<P>化簡後公式為:</P>7 y7 H- N O( `1 |9 v3 `
<P>A-->B區間回檔 0.191: 10^(LOG(B)*0.809+LOG(A)*0.191)</P>
5 @$ ~5 x& ^- |7 C<P>A-->B區間回檔 0.382: 10^(LOG(B)*0.618+LOG(A)*0.382)</P>
" o; e1 [6 ?! o J; X<P>A-->B區間回檔 0.5: 10^((LOG(A)+LOG(B))*0.5) = SQRT(A*B)</P>/ h% X% o6 V& o/ F7 m7 x
<P>A-->B區間回檔 0.618: 10^(LOG(B)*0.382+LOG(A)*0.618)</P>
" b6 ]+ V) v! H- f- o" N9 \( `<P>A-->B區間回檔 0.809: 10^(LOG(B)*0.191+LOG(A)*0.809)</P>
& m# ~0 \0 [6 r' V9 g<P> </P> |
|