Gracias Sr. JSN
Entonces recomienda usted alguna alternativa similar con menos posibilidades de perder dinero?
No tengo ideas en esa línea, pero usando las propuestas de Dolmen te puedo indicar sus distribuciones de probabilidad de rentabilidad anual tras 5.000 simulaciones, basándome en las rentabilidades trimestrales de lo últimos 5 años. Como se ve, se trata de fondos muy conservadores, destacando los de SGAM A y B que no hubieran perdido en el 99% de las ocasiones. Estos dos últimos parecen la mejor opción para todos los intervalos de probabilidad.
<table x:str="" *****="border-collapse: collapse; width: 245pt;" border="0" cellpadding="0" cellspacing="0" width="327"><col *****="width: 47pt;" width="63"> <col *****="width: 35pt;" span="2" width="47"> <col *****="width: 43pt;" span="2" width="57"> <col *****="width: 42pt;" width="56"> <tbody><tr *****="height: 12.75pt;" height="17"> <td class="xl24" *****="height: 12.75pt; width: 47pt;" height="17" width="63">
percentil</td> <td class="xl24" *****="width: 35pt;" width="47">
BNP-C</td> <td class="xl24" *****="width: 35pt;" width="47">
JPM-A</td> <td class="xl24" *****="width: 43pt;" width="57">
Sgam-A</td> <td class="xl24" *****="width: 43pt;" width="57">
Sgam-B</td> <td class="xl24" *****="width: 42pt;" width="56">
Sgam-F</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" height="17">
min</td> <td class="xl27" x:num="2.8019504760377067E-3">0,28%</td> <td class="xl27" x:num="1.9006400599999029E-3">0,19%</td> <td class="xl27" x:num="4.1062141320202805E-3">0,41%</td> <td class="xl27" x:num="4.8086469140737886E-3">0,48%</td> <td class="xl27" x:num="1.8010802700239026E-3">0,18%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" height="17">
1</td> <td class="xl27" x:num="8.1189699834913753E-3">0,81%</td> <td class="xl27" x:num="6.7140604265751858E-3">0,67%</td> <td class="xl27" x:num="1.0435760368445957E-2">1,04%</td> <td class="xl27" x:num="1.1845429444288014E-2">1,18%</td> <td class="xl27" x:num="8.3212536899017753E-3">0,83%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" height="17">
5</td> <td class="xl27" x:num="1.2034722477201276E-2">1,20%</td> <td class="xl27" x:num="1.0634705383772092E-2">1,06%</td> <td class="xl27" x:num="1.4340210283879218E-2">1,43%</td> <td class="xl27" x:num="1.5954970014326664E-2">1,60%</td> <td class="xl27" x:num="1.1948753970526527E-2">1,19%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A4+5" height="17">
10</td> <td class="xl27" x:num="1.4368377188550108E-2">1,44%</td> <td class="xl27" x:num="1.325025022487214E-2">1,33%</td> <td class="xl27" x:num="1.6493108263176515E-2">1,65%</td> <td class="xl27" x:num="1.8321670519337641E-2">1,83%</td> <td class="xl27" x:num="1.4471568624676578E-2">1,45%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A5+5" height="17">
15</td> <td class="xl27" x:num="1.598368930664007E-2">1,60%</td> <td class="xl27" x:num="1.485612489306809E-2">1,49%</td> <td class="xl27" x:num="1.8311775082173076E-2">1,83%</td> <td class="xl27" x:num="2.014160661988651E-2">2,01%</td> <td class="xl27" x:num="1.6166521124348909E-2">1,62%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A6+5" height="17">
20</td> <td class="xl27" x:num="1.7302117106903214E-2">1,73%</td> <td class="xl27" x:num="1.6183425397870321E-2">1,62%</td> <td class="xl27" x:num="1.9822811234416093E-2">1,98%</td> <td class="xl27" x:num="2.1557118390953756E-2">2,16%</td> <td class="xl27" x:num="1.7488743844659815E-2">1,75%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A7+5" height="17">
25</td> <td class="xl27" x:num="1.831982985002889E-2">1,83%</td> <td class="xl27" x:num="1.7389039913558779E-2">1,74%</td> <td class="xl27" x:num="2.0844326131542967E-2">2,08%</td> <td class="xl27" x:num="2.2674121240982004E-2">2,27%</td> <td class="xl27" x:num="1.8700730411554511E-2">1,87%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A8+5" height="17">
30</td> <td class="xl27" x:num="1.9231236939847518E-2">1,92%</td> <td class="xl27" x:num="1.8494019983458898E-2">1,85%</td> <td class="xl27" x:num="2.1857283410566364E-2">2,19%</td> <td class="xl27" x:num="2.3684986964631394E-2">2,37%</td> <td class="xl27" x:num="1.9716084836996828E-2">1,97%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A9+5" height="17">
35</td> <td class="xl27" x:num="2.0133130718978043E-2">2,01%</td> <td class="xl27" x:num="1.9532131302932187E-2">1,95%</td> <td class="xl27" x:num="2.2882023976551036E-2">2,29%</td> <td class="xl27" x:num="2.4601844320542909E-2">2,46%</td> <td class="xl27" x:num="2.0755293383268869E-2">2,08%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A10+5" height="17">
40</td> <td class="xl27" x:num="2.1158295161510354E-2">2,12%</td> <td class="xl27" x:num="2.0430022353200128E-2">2,04%</td> <td class="xl27" x:num="2.3979522750075422E-2">2,40%</td> <td class="xl27" x:num="2.5527306568223995E-2">2,55%</td> <td class="xl27" x:num="2.1755369482773901E-2">2,18%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A11+5" height="17">
45</td> <td class="xl27" x:num="2.1971685258188156E-2">2,20%</td> <td class="xl27" x:num="2.1246933562047765E-2">2,12%</td> <td class="xl27" x:num="2.488769428829829E-2">2,49%</td> <td class="xl27" x:num="2.6433339723209714E-2">2,64%</td> <td class="xl27" x:num="2.2686128596485222E-2">2,27%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A12+5" height="17">
50</td> <td class="xl27" x:num="2.2780838108935608E-2">2,28%</td> <td class="xl27" x:num="2.2154882952963195E-2">2,22%</td> <td class="xl27" x:num="2.5719741887785252E-2">2,57%</td> <td class="xl27" x:num="2.7409532615964682E-2">2,74%</td> <td class="xl27" x:num="2.3600472460907795E-2">2,36%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A13+5" height="17">
55</td> <td class="xl27" x:num="2.3573881466725011E-2">2,36%</td> <td class="xl27" x:num="2.3089826736869545E-2">2,31%</td> <td class="xl27" x:num="2.6649590891701269E-2">2,66%</td> <td class="xl27" x:num="2.8292981971039799E-2">2,83%</td> <td class="xl27" x:num="2.4413145768429123E-2">2,44%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A14+5" height="17">
60</td> <td class="xl27" x:num="2.4411577982268451E-2">2,44%</td> <td class="xl27" x:num="2.3900627865378166E-2">2,39%</td> <td class="xl27" x:num="2.754658880759786E-2">2,75%</td> <td class="xl27" x:num="2.9237422487749631E-2">2,92%</td> <td class="xl27" x:num="2.530963844940759E-2">2,53%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A15+5" height="17">
65</td> <td class="xl27" x:num="2.5326523462891659E-2">2,53%</td> <td class="xl27" x:num="2.4801293441098604E-2">2,48%</td> <td class="xl27" x:num="2.8385779962556423E-2">2,84%</td> <td class="xl27" x:num="3.0210901176743743E-2">3,02%</td> <td class="xl27" x:num="2.6140254961918075E-2">2,61%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A16+5" height="17">
70</td> <td class="xl27" x:num="2.6452599630888862E-2">2,65%</td> <td class="xl27" x:num="2.5836264699453215E-2">2,58%</td> <td class="xl27" x:num="2.9401256524639985E-2">2,94%</td> <td class="xl27" x:num="3.1128920507623947E-2">3,11%</td> <td class="xl27" x:num="2.7266964436617469E-2">2,73%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A17+5" height="17">
75</td> <td class="xl27" x:num="2.736998686377734E-2">2,74%</td> <td class="xl27" x:num="2.6941068559678261E-2">2,69%</td> <td class="xl27" x:num="3.0430681928915959E-2">3,04%</td> <td class="xl27" x:num="3.2074365985207853E-2">3,21%</td> <td class="xl27" x:num="2.8280619709074806E-2">2,83%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A18+5" height="17">
80</td> <td class="xl27" x:num="2.8471743398907901E-2">2,85%</td> <td class="xl27" x:num="2.7978370264328145E-2">2,80%</td> <td class="xl27" x:num="3.165804890943158E-2">3,17%</td> <td class="xl27" x:num="3.3188052146596148E-2">3,32%</td> <td class="xl27" x:num="2.9399143692588225E-2">2,94%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A19+5" height="17">
85</td> <td class="xl27" x:num="2.9713751881782491E-2">2,97%</td> <td class="xl27" x:num="2.9306498724577912E-2">2,93%</td> <td class="xl27" x:num="3.3193422964868269E-2">3,32%</td> <td class="xl27" x:num="3.432220632009253E-2">3,43%</td> <td class="xl27" x:num="3.0736165591462639E-2">3,07%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A20+5" height="17">
90</td> <td class="xl27" x:num="3.1356575093747896E-2">3,14%</td> <td class="xl27" x:num="3.0738125133778826E-2">3,07%</td> <td class="xl27" x:num="3.4832203503230241E-2">3,48%</td> <td class="xl27" x:num="3.6064638833494866E-2">3,61%</td> <td class="xl27" x:num="3.2482370283214657E-2">3,25%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" x:fmla="=A21+5" height="17">
95</td> <td class="xl27" x:num="3.3511443562415977E-2">3,35%</td> <td class="xl27" x:num="3.2890778370808116E-2">3,29%</td> <td class="xl27" x:num="3.6903882597746573E-2">3,69%</td> <td class="xl27" x:num="3.8433317018358393E-2">3,84%</td> <td class="xl27" x:num="3.4932275471388108E-2">3,49%</td> </tr> <tr *****="height: 12.75pt;" height="17"> <td class="xl25" *****="height: 12.75pt;" x:num="" height="17">
99</td> <td class="xl27" x:num="3.6897097305352844E-2">3,69%</td> <td class="xl27" x:num="3.669421005844975E-2">3,67%</td> <td class="xl27" x:num="4.0706157170475432E-2">4,07%</td> <td class="xl27" x:num="4.2457141358229311E-2">4,25%</td> <td class="xl27" x:num="3.9159801393851668E-2">3,92%</td> </tr> <tr *****="height: 13.5pt;" height="18"> <td class="xl26" *****="height: 13.5pt;" height="18">
max</td> <td class="xl28" x:num="4.1427985404364209E-2">4,14%</td> <td class="xl28" x:num="3.9677045085562579E-2">3,97%</td> <td class="xl28" x:num="4.5661489112520881E-2">4,57%</td> <td class="xl28" x:num="4.659225291925928E-2">4,66%</td> <td class="xl28" x:num="4.2665958855225394E-2">4,27%</td> </tr> </tbody></table>