Hello Somebody know a website in which Excel 2007 can extracts the Put/Call Ratio data automatically? Thanks in advance
TOS, its not the website but the platform. It does it via DDE into Excel or Open Office. First open TOS then Open Office. Here is an example for Open Office, =DDE("TOS";"PUT_CALL_RATIO";"AAPL") This will give the put call ratio for Apple. To make DDE work under Vista, it wont work without a few tweeks, Start, Control Panel, User Accounts and Family Safety, User Accounts, Turn User Account Control on or off, Use User Account Control (UAC) to help protect your computer, Uncheck the box Click OK Vista will want to restart for this to take affect. Vista will be unhappy you did this and flag it with a security alert after the restart.