Spreadsheet: 693975d1599243870-if-month-and-year-current-month-return-1-otherwise-1-percentage-from-one-month-back-look-back-a-month
Sheet: Data

Current Month
 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00
Month | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00
Month | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00
AU | 0.08 | -0.05555555555555555 | -0.1176470588235294 | -0.2222222222222222 | -0.02857142857142857 | 0.001969935497180419 | -0.1667128958673176 | 0.143762435252205 | 0.04589752355625194 | 0.08058540004711394 | -0.01243588378251047 | -0.07498814794820136 | 0.02165217870646965 | 0.01967482996010149 | 0.09313241576761841 | 0.02617041183959597 | 0.004924705068671894 | 0.1007911519021014 | 0.06575104801693961 | -0.02528872148476256 | 0.08493341191140001 | 0.0138410209526663 | 0.02782713549689545
AT | -0.02222222222222222 | 0.01515151515151515 | 0 | -0.1417910447761194 | -0.06956521739130435 | -0.09345794392523364 | 0.1752577319587629 | -0.09640511506603239 | 0.09332889283658227 | 0.006372127143556848 | 0.01534334595507179 | -0.02820208373044133 | -0.0603131019148611 | 0.02595279789433828 | 0.09898825050617788 | -0.08954393221239637 | 0.09014309874934608 | -0.09132238621160453 | 0.05597998677569762 | 0.05398095341929289 | 0.1491851629498797 | 0.03873663703660705 | 0.04835397615812863
BE | -0.0688836104513064 | -0.01020408163265306 | -0.02061855670103093 | -0.05263157894736842 | 0.01111111111111111 | 0.01649318056008977 | -0.02199454631817132 | -0.03948467056719421 | -0.01497527717126999 | -0.00475724781473567 | -0.01360288926170091 | -0.02931091100146625 | -0.07060268045161464 | 0.00451575172805933 | 0.02610699630806064 | -0.005173466301962389 | 0.04489414578686803 | -0.03131100259997483 | 0.04692438554857001 | 0.01316133179268379 | 0.02284588659758578 | 0.03467383353943478 | 0.02645281581030652
AE | -0.146551724137931 | 0.01515151515151515 | -0.08955223880597014 | 0.1420765027322404 | -0.1339712918660287 | -0.3093922651933702 | -0.032 | 0.2450685371586998 | -0.001864614085664221 | -0.008682175763810378 | -0.05095496567386083 | -0.02257494061802818 | -0.01880957943309465 | 0.06868244409022532 | 0.0403561533670737 | 0.003779549487451249 | 0.00637322405029973 | 0.02118653153327493 | 0.03740539735767252 | 0.004388955117132103 | 0.04868904314143516 | 0.01837597955222673 | 0.007961365860054359
FR | -0.02018842530282638 | -0.03708791208791209 | 0.005706134094151213 | -0.07943262411347518 | -0.05546995377503852 | 0.002521762730488957 | -0.04027933210333113 | -0.05809484985204913 | 0.03188654088204045 | 0.008938351000836845 | -0.01640207086653421 | -0.08567447062845271 | -0.0649873529602233 | -0.04611086651879533 | -0.04448340144579003 | 0.01372813891137993 | 0.03682637542761499 | -0.04532006661187288 | -0.01321518329764458 | -0.0102704054555713 | 0.02856402029007635 | 0.05703850493637457 | 0.03052759632020884
DE | -0.08246563931695126 | 0.03858374943259192 | 0.01573426573426574 | -0.0774526678141136 | -0.05923507462686567 | 0.01293157488975561 | -0.03326251869403651 | 0.05543044327719216 | 0.02393889136496765 | 0.01195597327507806 | 0.03784928158044162 | -0.04373197765743739 | -0.06006137356840523 | 0.04560912804900357 | 0.02535944244161895 | -0.0279955160680255 | 0.005362879863977572 | 0.008040535256095684 | 0.005003110558765426 | 0.04949083762529562 | 0.03507435865457046 | 0.04006314016731519 | 0.04328494091297524
IE | 0.03658536585365853 | -0.09411764705882353 | -0.09090909090909091 | 0 | -0.02857142857142857 | -0.01470588235294118 | 0 | 0.007057578037137855 | 0.05529858295744174 | 0.04181890064052012 | -0.0009175466965546174 | -0.09668438325823552 | 0.1154172578321855 | 0.1070131322697742 | -0.01345407226342234 | 0.04143399467827567 | -0.07840853913242861 | 0.02525290634173586 | 0.002147619233724986 | -0.03379557809700359 | 0.003066507034312541 | 0.02468769549367845 | 0.09365152274704779
JP | 0 | 0.125 | -0.1111111111111111 | 0 | 0 | -0.07326007326007322 | 0.1682037768994291 | -0.1738614104886349 | -0.07368652154620696 | 0.07895109182151765 | -0.03426905393245115 | -0.06672205560366316 | -0.008023789309503218 | -0.1195454908029703 | -0.0865714141183308 | -0.0782143010180616 | -0.06477743600881689 | -0.01606685279434297 | -0.01476994101263347 | -0.04978533150627287 | -0.008050370502585771 | 0.006108190972478462 | -0.009660362386159775
LU | 0.02 | -0.196078431372549 | -0.1463414634146341 | -0.3142857142857143 | -0.125 | 0.1273911273911275 | -0.06643429187933118 | 0.0956225671857728 | 0.02056155943867096 | 0.02026259363977992 | 0.0559246935124366 | -0.03723412988738611 | -0.02179874064265714 | 0.02727768378420217 | -0.1065923019187316 | -0.1016655703908976 | -0.0232989595463749 | -0.02461341058089576 | 0.08729532606309186 | 0.1092624702363021 | 0.001153304045524283 | 0.07349983821825427 | 0.1471050972850537
NL | -0.07206142941523921 | -0.01718650541056652 | -0.001295336787564767 | -0.06809338521400778 | -0.04314544189283229 | -0.004320450845349114 | -0.03610734032474895 | -0.03102674934403361 | -0.0002338620401886215 | -0.006652124225413001 | -0.004985476687332908 | -0.04719285558937225 | -0.04825196964916839 | 0.008992809702531664 | 0.0261286040508083 | 0.02746451701393725 | 0.0136238010676616 | 0.01697753079933765 | 0.007239615496299502 | 0.02174625403643898 | 0.03083308323093647 | 0.01787814776779028 | 0.02193388614037059
SG | -0.05555555555555555 | 0 | 0 | -0.1764705882352941 | -0.07142857142857142 | 0.118628359592215 | -0.0632085194091377 | 0.002871631008960349 | 0.06030345247613229 | 0.1123678954375057 | 0.06675145522286577 | -0.003468836731518426 | -0.01856771317287756 | -0.00208362598784156 | 0.05947186820662605 | 0.05926127558961576 | 0.03940726523649187 | 0.02260994129890456 | 0.07298512309511414 | 0.05289305144943376 | 0.01674183106901534 | 0.01776622720484481 | 0.00912434061204167
ES | -0.02040816326530612 | 0.08333333333333333 | 0.1538461538461539 | -0.06666666666666667 | -0.03571428571428571 | 0.06756453423120103 | -0.01923885618166527 | 0.0787921367347133 | -0.008685389827804849 | 0.02246790852864647 | -0.0335055384912753 | -0.07264449452355419 | -0.1261962597950025 | 0.06630035255103546 | 0.154210676121819 | 0.05705201479532537 | -0.03822451793734298 | -0.0640165876050851 | -0.00836556283589405 | 0.05889718598615925 | 0.006317009482830807 | 0.05925834705183879 | 0.02098195965418824
CH | 0 | 0 | 0.03448275862068965 | 0 | 0.1 | -0.1086949855435746 | 0.06807804453821574 | 0.03489965612233308 | 0.01224225088816101 | 0.05175893855426968 | 0.0275342754839534 | -0.1012734229526571 | 0.04483719877944959 | 0.007400956998128924 | -0.005691099400057148 | -0.01138886257843912 | 0.02031837859221145 | -0.03207047272007985 | 0.1096384578176336 | 0.06509227241784109 | 0.01273918011838722 | 0.0387881970865228 | 0.03254426483027151
UK | 0.01140873015873016 | -0.01520353114271702 | -0.075199203187251 | -0.139472267097469 | -0.05882352941176471 | -0.00393787555851892 | 0.005351001767460698 | -0.04968329161345113 | -0.001600296398497762 | 0.02325678805530325 | 0.02353343585034653 | -0.08182491033283001 | 0.05301957118966313 | 0.05135217036377314 | -0.002339310038265653 | 0.01387538674071068 | 0.05802928166845107 | -0.01410051048860923 | 0.02531014205628542 | 0.02888177169876253 | 0.05052737569039101 | 0.01913073343967038 | 0.0498452372986176
US | -0.02870813397129187 | -0.009852216748768473 | 0 | -0.04975124378109453 | -0.0418848167539267 | 0.03647689258972787 | 0.03653557194047978 | 0.04154097408975162 | 0.002361523172031854 | 0.01046401380687091 | 0.0149660332865671 | -0.04444288642007591 | -0.002641170690989054 | -0.0007787512453737744 | 0.007640232863977374 | 0.009032632103797194 | 0.009726182516029951 | 0.04525283072492443 | 0.04055636129512497 | 0.03933550469970062 | 0.02171134230835354 | 0.01762003943652072 | 0.01529234284167255
HK | -0.05555555555555555 | 0 | 0 | -0.1764705882352941 | -0.07142857142857142 | 0.118628359592215 | -0.0632085194091377 | 0.002871631008960349 | 0.06030345247613229 | 0.1123678954375057 | 0.06675145522286577 | -0.003468836731518426 | -0.01856771317287756 | -0.00208362598784156 | 0.05947186820662605 | 0.05926127558961576 | 0.03940726523649187 | 0.02260994129890456 | 0.07298512309511414 | 0.05289305144943376 | 0.01674183106901534 | 0.01776622720484481 | 0.00912434061204167
MY | -0.05555555555555555 | 0 | 0 | -0.1764705882352941 | -0.07142857142857142 | 0.118628359592215 | -0.0632085194091377 | 0.002871631008960349 | 0.06030345247613229 | 0.1123678954375057 | 0.06675145522286577 | -0.003468836731518426 | -0.01856771317287756 | -0.00208362598784156 | 0.05947186820662605 | 0.05926127558961576 | 0.03940726523649187 | 0.02260994129890456 | 0.07298512309511414 | 0.05289305144943376 | 0.01674183106901534 | 0.01776622720484481 | 0.00912434061204167
CA | -0.02870813397129187 | -0.009852216748768473 | 0 | -0.04975124378109453 | -0.0418848167539267 | 0.03647689258972787 | 0.03653557194047978 | 0.04154097408975162 | 0.002361523172031854 | 0.01046401380687091 | 0.00496603328656713 | -0.04444288642007591 | -0.002641170690989054 | -0.0007787512453737744 | 0.007640232863977374 | 0.009032632103797194 | 0.009726182516029951 | 0.04525283072492443 | 0.04055636129512497 | 0.03933550469970062 | 0.02171134230835354 | 0.01762003943652072 | 0.01529234284167255