Monday, September 10, 2012

Getting Yahoo quotes into Excel

This link below shows a cool way to get Yahoo Stock quotes from Excel. It has a limitation of only allows to  get a maximum of 10 fields as it is being limited by Yahoo.

http://www.gummy-stuff.org/Yahoo-data.htm

Tuesday, September 4, 2012

How to Determine Whether your PC is being connected to a Domain Controller from Command Prompt (cmd)?

1. Type "set user" and Press "Enter" in the command prompt.
2. The result will show you:-
USERDNSDOMAIN=YourDNSDomain
USERDOMAIN=YourDomainName
USERNAME=YourLogonUsername
USERPROFILE=YourProfileDirectoryPath

How to Determine Which Domain Controller a PC is Using from Command Prompt (cmd)?

1. Type in that window "set logonserver" without quotes. Press "Enter" key.
2. Read the result of the output. The output will show you LOGONSERVER= and after the equals sign will be the name of the logon server.