coolksrini / pyrtd Goto Github PK

hi 
  i can call it in exceal =RTD("profrtd",,"Live","{6397},Change")
Traceback (most recent call last):
  File "C:\Users\sso\Desktop\test.py", line 18, in <module>
    time.connect()
  File "C:\Python27\lib\site-packages\rtd\client.py", line 54, in connect
    dispatch = client.Dispatch(self._classid)
  File "C:\Python27\lib\site-packages\win32com\client\__init__.py", line 95, in Dispatch
    dispatch, userName = dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx)
  File "C:\Python27\lib\site-packages\win32com\client\dynamic.py", line 108, in _GetGoodDispatchAndUserName
    return (_GetGoodDispatch(IDispatch, clsctx), userName)
  File "C:\Python27\lib\site-packages\win32com\client\dynamic.py", line 85, in _GetGoodDispatch
    IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, pythoncom.IID_IDispatch)
com_error: (-2146233079, 'OLE error 0x80131509', None, None)

Thank for your Help

What steps will reproduce the problem?
1. easy_install pyrtd
2. executing rtdtime.py at command line and see...

    Searching for pyrtd
    Reading https://pypi.python.org/simple/pyrtd/
    Best match: pyrtd 0.1.0
    Downloading https://pypi.python.org/packages/source/p/pyrtd/pyrtd-     0.1.0.tar.gz#md5=81ab3dc01e8531a7b7831d33c45a9ec1
    Processing pyrtd-0.1.0.tar.gz
    Writing C:\Users\lenny\AppData\Local\Temp\easy_install-g1jk4bne\pyrtd-0.1.0\setup.cfg
    Running pyrtd-0.1.0\setup.py -q bdist_egg --dist-dir      C:\Users\lenny\AppData\Local\Temp\easy_install-g1jk4bne\pyrtd-0.1.0
    \egg-dist-tmp-nb39xd2o
    zip_safe flag not set; analyzing archive contents...
    Adding pyrtd 0.1.0 to easy-install.pth file

    Installed c:\python34\lib\site-packages\pyrtd-0.1.0-py3.4.egg
    Processing dependencies for pyrtd
    Finished processing dependencies for pyrtd

What do you see instead?

Traceback (most recent call last):
  File "D:\Work\makemoney\rtdtime.py", line 14, in <module>
    from rtd import RTDClient
  File "C:\Python34\lib\site-packages\pyrtd-0.1.0-py3.4.egg\rtd\__init__.py", line 1, in <module>
ImportError: No module named 'client'

What version of the product are you using? On what operating system?

Python3.4 

Please provide any additional information below.

I've been playing around a little bit with real time data (RTD) functions, and 
thought I'd post something here in case anyone else was interested.

Using win32com and Chris Nilsson's example excelRTDServer.py (one of the 
win32com demos) it's pretty easy to get an RTD server working which you can 
then call from Excel with a formula like:

=RTD("Python.RTD.TimeServer","","seconds","5")

Please guide me to get data from above RTD server