Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed

Outline · [ Standard ] · Linear+

 STOCK MARKET DISCUSSION V73, Blood Bath is Refreshing!

views
     
jeffwpl
post Feb 22 2011, 04:57 PM

Getting Started
**
Junior Member
259 posts

Joined: Oct 2009


check in!
airasia 2.55 matched blink.gif

This post has been edited by jeffwpl: Feb 22 2011, 04:58 PM
jeffwpl
post Feb 22 2011, 05:03 PM

Getting Started
**
Junior Member
259 posts

Joined: Oct 2009


rabbit ate too much red carrot till vomit sad.gif
jeffwpl
post Feb 22 2011, 05:16 PM

Getting Started
**
Junior Member
259 posts

Joined: Oct 2009


QUOTE(sopol @ Feb 22 2011, 05:05 PM)
pray you survive the crash and able to take off tomorrow... tongue.gif
*
tomolo go to kb playing wau....wow...~wow.....~ wow~~~
jeffwpl
post Feb 23 2011, 12:43 PM

Getting Started
**
Junior Member
259 posts

Joined: Oct 2009


ready to take-off in noon session flex.gif


Attached thumbnail(s)
Attached Image
jeffwpl
post Feb 23 2011, 03:43 PM

Getting Started
**
Junior Member
259 posts

Joined: Oct 2009


QUOTE(popcorn513 @ Feb 23 2011, 03:27 PM)
Seems he failed to take off
*
tyre punctured & rubber price sky high...pending purchase new tyres cry.gif
jeffwpl
post Feb 26 2011, 10:48 AM

Getting Started
**
Junior Member
259 posts

Joined: Oct 2009


QUOTE(alexander3133 @ Feb 25 2011, 11:18 PM)
I would like to share too... tongue.gif

This is perhaps (almost) realtime stock watch excel file, data obtain from Yahoo Finance.

Instructions:
For Excel 2003 or earlier users, download LYN_Realtime_Stock_2003.pdf and rename to LYN_Realtime_Stock_2003.xls
For Excel 2007 or 2010 users, download LYN_Realtime_Stock_07_10.pdf and rename to LYN_Realtime_Stock_07_10.xlsm

Note: This is an excel file which contain macro, basically used to obtain stock information from Yahoo Finance server. No worry, it contains NO malicious code that will harm your computer.

Once you successfully open the excel file, excel will normally block the active content, which is the macro. Excel will prompt you to enable or not.
You must enable the active content for the macro to run properly.

Once you enable it, you can start using and edit the excel file.

The yellow area is for you to enter your favourite stock code, the stock code must have ".KL" added behind the stock code, as shown in the spreadsheet.
The grey are is the last trade price for the stock you specified, the price will update automatically if you have "AutoRefresh" checked. Otherwise, you can manually refresh the price by pressing Ctrl + Alt + F5.

Note: Column A to column E are active columns, meaning the macro will get or modify information on those columns. You can modify your own column starting from column F onwards.

You can select any information you want to get from Yahoo Finance server from the drop down list at row 6 starting from column B to column E.

Play with the excel file and you able to discover more!

Any doubts, feel free to ask me. smile.gif

Screenshot:

user posted image
*
interesting....a million thx thumbup.gif
jeffwpl
post Feb 27 2011, 10:12 PM

Getting Started
**
Junior Member
259 posts

Joined: Oct 2009


notworthy.gif anyone knows there is a rubber factory at somewhere senawang, which own by PNB notworthy.gif

Topic ClosedOptions
 

Change to:
| Lo-Fi Version
0.0466sec    0.59    7 queries    GZIP Disabled
Time is now: 7th December 2025 - 10:14 PM