Recent content by JamesG_oz

Hi Zambuck, Thanks for the pointer but I don't think OLE is going to do quite what I need. What I really need is to be able to put the close price of a given stock on a given day in a cell, where the stock and the day are values in other cells. So, for example, if A1 contains "NCP" and A2...

Hi guys, I am using Metastock 8.0 EOD and would like to be able to pull prices from the metastock database into an Excel spreadsheet. I have some rudimentary ability with VBA so I am planning on writing some sort of function to query the Metastock files but I am struggling to work out the file...