º¹ºÙ Çϴµ¥ Àß ³ª¿À·Á³ª ¸ð¸£°Ú±º¿ä. :)
Àú´Â °³ÀÎÀûÀ¸·Î ±¸±Û µå¶óÀ̺êÀÇ ½ºÇÁ·¹µå½ÃÆ®¸¦ ÅëÇØ ´Ù¾çÇÑ Á¤º¸µéÀ» ±â·ÏÇÏ°í ÀÖ½À´Ï´Ù. ±× Áß¿¡ Çϳª°¡ ¹Ù·Î Á¦°¡ ÅõÀÚÇÏ°í ÀÖ´Â ÁֽĿ¡ ´ëÇÑ Á¤º¸µéÀÔ´Ï´Ù. ¸ÅÀϸÅÀÏ ÁÖ°¡¸¦ µé¿©´Ùº»´Ù°í ÅõÀÚ¿¡ µµ¿òµÇ´Â ÀÏÀº ¾øÁö¸¸, ÃßÀ̸¦ »ìÇÇ°í, ¶Ç °¡²ûÀº ±Þ°ÝÇÑ ÁÖ°¡ÀÇ µî¶ôÀ¸·Î ÀÎÇÑ ¹è´ç·üÀÇ º¯È µîÀ» ÁöÄѺ¸´Âµ¥ Å« µµ¿òÀÌ µË´Ï´Ù.
¿À´ÃÀº ±¸±Û µå¶óÀ̺êÀÇ ½ºÇÁ·¹µå½ÃÆ®¸¦ ÅëÇØ ÁÖ½Ä Á¤º¸¸¦ °¡Á®¿À´Â ¹æ¹ýÀ» ¼Ò°³Çغ¼±î ÇÕ´Ï´Ù. (»ç½ÇÀº Àúµµ ÇÊ¿äÇÒ¶§¸¶´Ù ±¸±Û¸µÀ» ÇÏ´ÂÁö¶ó Á¤º¸ ÀúÀåÀÇ ¸ñÀûµµ ÀÖ½À´Ï´Ù. ^-^)
¹æ¹ýÀº ÀÇ¿Ü·Î °£´ÜÇÕ´Ï´Ù. ImportData¶ó´Â ÇÔ¼ö¸¦ ÀÌ¿ëÇϴµ¥, ƯÁ¤ data¸¦ importÇÏ¿© Ãâ·ÂÇØÁÖ´Â ÇÔ¼öÀÔ´Ï´Ù. ÁÖ½ÄÀ̳ª ´Ù¾çÇÑ °æÁ¦ °ü·Ã Á¤º¸´Â ¾ßÈÄ ÆÄÀ̳½½ºÀÇ Á¤º¸¸¦ °¡Á®¿À¸é µË´Ï´Ù.
=ImportData("http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=l1c6p2rp6&"&script!$A$1)
À§ÀÇ ÅؽºÆ®¸¦ ¸ðµÎ º¹»çÇÑ µÚ ±¸±Û ½ºÇÁ·¹µå½ÃÆ®¿¡ ºÙ¿©³Ö±â ÇÏ¸é ¾î¶² °á°ú°ªÀÌ ³ª¿Ã±î¿ä?
¿ÞÂʺÎÅÍ Â÷·Ê´ë·Î ¾ÖÇÃ(ÁÖ½Ä Á¾¸ñ ÄÚµå AAPL)ÀÇ ÇöÀç ÁÖ°¡ / ÀüÀÏ´ëºñ µî¶ô / ÀüÀÏ´ëºñ µî¶ôÀ² / PER / PBR ÀÇ ¼ø¼ÀÔ´Ï´Ù.
Áï, »¡°£»öÀ¸·Î Ç¥½ÃÇÑ ºÎºÐÀº Á¾¸ñ Äڵ带 ÀǹÌÇϸç ÆĶõ»öÀº º¸°íÀÚ ÇÏ´Â ÇØ´ç Á¾¸ñ¿¡ ´ëÇÑ Á¤º¸¸¦ ÀǹÌÇÏ°í ÀÖ½À´Ï´Ù. ÆĶõ»ö ºÎºÐ¿¡ µé¾î°¥ ¼ö ÀÖ´Â Á¤º¸µéÀº ¾Æ·¡¿Í °°½À´Ï´Ù. ¸î°¡Áö »ý¼ÒÇÒ ¼ö ÀÖ´Â ¿ë¾î¸¸ ¾Ë·Áµå¸±°Ô¿ä. ^^
- ask / bid : ¸Åµµ / ¸Å¼ö
- open / close : °³Àå / ÆóÀå
- book : ÀåºÎ
- dividend : ¹è´ç±Ý
- yield : ¹è´ç·ü
- change : µî¶ô
a | Ask | | k5 | % Change from 52-W |
a2 | Average Daily Volume | | l | Last Trade with Time |
a5 | Ask Size | | l1 | Last Trade (Price Only) |
b | Bid | | l2 | High Limit |
b2 | Ask (RT) | | l3 | Low Limit |
b3 | Bid (RT) | | m | Day¡¯s Range |
b4 | Book Value | | m2 | Day¡¯s Range (RT) |
b6 | Bid Size | | m3 | 50-Day MA |
c | % Change | | m4 | 200-D MA |
c1 | Change | | m5 | Change from 200-D MA |
c3 | Commission | | m6 | % Change from 200-D MA |
c6 | Change (RT) | | m7 | Change from 50-D MA |
c8 | After Hour Change (RT) | | m8 | % Change from 50-D MA |
d | Dividend/Sahre | | n | Name |
d1 | Last Trade Date | | n4 | Notes |
d2 | Trade Date | | o | Open |
e | Earning/Share | | p | Previous Close |
e1 | Error Indication | | p1 | Price Paid |
e7 | EPS Estimate Current Year | | p2 | Change in % |
e8 | EPS Estimate Next Year | | p5 | Price/Sales |
e9 | EPS Estimate Next Quarter | | p6 | Price/Book |
f6 | Float Shares | | q | Ex-Dividend Date |
g | Day¡¯s Low | | r | P/E Ratio |
h | Day¡¯s High | | r1 | Dividend Pay Date |
j | 52-Week Low | | r2 | P/E Ratio (RT) |
k | 52-Week High | | r5 | PEG Ratio |
g1 | Holding Gain % | | r6 | Price/EPS Estimate Current Year |
g3 | Annualized Gain | | r7 | Price/EPS Estimate Next Year |
g4 | Holding Gain | | s | Symbol |
g5 | Holding Gain % (RT) | | s1 | Shares Owned |
g6 | Holding Gain (RT) | | s7 | Short Ratio |
i | More Info | | t1 | Last Trade Time |
i5 | Order Book (RT) | | t6 | Trade Links |
j1 | Market Capitalization | | t7 | Ticker Trend |
j3 | Market Cap (RT) | | t8 | 1 Year Target |
j4 | EBITDA | | v | Volume |
j5 | Cahnge from 52-W Low | | v1 | Holding Value |
j6 | % Change from 52-W Low | | v7 | Holding Value (RT) |
k1 | Last Trade with Time (RT) | | w | 52-W Range |
k2 | Change % (RT) | | w1 | Day¡¯s Value Change |
k3 | Last Trade Size | | w4 | Day¡¯s Value Change(RT) |
k4 | Change from 52-W High | | x | Stock Exchange |
| | | y | dividend Yeild |
¿ì¸®³ª¶ó ÁÖ½ÄÀÇ °æ¿ì Á¾¸ñÄڵ尡 ¼ýÀÚ·Î µÇ¾îÀִµ¥, ¾ßÈÄ ÆÄÀ̳½½º¿¡¼´Â ÄÚ½º´Ú°ú ÄÚ½ºÇÇ°¡ ±¸ºÐµÇ¾îÀÖÀ¸¹Ç·Î °Å±â¿¡ ¸Â°Ô Á¾¸ñÄڵ带 ½áÁÖ¸é µË´Ï´Ù. :)
ÄÚ½ºÇÇÀÇ °æ¿ì Á¾¸ñÄÚµåµÚ¿¡ .KS¸¦ ºÙÀÌ°í ÄÚ½º´ÚÀÇ °æ¿ì´Â .KQ¸¦ ºÙÀÌ¸é µË´Ï´Ù.
Á¦°¡ »ç¿ëÇÏ´Â ¿¹¸¦ ¿Ã·Áº¾´Ï´Ù :)
²À ÁֽĻӸ¸ ¾Æ´Ï¶ó ÄÚ½ºÇÇ, ÄÚ½º´Ú, ȯÀ² µî ´Ù¾çÇÑ Á¤º¸µé¿¡µµ ÀÀ¿ëÀÌ °¡´ÉÇÏ´Ï À¯¿ëÇÏ°Ô »ç¿ëÇϼ¼¿ä! ^_^
´Þ·¯ ȯÀ²Àº Á¾¸ñÄÚµå ÀÚ¸®¿¡ "USDKRW=X"¶ó°í ³Ö¾îÁÖ½Ã¸é µÇ°í.
ÄÚ½ºÇÇ Áö¼ö´Â Á¾¸ñ ÄÚµå ´ë½Å¿¡ "^KS11" ÀÌ·¸°Ô ³ÖÀ¸¸é µË´Ï´Ù.
Á¦¸ñ¿¡ ½Ç½Ã°£À̶ó°í ÇصξúÁö¸¸ ½Ç½Ã°£Àº ¾Æ´Ï°í ¾î´ÀÁ¤µµ µô·¹ÀÌ°¡ ÀÖ±ä ÇÕ´Ï´Ù. ^-^a; ¿Ü±¹ ¼ºñ½ºÀÌ´Ï ±×Á¤µµ´Â °¨¾ÈÇØÁÖ½Ã°í »ç¿ëÇϼ¼¿ä! :)
¿ø¹® Ãâó : http://financialfreedom.kr/689
°¨»çÇÕ´Ï´Ù.