I have an Excel spreadsheet that I use to track stock trades and am able to use the Excel RTD function to get live prices from my ThinkOrSwim platform
I need to switch to Access to better manage the data in my trades.
Any ideas how I can use the Excel functionality to update the fields in my Access database?
In a perfect world, I would have a CurrentPrice field that auto updated using RTD. Then when I enter a date in to a CloseDate filed (after I close the trade) it would stop updating.
Any help is appreciated
thanks
mike