Found it. If you record a macro doing your stock quote refresh/update you can then run this macro from the Run command like so.
VB Code:
  1. mySum = Application.Run("MYCUSTOM.XLM!My_Func_Sum", 1, 5)

  2. MsgBox "Macro result: " & mySum