Acting on Real time data feed

[Paul987]

I have a spreadsheet that pulls in some real time data. I would like an
Alert Box to pup up if the RTD value exceeds a threshold. I need to do
it without a macro, as the RTD are stock prices, so the data would be
fast and continous. Any ideas? TIA
Paul

 

[Guest]

If you want to explore a cutting edge solutiion using VSTO, have a look into

MS.Net Development for MS Office by Andrew WhiteChapel

I seem to remember an example along the lines of your requirements.

 

[Guest]

I believe you can write a VBA wrapper function that has the RTD call inside
it, which you can pass to a variable for tolerance checks. This wrapper
function then would be called in the cell reference as opposed to the RTD
formula you would normally use.

Dont know if this would be too much of a performance impact and how the
subscription engine would handle the connection of a topic within a function.

 

[Paul987]

Thanks for the responses, but I'm loking for a little more specific
advice. I got kind of lost at the "VBA wrapper function." Has anyone
run into this problem before?

 

[Guest]

I stole this from a website out there as an example of what they say you can
do with a wrapper function:

RTD function:
=RTD(RealTimeServerProgID,MachineNameWhereServerRuns,Topic1,[Topic2],…)

Wrapper function:
=GetMyData(MSFT,LAST)

function GetMyData(mySymbol,myField) as variant
'PUT YOUR TEST HERE
GetMyData =application.worksheet
function.RTD(“myDLLName.myClassModuleName,myMachineName,mySymbol,myField)
End function

Regards