New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

RSV , K , D #73

Open

joshw378 opened this issue Jun 28, 2019 · 1 comment

joshw378 commented Jun 28, 2019 •

edited

an issue about caculate RSV , K . D value

thanks

Author

joshw378 commented Jul 4, 2019

https://www.moneydj.com/forum/showtopic-43177.aspx
FYI 該討論群組有 user 以 excel 完成的 RSV , KD 計算

A那一行是日期

B那一行是還原淨值
C那一行是RSV(5) 5期不成熟隨機值(5) C4的公式是 =(B4-MIN(B4:B8))/(MAX(B4:B8)-MIN(B4:B8))*100 付制以後,一直拉,然後貼上

D那一行是SMA(RSV(5),5) 快速隨機指標(5,5) D4的公式是 =(SUM(C4:C8)/5) 複製以後,一直拉,然後貼上

E那一行是SMA(SMA(RSV(5),5),3) 慢速隨機指標(5,5,3) E4的公式是 =(SUM(D4:D6)/3) 複製以後,一直拉,然後貼上

F那一行是扣款信號 F4的公式是 =IF(E4<20,"扣款","無") 複製以後,一直拉,然後貼上 20以下會出現扣款, 20以下會出現無

Quote可以直接查圖,但是自己運算式訓練必要的過程,唯有這樣才能真正暸解隨機指標的運用,而不是半桶水的只知道
20以下買,80以上賣

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment