Heatmap & Cheat sheet @USDA #WASDE report – #Excel & #VBA #Macro automation – #Wheat #Corn #Soybeans

*** Edit 23 January 2018 *** The Excel file was update, it should now work for 2018. There is also another macro on sheets "Param". A button Export is exporting the Heatmaps as .JPG file, then it can be used on social media, presentations, etc,... In the cell L5, the path needs to be inputted, … Continue reading Heatmap & Cheat sheet @USDA #WASDE report – #Excel & #VBA #Macro automation – #Wheat #Corn #Soybeans

Send Status Update (Tweets) to Twitter using Excel and VBA, XML requesting the Twitter API with HMAC-SHA1 encryption

This is coming after the following blog entry: “Send Status Update (Tweets) to Twitter using Excel and VBA, XML requesting the Twitter API”. I promised to come back with an update to avoid using a third party add-in on the encryption stage. It took a bit of time but here we are! Indeed, when my … Continue reading Send Status Update (Tweets) to Twitter using Excel and VBA, XML requesting the Twitter API with HMAC-SHA1 encryption

March the thirteenth (3/14): Happy Pi Day! #PiDay #HappyPiDay ≈3.14159265359

In US date format, 3/14, it’s the so called Pi Day… Let's enjoy it! Pi is needed in finance, especially when building pricers as the probability density of the normal distribution is the following. Yes but, let’s suppose you cannot use a preset function of Pi? Ok, easy route is to use 3.14159265359, this should … Continue reading March the thirteenth (3/14): Happy Pi Day! #PiDay #HappyPiDay ≈3.14159265359

Send Status Update (Tweets) to Twitter using Excel and VBA, XML requesting the Twitter API

Edit 02/05/2016: update on a method to avoid using a third party add-in to process the encryption - Send Status Update (Tweets) to Twitter using Excel and VBA, XML requesting the Twitter API with HMAC-SHA1 encryption I created a Twitter Bot (bot being a shortcut for robot) to send to Twitter periodic status updates (ie Tweets) … Continue reading Send Status Update (Tweets) to Twitter using Excel and VBA, XML requesting the Twitter API

Send en Email automatically with Excel and VBA integrating dynamic data from Reuters, Bloomberg, DataStream,…

Sometimes, it is useful or needed to send an email outside office hours (a market snapshot, settlement prices,...). Staying in the office just for the sake of sending this particular email can be a lack of productivity, therefore, automating the process is really welcomed. I even know some people who use this method to make … Continue reading Send en Email automatically with Excel and VBA integrating dynamic data from Reuters, Bloomberg, DataStream,…