{"id":2629,"date":"2015-04-22T08:35:27","date_gmt":"2015-04-22T08:35:27","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/?p=2629"},"modified":"2025-04-08T03:50:47","modified_gmt":"2025-04-08T03:50:47","slug":"what-are-the-odds-like-for-the-uk-general-election","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/what-are-the-odds-like-for-the-uk-general-election\/","title":{"rendered":"What are the odds like for the UK General Election?"},"content":{"rendered":"<p>The UK general election is almost upon us and it&#8217;s a tight race! It&#8217;s the\u00a0most unpredictable election in memory\u00a0and\u00a0has already produced some lively\u00a0debates and political speed-dating as potential alliances are considered.<\/p>\n<p>There are so many sources from which to gain the latest on likely election winners, and one such are the bookies. There are some great websites with up to the minute odds on all the political parties and it got us thinking wouldn&#8217;t it be great to capture and analyse this information in Excel&#8230;.<\/p>\n<p>After several cups of coffee and Excel wizardry\u00a0one of our Excel trainers has created\u00a0a rough but working Excel 2015 UK General Election spreadsheet. \u00a0You can download the spreadsheet <a href=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/2015-UK-General-Election-betting-odds-in-excel-5.xlsx\">here<\/a>.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Election-v5.jpg\"><img decoding=\"async\" class=\"alignnone wp-image-2648 size-full\" src=\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/Election-v5.jpg\" alt=\"\" width=\"1244\" height=\"863\" \/><\/a><\/p>\n<h5>What it does:<\/h5>\n<ul>\n<li>Automatically updates with latest betting odds every hour (you can refresh at any time)<\/li>\n<li>View a\u00a0chart to analyse the betting odds<\/li>\n<\/ul>\n<h5>What you can do:<\/h5>\n<ul>\n<li>By having the latest data\u00a0you have the ability to create more <a title=\"Microsoft Excel Course 2013: Suggested Charts through Quick Analysis -\" href=\"https:\/\/www.stl-training.co.uk\/b\/blog\/excel-training\/excel-2013-suggested-charts-through-quick-analysis\/\">charts <\/a>to your heart&#8217;s content!<\/li>\n<li>Capture the live data so that you can view it historically. How did the odds change over the week? Which party gained\/lost the most (from an odds perspective!).<\/li>\n<li>With a bit of <a title=\"How to use a VLOOKUP function in Excel VBA\" href=\"https:\/\/www.stl-training.co.uk\/b\/blog\/vba-training\/use-vlookup-function-excel-vba\/\">VBA<\/a> pokery you could even\u00a0create lookup reports focussing on specific parties.<\/li>\n<\/ul>\n<p>There is a lot of opinion out there on the general election but you could do worse than follow the signals of those who are putting their money where their mouth is!<\/p>\n<h4>Learn more:<\/h4>\n<p>If you would like to learn more about how we\u00a0produced this spreadsheet; you may wish to track other live web data like stocks, competitor pricing and more, then just <a title=\"Linking web data to Excel\" href=\"https:\/\/www.stl-training.co.uk\/b\/blog\/excel-training\/linking-web-data-to-excel\/\">click here<\/a>.<\/p>\n<h2>Acknowledgements and useful resources<\/h2>\n<p><a href=\"https:\/\/www.oddschecker.com\/politics\/british-politics\/next-uk-general-election\/most-seats\">http:\/\/www.oddschecker.com\/politics\/british-politics\/next-uk-general-election\/most-seats<\/a><\/p>\n<p><a href=\"http:\/\/www.bbc.co.uk\/news\/politics\/poll-tracker\">Election 2015: Poll tracker<\/a><\/p>\n<p><a href=\"http:\/\/www.ft.com\/indepth\/uk-general-election\">http:\/\/www.ft.com\/indepth\/uk-general-election<\/a><\/p>\n<p><a href=\"https:\/\/mybettingsites.co.uk\/learn\/betting-odds-explained\/\">Betting odds explained<\/a><\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/microsoft\/excel-training-london.php\">Learn more about available Excel training courses<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The UK general election is almost upon us and it&#8217;s a tight race! It&#8217;s the\u00a0most unpredictable election in memory\u00a0and\u00a0has already produced some lively\u00a0debates and political speed-dating as potential alliances are considered. There are so many sources from which to gain the latest on likely election winners, and one such are the bookies. There are some [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7706,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,5,6],"tags":[110,128,551],"class_list":["post-2629","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-training","category-fun","category-hints-tips","tag-connecting-excel-to-website-data","tag-creating-live-data-feed-in-excel","tag-uk-general-election-2015"],"jetpack_featured_media_url":"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2015\/04\/voting-ballot-box.jpeg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2629","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=2629"}],"version-history":[{"count":3,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2629\/revisions"}],"predecessor-version":[{"id":7525,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2629\/revisions\/7525"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media\/7706"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=2629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=2629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=2629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}