Sonunda formülü ele gecirdik.. :D :D :D
Bunlara birde elli cesit ot ekledikmi tamamdir.
Kebabin lafi olmaz Metin hocam buyur gel salgamda ayarlariz. :)
Aslinda formül üstadlarina bir sorum olacakti bakarken gördüm topigi.
Söyle diyorum kendimize özel bir endeks olustursak icine birkac secme hisse alsak. Bunu nasil yapabiliriz. :düsün:?
eskiden yde için kendi hazırladığım formülü vereyim, bir fikir verebilir...
senetler muhtemelen değişmiştir...
ert art1
Cum(If( Security("AKENR ",C)>Ref(Security("AKENR ",C),-1), 1,0) +
If( Security("AKBNK ",C)>Ref(Security("AKBNK ",C),-1), 1,0) +
If( Security("AKSA ",C)>Ref(Security("AKSA ",C),-1), 1,0) +
If( Security("AKGRT ",C)>Ref(Security("AKGRT ",C),-1), 1,0) +
If( Security("ALARK",C)>Ref(Security("ALARK",C),-1), 1,0) +
If( Security("ARCLK ",C)>Ref(Security("ARCLK ",C),-1), 1,0) +
If( Security("BEKO ",C)>Ref(Security("BEKO ",C),-1), 1,0) +
If( Security("DOHOL ",C)>Ref(Security("DOHOL ",C),-1), 1,0) +
If( Security("DYHOL ",C)>Ref(Security("DYHOL ",C),-1), 1,0) +
If( Security("ENKAI ",C)>Ref(Security("ENKAI ",C),-1), 1,0) +
If( Security("EREGL ",C)>Ref(Security("EREGL ",C),-1), 1,0) +
If( Security("FINBN ",C)>Ref(Security("FINBN ",C),-1), 1,0) +
If( Security("FROTO ",C)>Ref(Security("FROTO ",C),-1), 1,0) +
If( Security("GARAN ",C)>Ref(Security("GARAN ",C),-1), 1,0) +
If( Security("HURGZ ",C)>Ref(Security("HURGZ ",C),-1), 1,0) +
If( Security("IHLAS ",C)>Ref(Security("IHLAS ",C),-1), 1,0) +
If( Security("ISCTR ",C)>Ref(Security("ISCTR ",C),-1), 1,0) +
If( Security("KCHOL ",C)>Ref(Security("KCHOL ",C),-1), 1,0) +
If( Security("MIGRS ",C)>Ref(Security("MIGRS ",C),-1), 1,0) +
If( Security("NETAS ",C)>Ref(Security("NETAS ",C),-1), 1,0) +
If( Security("PTOFS ",C)>Ref(Security("PTOFS ",C),-1), 1,0) +
If( Security("SAHOL ",C)>Ref(Security("SAHOL ",C),-1), 1,0) +
If( Security("SISE ",C)>Ref(Security("SISE ",C),-1), 1,0) +
If( Security("TNSAS ",C)>Ref(Security("TNSAS ",C),-1), 1,0) +
If( Security("TOASO ",C)>Ref(Security("TOASO ",C),-1), 1,0) +
If( Security("TCELL ",C)>Ref(Security("TCELL ",C),-1), 1,0) +
If( Security("TUPRS ",C)>Ref(Security("TUPRS ",C),-1), 1,0) +
If( Security("ULKER ",C)>Ref(Security("ULKER ",C),-1), 1,0) +
If( Security("VESTL ",C)>Ref(Security("VESTL ",C),-1), 1,0) +
If( Security("YKBNK ",C)>Ref(Security("YKBNK ",C),-1), 1,0) +
If( Security("ADNAC ",C)>Ref(Security("ADNAC ",C),-1), 1,0) +
If( Security("AKCNS ",C)>Ref(Security("AKCNS ",C),-1), 1,0) +
If( Security("ALGYO ",C)>Ref(Security("ALGYO ",C),-1), 1,0))
ert art2
Cum(If( Security("ALCTL ",C)>Ref(Security("ALCTL ",C),-1), 1,0) +
If( Security("ALKA",C)>Ref(Security("ALKA",C),-1), 1,0) +
If( Security("ALKIM ",C)>Ref(Security("ALKIM ",C),-1), 1,0) +
If( Security("ANACM ",C)>Ref(Security("ANACM ",C),-1), 1,0) +
If( Security("AEFES ",C)>Ref(Security("AEFES ",C),-1), 1,0) +
If( Security("ANHYT ",C)>Ref(Security("ANHYT ",C),-1), 1,0) +
If( Security("ASUZU ",C)>Ref(Security("ASUZU ",C),-1), 1,0) +
If( Security("ANSGR ",C)>Ref(Security("ANSGR ",C),-1), 1,0) +
If( Security("ARSAN ",C)>Ref(Security("ARSAN ",C),-1), 1,0) +
If( Security("ASELS ",C)>Ref(Security("ASELS ",C),-1), 1,0) +
If( Security("AGYO ",C)>Ref(Security("AGYO",C),-1), 1,0) +
If( Security("AYGAZ ",C)>Ref(Security("AYGAZ ",C),-1), 1,0) +
If( Security("BOLUC ",C)>Ref(Security("BOLUC ",C),-1), 1,0) +
If( Security("BRSAN ",C)>Ref(Security("BRSAN ",C),-1), 1,0) +
If( Security("BRYAT ",C)>Ref(Security("BRYAT ",C),-1), 1,0) +
If( Security("BOSSA ",C)>Ref(Security("BOSSA ",C),-1), 1,0) +
If( Security("CYTAS ",C)>Ref(Security("CYTAS ",C),-1), 1,0) +
If( Security("CARSI ",C)>Ref(Security("CARSI ",C),-1), 1,0) +
If( Security("CIMSA ",C)>Ref(Security("CIMSA ",C),-1), 1,0) +
If( Security("DEVA ",C)>Ref(Security("DEVA ",C),-1), 1,0) +
If( Security("DISBA",C)>Ref(Security("DISBA",C),-1), 1,0) +
If( Security("MILYT",C)>Ref(Security("MILYT",C),-1), 1,0) +
If( Security("DOKTS",C)>Ref(Security("DOKTS",C),-1), 1,0) +
If( Security("ECILC",C)>Ref(Security("ECILC",C),-1), 1,0) +
If( Security("ECYAP",C)>Ref(Security("ECYAP",C),-1), 1,0) +
If( Security("ECZYT",C)>Ref(Security("ECZYT",C),-1), 1,0) +
If( Security("EFES",C)>Ref(Security("EFES",C),-1), 1,0))
ert art3
Cum(If( Security("EGSER",C)>Ref(Security("EGSER",C),-1), 1,0) +
If( Security("GIMA",C)>Ref(Security("GIMA",C),-1), 1,0) +
If( Security("GLMDE",C)>Ref(Security("GLMDE",C),-1), 1,0) +
If( Security("GOLDS",C)>Ref(Security("GOLDS",C),-1), 1,0) +
If( Security("GSDHO",C)>Ref(Security("GSDHO",C),-1), 1,0) +
If( Security("HEKTS",C)>Ref(Security("HEKTS",C),-1), 1,0) +
If( Security("IHEVA",C)>Ref(Security("IHEVA",C),-1), 1,0) +
If( Security("IHGYO",C)>Ref(Security("IHGYO",C),-1), 1,0) +
If( Security("ISGYO",C)>Ref(Security("ISGYO",C),-1), 1,0) +
If( Security("IZMDC",C)>Ref(Security("IZMDC",C),-1), 1,0) +
If( Security("KRDMD",C)>Ref(Security("KRDMD",C),-1), 1,0) +
If( Security("KORDS",C)>Ref(Security("KORDS",C),-1), 1,0) +
If( Security("KRSTL",C)>Ref(Security("KRSTL",C),-1), 1,0) +
If( Security("LIOYS",C)>Ref(Security("LIOYS",C),-1), 1,0) +
If( Security("MRDIN",C)>Ref(Security("MRDIN",C),-1), 1,0) +
If( Security("MMART",C)>Ref(Security("MMART",C),-1), 1,0) +
If( Security("MNDRS",C)>Ref(Security("MNDRS",C),-1), 1,0) +
If( Security("MIPAZ",C)>Ref(Security("MIPAZ",C),-1), 1,0) +
If( Security("NTHOL",C)>Ref(Security("NTHOL",C),-1), 1,0) +
If( Security("NTTUR",C)>Ref(Security("NTTUR",C),-1), 1,0) +
If( Security("OTKAR",C)>Ref(Security("OTKAR",C),-1), 1,0) +
If( Security("PRKTE",C)>Ref(Security("PRKTE",C),-1), 1,0) +
If( Security("PETKM",C)>Ref(Security("PETKM",C),-1), 1,0) +
If( Security("SANKO",C)>Ref(Security("SANKO",C),-1), 1,0) +
If( Security("SASA",C)>Ref(Security("SASA",C),-1), 1,0) +
If( Security("SODA",C)>Ref(Security("SODA",C),-1), 1,0) +
If( Security("SKBNK",C)>Ref(Security("SKBNK",C),-1), 1,0) +
If( Security("TUDDF",C)>Ref(Security("TUDDF",C),-1), 1,0) +
If( Security("TEBNK",C)>Ref(Security("TEBNK",C),-1), 1,0) +
If( Security("TATKS",C)>Ref(Security("TATKS",C),-1), 1,0) +
If( Security("KIPA",C)>Ref(Security("KIPA",C),-1), 1,0) +
If( Security("TIRE",C)>Ref(Security("TIRE",C),-1), 1,0) +
If( Security("TRKCM",C)>Ref(Security("TRKCM",C),-1), 1,0) +
If( Security("TRCAS",C)>Ref(Security("TRCAS",C),-1), 1,0) +
If( Security("THYAO",C)>Ref(Security("THYAO",C),-1), 1,0) +
If( Security("UZEL",C)>Ref(Security("UZEL",C),-1), 1,0) +
If( Security("YKGYO",C)>Ref(Security("YKGYO",C),-1), 1,0) +
If( Security("YAZIC",C)>Ref(Security("YAZIC",C),-1), 1,0) +
If( Security("ZOREN",C)>Ref(Security("ZOREN",C),-1), 1,0))
ert az1
Cum(If( Security("AKENR ",C)<Ref(Security("AKENR ",C),-1), -1,0) +
If( Security("AKBNK ",C)<Ref(Security("AKBNK ",C),-1), -1,0) +
If( Security("AKSA ",C)<Ref(Security("AKSA ",C),-1), -1,0) +
If( Security("AKGRT ",C)<Ref(Security("AKGRT ",C),-1), -1,0) +
If( Security("ALARK",C)<Ref(Security("ALARK",C),-1), -1,0) +
If( Security("ARCLK ",C)<Ref(Security("ARCLK ",C),-1), -1,0) +
If( Security("BEKO ",C)<Ref(Security("BEKO ",C),-1), -1,0) +
If( Security("DOHOL ",C)<Ref(Security("DOHOL ",C),-1), -1,0) +
If( Security("DYHOL ",C)<Ref(Security("DYHOL ",C),-1), -1,0) +
If( Security("ENKAI ",C)<Ref(Security("ENKAI ",C),-1), -1,0) +
If( Security("EREGL ",C)<Ref(Security("EREGL ",C),-1), -1,0) +
If( Security("FINBN ",C)<Ref(Security("FINBN ",C),-1), -1,0) +
If( Security("FROTO ",C)<Ref(Security("FROTO ",C),-1), -1,0) +
If( Security("GARAN ",C)<Ref(Security("GARAN ",C),-1), -1,0) +
If( Security("HURGZ ",C)<Ref(Security("HURGZ ",C),-1), -1,0) +
If( Security("IHLAS ",C)<Ref(Security("IHLAS ",C),-1), -1,0) +
If( Security("ISCTR ",C)<Ref(Security("ISCTR ",C),-1), -1,0) +
If( Security("KCHOL ",C)<Ref(Security("KCHOL ",C),-1), -1,0) +
If( Security("MIGRS ",C)<Ref(Security("MIGRS ",C),-1), -1,0) +
If( Security("NETAS ",C)<Ref(Security("NETAS ",C),-1), -1,0) +
If( Security("PTOFS ",C)<Ref(Security("PTOFS ",C),-1), -1,0) +
If( Security("SAHOL ",C)<Ref(Security("SAHOL ",C),-1), -1,0) +
If( Security("SISE ",C)<Ref(Security("SISE ",C),-1), -1,0) +
If( Security("TNSAS ",C)<Ref(Security("TNSAS ",C),-1), -1,0) +
If( Security("TOASO ",C)<Ref(Security("TOASO ",C),-1), -1,0) +
If( Security("TCELL ",C)<Ref(Security("TCELL ",C),-1), -1,0) +
If( Security("TUPRS ",C)<Ref(Security("TUPRS ",C),-1), -1,0) +
If( Security("ULKER ",C)<Ref(Security("ULKER ",C),-1), -1,0) +
If( Security("VESTL ",C)<Ref(Security("VESTL ",C),-1), -1,0) +
If( Security("YKBNK ",C)<Ref(Security("YKBNK ",C),-1), -1,0) +
If( Security("ADNAC ",C)<Ref(Security("ADNAC ",C),-1), -1,0) +
If( Security("AKCNS ",C)<Ref(Security("AKCNS ",C),-1), -1,0) +
If( Security("ALGYO ",C)<Ref(Security("ALGYO ",C),-1), -1,0))
ert az2
Cum(If( Security("ALCTL ",C)<Ref(Security("ALCTL ",C),-1), -1,0) +
If( Security("ALKA",C)<Ref(Security("ALKA",C),-1), -1,0) +
If( Security("ALKIM ",C)<Ref(Security("ALKIM ",C),-1), -1,0) +
If( Security("ANACM ",C)<Ref(Security("ANACM ",C),-1), -1,0) +
If( Security("AEFES ",C)<Ref(Security("AEFES ",C),-1), -1,0) +
If( Security("ANHYT ",C)<Ref(Security("ANHYT ",C),-1), -1,0) +
If( Security("ASUZU ",C)<Ref(Security("ASUZU ",C),-1), -1,0) +
If( Security("ANSGR ",C)<Ref(Security("ANSGR ",C),-1), -1,0) +
If( Security("ARSAN ",C)<Ref(Security("ARSAN ",C),-1), -1,0) +
If( Security("ASELS ",C)<Ref(Security("ASELS ",C),-1), -1,0) +
If( Security("AGYO ",C)<Ref(Security("AGYO",C),-1), -1,0) +
If( Security("AYGAZ ",C)<Ref(Security("AYGAZ ",C),-1), -1,0) +
If( Security("BOLUC ",C)<Ref(Security("BOLUC ",C),-1), -1,0) +
If( Security("BRSAN ",C)<Ref(Security("BRSAN ",C),-1), -1,0) +
If( Security("BRYAT ",C)<Ref(Security("BRYAT ",C),-1), -1,0) +
If( Security("BOSSA ",C)<Ref(Security("BOSSA ",C),-1), -1,0) +
If( Security("CYTAS ",C)<Ref(Security("CYTAS ",C),-1), -1,0) +
If( Security("CARSI ",C)<Ref(Security("CARSI ",C),-1), -1,0) +
If( Security("CIMSA ",C)<Ref(Security("CIMSA ",C),-1), -1,0) +
If( Security("DEVA ",C)<Ref(Security("DEVA ",C),-1), -1,0) +
If( Security("DISBA",C)<Ref(Security("DISBA",C),-1), -1,0) +
If( Security("MILYT",C)<Ref(Security("MILYT",C),-1), -1,0) +
If( Security("DOKTS",C)<Ref(Security("DOKTS",C),-1), -1,0) +
If( Security("ECILC",C)<Ref(Security("ECILC",C),-1), -1,0) +
If( Security("ECYAP",C)<Ref(Security("ECYAP",C),-1), -1,0) +
If( Security("ECZYT",C)<Ref(Security("ECZYT",C),-1), -1,0) +
If( Security("EFES",C)<Ref(Security("EFES",C),-1), -1,0))
ert az3
Cum(If( Security("EGSER",C)<Ref(Security("EGSER",C),-1), -1,0) +
If( Security("GIMA",C)<Ref(Security("GIMA",C),-1), -1,0) +
If( Security("GLMDE",C)<Ref(Security("GLMDE",C),-1), -1,0) +
If( Security("GOLDS",C)<Ref(Security("GOLDS",C),-1), -1,0) +
If( Security("GSDHO",C)<Ref(Security("GSDHO",C),-1), -1,0) +
If( Security("HEKTS",C)<Ref(Security("HEKTS",C),-1), -1,0) +
If( Security("IHEVA",C)<Ref(Security("IHEVA",C),-1), -1,0) +
If( Security("IHGYO",C)<Ref(Security("IHGYO",C),-1), -1,0) +
If( Security("ISGYO",C)<Ref(Security("ISGYO",C),-1), -1,0) +
If( Security("IZMDC",C)<Ref(Security("IZMDC",C),-1), -1,0) +
If( Security("KRDMD",C)<Ref(Security("KRDMD",C),-1), -1,0) +
If( Security("KORDS",C)<Ref(Security("KORDS",C),-1), -1,0) +
If( Security("KRSTL",C)<Ref(Security("KRSTL",C),-1), -1,0) +
If( Security("LIOYS",C)<Ref(Security("LIOYS",C),-1), -1,0) +
If( Security("MRDIN",C)<Ref(Security("MRDIN",C),-1), -1,0) +
If( Security("MMART",C)<Ref(Security("MMART",C),-1), -1,0) +
If( Security("MNDRS",C)<Ref(Security("MNDRS",C),-1), -1,0) +
If( Security("MIPAZ",C)<Ref(Security("MIPAZ",C),-1), -1,0) +
If( Security("NTHOL",C)<Ref(Security("NTHOL",C),-1), -1,0) +
If( Security("NTTUR",C)<Ref(Security("NTTUR",C),-1), -1,0) +
If( Security("OTKAR",C)<Ref(Security("OTKAR",C),-1), -1,0) +
If( Security("PRKTE",C)<Ref(Security("PRKTE",C),-1), -1,0) +
If( Security("PETKM",C)<Ref(Security("PETKM",C),-1), -1,0) +
If( Security("SANKO",C)<Ref(Security("SANKO",C),-1), -1,0) +
If( Security("SASA",C)<Ref(Security("SASA",C),-1), -1,0) +
If( Security("SODA",C)<Ref(Security("SODA",C),-1), -1,0) +
If( Security("SKBNK",C)<Ref(Security("SKBNK",C),-1), -1,0) +
If( Security("TUDDF",C)<Ref(Security("TUDDF",C),-1), -1,0) +
If( Security("TEBNK",C)<Ref(Security("TEBNK",C),-1), -1,0) +
If( Security("TATKS",C)<Ref(Security("TATKS",C),-1), -1,0) +
If( Security("KIPA",C)<Ref(Security("KIPA",C),-1), -1,0) +
If( Security("TIRE",C)<Ref(Security("TIRE",C),-1), -1,0) +
If( Security("TRKCM",C)<Ref(Security("TRKCM",C),-1), -1,0) +
If( Security("TRCAS",C)<Ref(Security("TRCAS",C),-1), -1,0) +
If( Security("THYAO",C)<Ref(Security("THYAO",C),-1), -1,0) +
If( Security("UZEL",C)<Ref(Security("UZEL",C),-1), -1,0) +
If( Security("YKGYO",C)<Ref(Security("YKGYO",C),-1), -1,0) +
If( Security("YAZIC",C)<Ref(Security("YAZIC",C),-1), -1,0) +
If( Security("ZOREN",C)<Ref(Security("ZOREN",C),-1), -1,0))
ert azalan artan100
(Fml( "ert art1") +Fml( "ert art2")+Fml( "ert art3"))+ (Fml( "ert az1")
+Fml( "ert az2") +Fml( "ert az3"))
ert azalan artan100(2)yukdüş oran
((Fml( "ert art1") +Fml( "ert art2")+Fml( "ert art3")))
/( (Fml( "ert az1") +Fml( "ert az2") +Fml( "ert az3")))
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.