|
|
|
|
|
|||||
|
|||||
|
 |
 |
Useful examples of my work - these should work on MS Office 2000 upwards Please note that whilst this web page illustrates some of my technical skills my abilities extend beyond that of a programmer. As a qualified chartered accountant I have been closely involved with many types of business activity. Disclaimer - I accept no responsibilty for any liability arising from the use of these files. The files are included for illustration purposes - any use by a 3rd party is entirely at their own risk. Caution! Although I am confident my files are virus free you MUST virus check any files (from here) that you put on your PC for your own safety! Yahoo Stock Monitor (MS Excel) I have developed this MS Excel model to enable me to keep a close eye on various stocks prices and their trends. I have found it invaluable in enabling me to spot stock price/volume movements together with trending information. You may find it useful too! Download Here- please read my disclaimer above Note the file is zipped to keep the download economical.  I have recorded a MP3 instruction file which you may find useful too.
Visual Data Analysis (MS Access) I built this MS Access database application to visually pick up unusual 3rd party intermediary activity. I've changed the data to relate to UK stock prices to demonstrate the basic effects. Download Here- please read my disclaimer above Note the file is zipped to keep the download economical. Add-In utility (MS Excel) I built this to help with repetative tasks that I found myself needing when using MS Excel. To see it in action you need to save the "xla" file somewhere on your local PC drive. Get the Add-In here- please read my disclaimer above The add-in can be included within MS Excel by choosing Tools/Add-Ins from the menu. Then use "Browse" to pick up the file and add it in to MS Excel. You will then see "Xlspower" appear as an extra menu item. Note pressing keys "ALT" plus "X" will quickly display the options available. For details on the features please go here Loan Repayment Schedule (JavaScript) I can write fairly basic JavaScript but this example is complex. I downloaded the initial script from the internet which allowed for monthly repayments starting at month 1. I then played around with it so that it accommodated a pause of two months before repayments commenced. Go Here- please read my disclaimer above Web Panoramic Picture (Flash) I built this demo screen to show off how jpeg image files can be combined together to make great looking panoramic pictures. Go here- please read my disclaimer above MS Excel - Training Here are a couple of MS Excel files that show off some of MS Excel's advanced functionality Match and Index- please read my disclaimer above Using Arrays- please read my disclaimer above Trend Analysis Here is a MS Excel tip to help in trend analysis This one shows how to use MS Excel's chart to generate trend line formula Go here to find out about trend formulas- please read my disclaimer above Stock Market Technical (MS Excel) Here are some files that show calculations with respect to technical indicators Donchian Channel- please read my disclaimer above Stochastic Oscilator- please read my disclaimer above Two MS Excel examples I use but have NOT been created by me. This example shows the use of long and short moving averages - a number of permuations are processed to determin the best long and short moving averages to get optimum results.
Foreign Exchange Monitor (MS Excel)
|
|
