Registered: Sep 2006
10-22-12 12:58 PM
I have searched google and this forum, also sterling trader support but still unable to get sterling trader pro's quotes into my excel 2010. I have read and carried out the following instructions in both these links:
and the better instructions here:
and i have re installed sterling many times over now. Still no luck. I never seen the DDE quoteserver menu appear in excel or any sterling menu in excel, so they obviously not comunicating. I have purchased the home and office package for excel 2010, but I did notice that i do not have an 'add in' menu except for in the options menu, where as if you look at the cyborg manual above there seems to be a 'Add in' menu where the quoteserver is located, but Im not sure if that picture is from a older excel version. How can I get this quoteserver menu in excel?
Been on this for weeks now and pulling my hair out, if anyone knows how I can easily set this up or if there is a workaround I would be extremely grateful as right now im having to copy and paste new values everyday and this is time consuming where as I just want quotes to update automatically which is what I figure the sterling dde does when it communicates with excel, once I type symbols in of course. I got no right click options to use the quoteserver or dde either once in a cell. I have net framework 1.1 and also 4.0 installed along with sql server. I should note that I have also checked the dde option in sterling and it does load up when I open sterling. All my trust centre settings are as links above.
This is really holding me back right now as I cannot produce the powerful spreadsheets that I want to as my time is spent copy and pasting.....Again if anyone could share with me what im doing wrong or a way around I would be extremely grateful to you.
I have the following menu's from left to right in my excel 2010