{"id":143,"date":"2007-12-10T12:12:13","date_gmt":"2007-12-10T20:12:13","guid":{"rendered":"http:\/\/raffy.ch\/blog\/2007\/12\/10\/risk-management-moving-average-analysis\/"},"modified":"2007-12-10T12:12:13","modified_gmt":"2007-12-10T20:12:13","slug":"risk-management-moving-average-analysis","status":"publish","type":"post","link":"https:\/\/raffy.ch\/blog\/2007\/12\/10\/risk-management-moving-average-analysis\/","title":{"rendered":"Risk Management &#8211; Moving Average Analysis"},"content":{"rendered":"<p><img decoding=\"async\" src=\"http:\/\/raffy.ch\/blog\/wp-content\/uploads\/2007\/12\/moving_average.thumbnail.png\" style=\"margin: 0pt 10px 10px 0pt; float: left\" alt=\"moving_average.png\" \/>Today I found myself researching &#8220;moving average analysis&#8221; techniques.  Using moving average analysis can be fairly useful in trending risk. Plot the moving average over your risk and compare it with the actual risk numbers, much like you would analyze a stock chart. I will write more extensively about this in my book in the &#8220;Visual Security Analysis&#8221; chapter.<\/p>\n<p>What I just learned and what really pointed me to write this blog post is that Excel has a data analysis add-in that lets you compute moving averages. In my Excel instance, I had to first enable the &#8220;Data Analysis&#8221; add-in by going to <em>Tools|Add-Ins&#8230;<\/em>  Once enabled, I got a new menu item under <em>Tools<\/em> which is <em>Data Analysis&#8230;<\/em> There you can choose from a variety of data analysis tools, among them a moving average calculator. This <a href=\"http:\/\/office.microsoft.com\/en-us\/help\/HA010864801033.aspx\">blog post <\/a>shows  exactly to to apply the add-in.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today I found myself researching &#8220;moving average analysis&#8221; techniques. Using moving average analysis can be fairly useful in trending risk. Plot the moving average over your risk and compare it with the actual risk numbers, much like you would analyze a stock chart. I will write more extensively about this in my book in the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-143","post","type-post","status-publish","format-standard","hentry","category-log-analysis"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/raffy.ch\/blog\/wp-json\/wp\/v2\/posts\/143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/raffy.ch\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/raffy.ch\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/raffy.ch\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/raffy.ch\/blog\/wp-json\/wp\/v2\/comments?post=143"}],"version-history":[{"count":0,"href":"https:\/\/raffy.ch\/blog\/wp-json\/wp\/v2\/posts\/143\/revisions"}],"wp:attachment":[{"href":"https:\/\/raffy.ch\/blog\/wp-json\/wp\/v2\/media?parent=143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/raffy.ch\/blog\/wp-json\/wp\/v2\/categories?post=143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/raffy.ch\/blog\/wp-json\/wp\/v2\/tags?post=143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}