Excel
Turbocharging Excel
Aka: Fast data retrieval from a database. In a lot of enterprises that Process IQ had a pleasure to work with, there is always an Excel spreadsheet that implements a …
Read moreScenario analysis for Natural Gas options
Using Excel for decision making again! When trading or pricing options, there is always a dilemma what would be best structure for given assumed market scenario. …
Read moreHow to make your boss happy
By speeding up that boring reconciliation with Excel. A very frequent activity in any business is checking if an invoice, order list or any other data sets are …
Read moreTaking chances in Monte Carlo
MathJax.Hub.Config({ tex2jax: { inlineMath: [ ['$','$'], ["\\(","\\)"] ], processEscapes: true } }); One of the cool ways to learn few tricks with Excel is to use …
Read moreHow to make money in Natural Gas with Excel
MathJax.Hub.Config({ tex2jax: { inlineMath: [ ['$','$'], ["\\(","\\)"] ], processEscapes: true } }); One of the strategies is to buy cheap summer gas, store it for …
Read moreHelp! My Excel is too slow
Quick tip for those who suffer with slow Excel syndrome (SES). The main culprit are typically too much data and large number of volatile functions. We can talk how …
Read moreA little bit of Excel Automation
Excel applications are the good, the bad and the ugly of trading or logistics process. Spreadsheets are great as a simple database with couple of formulas to act as …
Read more