// API callback
randomposts({"version":"1.0","encoding":"UTF-8","feed":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$openSearch":"http://a9.com/-/spec/opensearchrss/1.0/","xmlns$blogger":"http://schemas.google.com/blogger/2008","xmlns$georss":"http://www.georss.org/georss","xmlns$gd":"http://schemas.google.com/g/2005","xmlns$thr":"http://purl.org/syndication/thread/1.0","id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136"},"updated":{"$t":"2018-09-16T21:00:19.921-07:00"},"category":[{"term":"Excel小撇步"},{"term":"股票"},{"term":"財經知識"},{"term":"理財工具"},{"term":"財經辭典"},{"term":"理財資訊"},{"term":"行事曆"},{"term":"財經個人觀點"}],"title":{"type":"text","$t":"小老百姓的財經觀察"},"subtitle":{"type":"html","$t":"我不是股票基金經理人，也不是財經專家，我純粹只是想賺點養老金，又不想把錢交給別人管理。\n我將把我的股票投資經驗在這裡與大家分享...\n我也加入了一些Excel的技巧，Excel弄懂了才比較可以弄懂賺賠..."},"link":[{"rel":"http://schemas.google.com/g/2005#feed","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/posts\/default"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default?alt=json-in-script\u0026max-results=1000"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/"},{"rel":"hub","href":"http://pubsubhubbub.appspot.com/"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"generator":{"version":"7.00","uri":"http://www.blogger.com","$t":"Blogger"},"openSearch$totalResults":{"$t":"37"},"openSearch$startIndex":{"$t":"1"},"openSearch$itemsPerPage":{"$t":"1000"},"entry":[{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-1645541396991524044"},"published":{"$t":"2014-04-02T03:21:00.001-07:00"},"updated":{"$t":"2014-04-02T03:22:20.805-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"理財資訊"}],"title":{"type":"text","$t":"[報稅]3個地方查詢自己繳了「健保補充保費」"},"summary":{"type":"text","$t":"每年的五月都是報稅的季節，今年(103年)首次採計健保補充保費申報，而且健保補充保費沒有上限的限制，若民眾選擇採用「列舉扣除額」方式，健保保費和補充保費皆可以全額列舉扣除。但是補充保費的來源複雜，包含銀行存款利息、投資股市的股利等都可能被扣健保補充保費，而且不會有紙本繳費單寄來家裡，健保局建議民眾可尋求以下3種管道，一次取得並列印「一般保費與補充保費」的明細資料。  方法一：使用「自然人憑證」，5月1日起到「國稅局網站」使用綜所稅電子結算申報軟體，或是4月中旬起上網到「健保署網站」申辦、查詢、下載。  方法二：也可親自攜帶個人身分證正本，到國稅局所屬分局、稽徵所，健保署各分區業務組或聯絡辦公室臨櫃查詢申請。  方法三：可以就近至鄰近的超商「多媒體資訊工作站」使用自然人憑證，列印前一年度繳費的繳費證明。     "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/1645541396991524044\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=1645541396991524044\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1645541396991524044"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1645541396991524044"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2014\/04\/3.html","title":"[報稅]3個地方查詢自己繳了「健保補充保費」"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-55418775600868886"},"published":{"$t":"2011-11-27T03:12:00.001-08:00"},"updated":{"$t":"2011-11-27T03:12:33.438-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"財經辭典"}],"title":{"type":"text","$t":"股票交易：何謂三大法人?"},"summary":{"type":"text","$t":"法人是指法律上具有人格的組織，它們就像自然人一樣享有法律上的權利與義務，可以發起或接受訴訟。法人能夠以政府、法定機構、公司、法團等形式出現。具有民事權利能力和民事行為能力，依法獨立享有民事權利和承擔民事義務。就像自然人一樣，可以承擔刑事責任，不過跟自然人不同之處就是自由刑對法人而言並不適用，法人所接受的刑罰一般以罰款為限。  所以法人大概就是指那些非個人，而是機關、單位、或公司…等。而一般我們在股市上常聽到的三大法人指的是外資、投信、自營商。因為這三大法人經常挾帶豐沛的龐大資金進出股市，凡是其所相中的標的，無不隨其資金動向而波動，因而備受矚目。         外資        也就是QFII ( QUALIFIED FOREIGN NSTITUTIONAL INVESTORS的簡稱)，即合格的外國機構投資者。也就是被政府允許並核準的合格外國機構投資者，但必須要在中央銀行的監管下，匯入"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/55418775600868886\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=55418775600868886\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/55418775600868886"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/55418775600868886"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2011\/11\/blog-post.html","title":"股票交易：何謂三大法人?"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-4342063546980094632"},"published":{"$t":"2011-10-05T02:57:00.001-07:00"},"updated":{"$t":"2011-10-05T02:59:15.728-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"財經知識"}],"title":{"type":"text","$t":"看老美如何玩貨幣債券的金錢遊戲(轉貼)"},"summary":{"type":"text","$t":"  這好像是一篇大陸寫的關於紙鈔、貨幣、債卷的解釋，描寫得非常的生動，花點時間看完，會是是一堂很有用的金融課，讓我這個非財務出身的人也看得懂，我把其中一些用語改成了我們較熟悉的用法。    錢是什麼？  錢就是「借據」。不管是黃金、白銀，還是紙鈔，或是電子錢幣，本質上都是「借據」。黃金、白銀、紙幣、電子錢幣的地位也都是平等的，『金本位貨幣』的理論是錯誤的。   假設世界上只有兩家人，老美家兩口子和老華家兩口子，一開始他們兩家各幹各的，自給自足。一天，老美捉了4條魚，老華逮了8隻鳥，老美想嘗嘗鳥味，老華想品品魚鮮，他們就交換了，老美用2條魚換了老華的4隻鳥。以後他們常常這樣交換。       有一天，老美懶了，沒去捉魚，在家睡了一天。晚上，老華逮鳥回家，老美沒東西吃，就找老華借鳥吃。老美找一張樹皮，在上面寫上：2條魚。到老華家後，對老華說：『我來換你4隻鳥。不過，我今天生病了，沒能去捉魚，"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/4342063546980094632\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=4342063546980094632\u0026isPopup=true","title":"2 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4342063546980094632"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4342063546980094632"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2011\/10\/blog-post.html","title":"看老美如何玩貨幣債券的金錢遊戲(轉貼)"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"thr$total":{"$t":"2"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-178011567355015630"},"published":{"$t":"2010-04-30T21:35:00.001-07:00"},"updated":{"$t":"2010-04-30T21:35:12.522-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"財經知識"}],"title":{"type":"text","$t":"綜合所得稅的房貸利息與股票股利"},"summary":{"type":"text","$t":" 政府兩稅合一制度實施後，我一直搞不清楚房貸利息需要扣除哪些利息？到底「股票股利」要不要也列入計算？讓我不太敢參加一些股票的除權息。以前我很確定，只要扣除銀行等金融機構的利息收入，剩下的就可以列入「自用住宅購屋借款利息」的扣除額，今年我總算搞清楚，只需要扣除「儲蓄投資特別扣除額」，股票股利是不需要列入計算的，所以今年就可以選擇一些績優股來參加除權息了。  下面我查詢了一些國稅局關於「自用住宅利息」與「儲蓄投資特別扣除額」的規定，僅供參考，一切還是要以國稅局定義的為準：                                  自用住宅購屋借款利息作為綜合所得稅列舉扣除額規定                   財政部臺北市國稅局表示，納稅義務人列報綜合所得稅自用住宅購屋借款利息列舉扣除額，需符合下列規定：              一、該房屋的所有權人為納稅義務人本人、配偶或受"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/178011567355015630\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=178011567355015630\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/178011567355015630"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/178011567355015630"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2010\/04\/blog-post.html","title":"綜合所得稅的房貸利息與股票股利"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh6.ggpht.com\/_R3506kYXSHI\/S9uvfwanCrI\/AAAAAAAAASA\/5WBbW1jWVQ4\/s72-c\/Tax01_thumb%5B2%5D.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-4150946490471289137"},"published":{"$t":"2009-09-05T19:15:00.001-07:00"},"updated":{"$t":"2009-09-05T21:57:02.777-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"行事曆"}],"title":{"type":"text","$t":"2010年(民國99年)行事曆"},"summary":{"type":"text","$t":"來湊一下熱鬧，提供一下2010年(民國99年)的政府機關行事曆，也可以作為股市操作的參考。  有需要下載 Excel檔的人，可以到這裡下載 http:\/\/www.cpa.gov.tw\/public\/attachment\/981410483110.xls  這是由行政院 人事行政局所公佈的行事曆，如果有錯請找人事行政局啊！ http:\/\/www.cpa.gov.tw\/ct.asp?xItem=7243\u0026ctNode=765\u0026mp=1     元旦：1月1日(星期五)，有三天連續假期     為了要在農曆年連續放九天年假，2月6日要先補上班，應該是值得啊！     農曆年除夕：2月13日(星期六)     農曆年放假：2月14日(星期日)～2月20日 (星期日) ，加除夕共九天，爽啊！     228紀念日：2月28日(星期日) 可惜啊！！應該沒假放了！     婦幼節：3月8日(星期一) "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/4150946490471289137\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=4150946490471289137\u0026isPopup=true","title":"1 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4150946490471289137"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4150946490471289137"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2009\/09\/year-2010-99-taiwan-calendar.html","title":"2010年(民國99年)行事曆"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh3.ggpht.com\/_R3506kYXSHI\/SqMbU-gwCrI\/AAAAAAAAARw\/scon4Ubm2kk\/s72-c\/year2010%2Byear99_calendar_thumb.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"1"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-6437715289404788266"},"published":{"$t":"2009-08-25T21:40:00.001-07:00"},"updated":{"$t":"2010-05-15T22:30:42.660-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"股票"}],"title":{"type":"text","$t":"台股股市操作行事曆"},"summary":{"type":"text","$t":"僅供參考…              1月：        可買進        年初資金充沛                  2月：        可買進        農曆過年，紅包行情，醞釀董監事改選行情                  3月：        可賣出        達停利點就賣出                  4月：        宜賣出        股東會行情，股東回補股票                  5月：        不操作        窮，電子淡季、大股東賣股報稅                  6月：        不操作        絕，電子淡季                  7月：        不建議操作        除權\/除息旺季，外資放暑假、增資股陸續上市，通常會量縮整理                  8月："},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/6437715289404788266\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=6437715289404788266\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/6437715289404788266"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/6437715289404788266"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2009\/08\/taiwan-stock-calendar.html","title":"台股股市操作行事曆"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-5928480485728840993"},"published":{"$t":"2009-08-12T05:07:00.001-07:00"},"updated":{"$t":"2009-08-14T08:34:46.879-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"股票"}],"title":{"type":"text","$t":"台股災後重建可能受惠股"},"summary":{"type":"text","$t":" 雖然我們不樂見災難，但每次天災之後，股市裡總是有些類股大賺災難財，比如說風宅經濟發燒，遊戲、大賣場及便利商店就會受惠。當水災過後，清潔用品商就會受惠。當有災難造成屋毀、橋斷時，水泥、鋼鐵、工程就會受惠，但也要留意原來的工程或資產是否有受到影響而影響股價。  下面我們試著來整理著些可能發災難財的股票，要注意的是不見得會全部受惠：     水泥\/預拌混凝土：用於橋樑、房屋重建              台泥 (1101)、 亞泥(1102)、嘉泥(1103)、東泥(1110，南部)、幸福(1108，南部)、信大 (1109，宜蘭)、國產(2504，混凝土)                 鋼鐵：用於橋樑、房屋重建              鋼鐵：中鋼(2002)         鋼筋\/型鋼：豐興(2015)、威致(2028)、東剛(2006)、海光(2038)         鋼構廠：中鋼"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/5928480485728840993\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=5928480485728840993\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/5928480485728840993"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/5928480485728840993"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2009\/08\/calamity-reconstruct-stock-taiwan.html","title":"台股災後重建可能受惠股"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh3.ggpht.com\/_R3506kYXSHI\/SoKynoXSY6I\/AAAAAAAAARg\/V-Icr0aLhBw\/s72-c\/calamity01_thumb%5B1%5D.gif?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-1344985044788442493"},"published":{"$t":"2009-05-19T07:08:00.001-07:00"},"updated":{"$t":"2009-06-18T19:52:26.634-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"股票"}],"title":{"type":"text","$t":"[股票] 98年度個股扣抵稅率"},"summary":{"type":"text","$t":" 又到了報稅的季節，稅繳得有點心痛，好在去年選了一些高扣抵稅率的個股，所以今年報稅時有點給它補了回來。怎麼說呢？因為「扣抵稅率」越高就表示「扣繳稅額」越高，也就是說到了報稅的時候就可以賺到退稅金。  所以囉！如果可以在合理價格買到強勢的高扣抵稅率的股票，並參加除權息，除了有機會填權息外，也可以賺「扣繳稅額」，但投資總是有風險就對了，股票不保證可以填全息的，也有可能貼權息啊！  但必須要注意「扣抵稅率」要高過「個人綜所稅率」，這樣才可已有省稅的功能。假如你是13％的綜所稅率者，那麼你必須要找扣抵稅率高過13％的股票才划算，否則反而要多繳股利的稅金，因為股利會被當作是所得的一部分。  舉例說，陳先生適用綜所稅率13%，他買了A公司每股50元的股票10張，該股計畫配發5元現金股利，稅額扣抵比率為19.95%，王先生參與除息可獲得5萬元的股利外，還可以額外退稅3095元[(19.19％-13％)"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/1344985044788442493\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=1344985044788442493\u0026isPopup=true","title":"2 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1344985044788442493"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1344985044788442493"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2009\/05\/98.html","title":"[股票] 98年度個股扣抵稅率"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh5.ggpht.com\/_R3506kYXSHI\/ShK_LWzxfYI\/AAAAAAAAAQ0\/Pz9JEUrleKg\/s72-c\/stock01_thumb%5B1%5D.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"2"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-7767193949832414095"},"published":{"$t":"2009-05-13T00:04:00.001-07:00"},"updated":{"$t":"2009-05-13T00:04:07.376-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"財經辭典"}],"title":{"type":"text","$t":"MSCI指數"},"summary":{"type":"text","$t":"MSCI指數是由摩根史丹利資本國際公司 (Morgan Stanley Capital International) 所編制的證卷指數，指數類型包括國家、地區、產業等。MSCI指數所組成的股票，大多是股市中的大型股或各產業的龍頭股，由於其業績及財務穩定度相對較高，故為歐美基金經理人對全球股市投資及資產分配的重要參考指標。  MSCI指數權重調整的影響層面為，主動式基金會在季度調整生效前進行調整，追蹤指數的被動式基金，隨後會在生效日跟著權重調整。  由於籌碼卡位的結果，造成權重遭到增刪的個股，在季度調整生效前一周的股價反應，會比正式反應當周來得顯著。 也就是說，MSCI指數權重調整的前一週通常會造成相關股價的波動，通常反應是被新增的會大漲，被剃除的則大跌。  MSCI指數權重季度調整一年有四次，分別在每年的2月、5月、8月及11月。5月跟11月為半年度調整，其考量因素較為全面，因此，其"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/7767193949832414095\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=7767193949832414095\u0026isPopup=true","title":"1 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/7767193949832414095"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/7767193949832414095"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2009\/05\/msci.html","title":"MSCI指數"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"thr$total":{"$t":"1"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-2581804650078615741"},"published":{"$t":"2009-04-14T07:22:00.001-07:00"},"updated":{"$t":"2009-04-14T07:25:00.322-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"},{"scheme":"http://www.blogger.com/atom/ns#","term":"理財工具"},{"scheme":"http://www.blogger.com/atom/ns#","term":"股票"}],"title":{"type":"text","$t":"[股票] 利用巨集指令，一指搞定最新股價查詢"},"summary":{"type":"text","$t":"前面介紹過如何從網路下載最新股價，還有股價損益的計算，今天再來介紹如何利用Excel的【巨集】錄製，只要一個按鈕就可以讓 Excel自動更新股價並得知股票投資的賺賠。     [股票]用Excel查詢各股收盤行情       [股票] 用Excel計算股票損益   1. 所先開啟前面已經完成的【stock.xls】，然後在功能表上選【工具】→【巨集】→【錄製巨集】。     2. 開啟【錄製巨集】對話框，將『巨集名稱』從【Macro1】改為【stock_update】，然後按【確定】。     3. 開始錄製巨集時，會出現一個小小的巨集控制框，（※請注意：錄製巨集時物讓滑鼠或是鍵盤操作多餘的動作），  4. 先按【收盤行情】工作表。       5. 把滑鼠放到【A4】欄位，然後按滑鼠右鍵，在快顯功能表上按【更新資料】。（※注意：可參考前面兩篇文章的資料更新，請確認網路已經接上）"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/2581804650078615741\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=2581804650078615741\u0026isPopup=true","title":"7 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/2581804650078615741"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/2581804650078615741"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2009\/04\/stock-macro.html","title":"[股票] 利用巨集指令，一指搞定最新股價查詢"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh6.ggpht.com\/_R3506kYXSHI\/SeSbEStAujI\/AAAAAAAAAPY\/qkui-hiLWsc\/s72-c\/stock_macro01_thumb%5B2%5D.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"7"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-1287523710645447351"},"published":{"$t":"2009-04-09T01:00:00.001-07:00"},"updated":{"$t":"2009-04-09T18:09:38.716-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"},{"scheme":"http://www.blogger.com/atom/ns#","term":"理財工具"},{"scheme":"http://www.blogger.com/atom/ns#","term":"股票"}],"title":{"type":"text","$t":"[股票] 用Excel計算股票損益"},"summary":{"type":"text","$t":"續前一篇 －用Excel查詢各股收盤行情，這一篇需要有比較強的 Excel 觀念，否則容易出錯，也許有更簡單的方法，但我還沒發現，也許看倌們可以提供你們的意見與指教。  ※寫在前頭，請確實按照圖示的欄位放置文字及資料，因為有參照欄位位址，怕出錯，所以請先照圖示，技巧高超的高手就不用提醒了。  下面的方法運用到下列知識     [Excel小撇步] [複製格式]不需要重複按 ─ 持續多次「格式複製」     [Excel小撇步] 了解【相對位址】及【絕對位址】     [Excel小撇步] 快速切換【絕對位址】的方法 ─ 好用的 [F4] 按鍵     LOOKUP()  函數            記得要把上一篇的【收盤行情】另存成Excel的檔案，之前我們把它存成【Stock.xls】，現在點兩下把它打開。  1.新增一個【股票買賣】工作表     在功能表上按【插入】→【工作表】，"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/1287523710645447351\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=1287523710645447351\u0026isPopup=true","title":"5 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1287523710645447351"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1287523710645447351"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2009\/04\/stock-profit-loss.html","title":"[股票] 用Excel計算股票損益"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh3.ggpht.com\/_R3506kYXSHI\/Sd2q8QNksMI\/AAAAAAAAAO4\/0cdWZEOhzm0\/s72-c\/check_stock01_thumb.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"5"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-5781800566223748674"},"published":{"$t":"2009-04-05T20:30:00.001-07:00"},"updated":{"$t":"2009-04-09T01:09:12.558-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"},{"scheme":"http://www.blogger.com/atom/ns#","term":"理財工具"},{"scheme":"http://www.blogger.com/atom/ns#","term":"股票"}],"title":{"type":"text","$t":"[股票]用Excel查詢各股收盤行情"},"summary":{"type":"text","$t":"一直想找時間整理如何用Excel計算股票投資的獲利與損失，今天先教大家如何使用Excel下載各股的收盤行情並存成工作表，後面我們就可以用這個工作表來計算股票投資的獲利與損失。  因為我還在使用 Excel 2000，我知道更新的版本可以比較簡單的達到目的，但我這裡所提供的方法應該可以適用所有 Excel 2000 以後的版本。  1. 先在桌面的空白處按滑鼠右鍵，新增一個【文字文件】，就是一般人所說得【記事簿】。     2. 在這個【文字文件】中輸入以下的網址，可以用複製的以免輸入錯誤。     http:\/\/www.sinotrade.com.tw\/today_stock_price.htm             3. 然後按功能表的【檔案】→【另存新檔】。在【存檔類型】的欄位按【v】下拉選單並選擇【所有檔案】，在【檔名】的欄位處輸入【收盤行情.iqy】檔名，最後按【儲存】按鈕。"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/5781800566223748674\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=5781800566223748674\u0026isPopup=true","title":"22 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/5781800566223748674"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/5781800566223748674"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2009\/04\/excel-to-get-stock-price.html","title":"[股票]用Excel查詢各股收盤行情"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh6.ggpht.com\/_R3506kYXSHI\/Sdl3J3PRMDI\/AAAAAAAAAN4\/soUTOxhREAw\/s72-c\/inquire_stock01_thumb.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"22"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-3743661258605402397"},"published":{"$t":"2009-02-12T01:42:00.001-08:00"},"updated":{"$t":"2009-02-19T06:53:57.370-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"理財工具"}],"title":{"type":"text","$t":"適合台灣人用的記帳軟體 (使用Excel)"},"summary":{"type":"text","$t":"使用了一段時間，是個不錯得記帳軟體，介紹給大家。它使用的介面是 MS-Excel，所以你必須要先安裝有 MS-Excel 才能使用，另外，不論是 Excel 2000, 2003到 2007 都可使用，要注意的是，不適用在 Windows 2000 的作業系統。  特色：     內建浮動支出、固定支出、收入等項目。     可以自建、新增、修改「支出名稱」、「收入名稱」。     整合你的銀行、信用卡帳號，並自動計算出你的現金流量。     計算信用卡累積應繳金額及未還金額。     可於行事曆中自訂重要紀念日、例假日、及提醒通知。     自動產生「月報表」及「年度報表」，讓你一目了然每個月花了多少錢，錢花到哪裡去了。     提供多種年度的圖表，有薪水收入曲線、花費項目比例…等。    軟體下載：  下載網站：雙胞胎拔拔       軟體論壇：17 Saving 論壇"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/3743661258605402397\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=3743661258605402397\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/3743661258605402397"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/3743661258605402397"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2009\/02\/excel.html","title":"適合台灣人用的記帳軟體 (使用Excel)"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh4.ggpht.com\/_R3506kYXSHI\/SZPu2MIUMZI\/AAAAAAAAAMw\/5hB46szZWQY\/s72-c\/account01_thumb%5B1%5D.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-5264644551581756740"},"published":{"$t":"2009-02-07T06:57:00.001-08:00"},"updated":{"$t":"2009-02-07T07:00:31.017-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"財經辭典"}],"title":{"type":"text","$t":"M1A M1B M2 與股市的互動"},"summary":{"type":"text","$t":"M1A 貨幣總計數      M1A表示金融機構以外的各行各業目前流通所持有的通貨淨額、支票存款及活期存款的總合。也就是社會大眾手中持有的通貨，再加上企業及個人與非營利團體存在銀行與基層金融機構之支票存款及活期存款。(※注意：不包括定存)        M1A＝（通貨發行額－金融機構的庫存現金）＋支票存款＋活期存款。  M1B 貨幣總計數      包括通貨淨額、支票存款以及活期存款與活期儲蓄存款3大項（依中央銀行定義）。以數學記號表示如下：      M1B＝通貨淨額+存款貨幣＝M1A+個人企業及個人(含非營利團體)在貨幣機構的活期儲蓄存款。  M2 廣義貨幣供給額       M2是貨幣供給額項目之一，是中央銀行用以衡量經濟情勢主要項目之一，以數學記號表示如下：      M2＝M1B+準貨幣。          簡單來說，  M1A = 國人所有的短期流通資金      M1B ="},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/5264644551581756740\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=5264644551581756740\u0026isPopup=true","title":"1 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/5264644551581756740"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/5264644551581756740"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2009\/02\/m1a-m1b-m2.html","title":"M1A M1B M2 與股市的互動"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"thr$total":{"$t":"1"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-6165896730252784232"},"published":{"$t":"2009-02-07T06:29:00.001-08:00"},"updated":{"$t":"2009-02-07T06:29:05.204-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"財經辭典"}],"title":{"type":"text","$t":"景氣對策信號"},"summary":{"type":"text","$t":"所謂「景氣對策信號」，乃類似交通號誌的一組標誌，針對不同的景氣狀況發出不同的信號以供政府擬定因應措施之參考，同時業者亦可藉信號的變化，了解政府所可能採取措施的意向，而妥為因應。  「景氣對策信號」共有5種不同顏色的燈號，目前由貨幣總計數Ｍ1B變動率等9項指標構成。每月依各構成項目之年變動率變化，與其檢查值做比較後，視其落於何種燈號區間給予分數及燈號，並予以加總後即為綜合判斷分數及對應之景氣對策信號。  景氣對策信號各燈號之解讀意義如下：     若對策信號亮出「綠燈」，表示當前景氣穩定。     「紅燈」表示景氣熱絡。     「藍燈」表示景氣低迷。     至於「黃紅燈」及「黃藍燈」二者均為注意性燈號，宜密切觀察後續景氣是否轉向。    目前景氣對策信號各構成項目及檢查值如下：             (↑以上影像來源為：行政院經濟建設委員會)    "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/6165896730252784232\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=6165896730252784232\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/6165896730252784232"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/6165896730252784232"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2009\/02\/blog-post.html","title":"景氣對策信號"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh6.ggpht.com\/_R3506kYXSHI\/SY2ar8w1u8I\/AAAAAAAAAMo\/rR3IqIGs6sc\/s72-c\/Monitoring_indicator080202_thumb%5B2%5D.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-8141941847263751217"},"published":{"$t":"2008-12-29T02:32:00.001-08:00"},"updated":{"$t":"2009-04-05T20:31:30.453-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"股票"}],"title":{"type":"text","$t":"[股票] 投資股票前的準備工作 II ─網路下單軟體"},"summary":{"type":"text","$t":"如果你是一個坐辦公室的上班族，又想要偶而玩玩股票，那麼推薦你一定要使用【網路下單軟體】，它最大的好處是  網路下單不需要透過營業員，所有手續費的優惠，就是折扣啦。 要注意的是，     每筆折扣都有最低手續費 NT20，也就是說如果單筆手續費低於 NT20，則以 NT20 計費。一般的手續費都是交易價X0.001425，反推交易價為 20\/0.001425 = 14035(元)以下才會少於NT20元，也就是說買賣一支股票在NT14.035(元)以下會有手續費低於 NT20 的情形，另外在零股買賣時也容易出現手續費低於 NT20 的情況。     還有，折扣的手續費一般都是月結，卷商會結算一個月的手續費後折讓給你。    另外我看了一下，其實大部分的網路下單收續費幾乎都是 6～65 折之間。因為我沒有在玩融資、卷，也不鼓勵，所以就不考慮了，見諒！"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/8141941847263751217\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=8141941847263751217\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/8141941847263751217"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/8141941847263751217"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/12\/ii.html","title":"[股票] 投資股票前的準備工作 II ─網路下單軟體"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh4.ggpht.com\/_R3506kYXSHI\/SXg-eZ4iTlI\/AAAAAAAAAMQ\/YEaNRXjGN_8\/s72-c\/yuanta01_thumb.gif?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-7986515114460615110"},"published":{"$t":"2008-12-19T08:26:00.001-08:00"},"updated":{"$t":"2008-12-19T08:26:33.240-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 【Excel 註解】也可以列印"},"summary":{"type":"text","$t":"Excel 有【註解】的功能，但有時候會想要在列印時連【註解】一起印出，但預設值無法列印【註解】，這裡教你如何連同【註解】一起列印 Excel 報表。  在功能表上選【檔案】→【版面設定】→ 切換到【工作表】頁籤 → 選擇 【註解(M):】後面的三角形按鈕。  這裡有三個選項：     【無】 → 預設值    【顯示在工作表底端】     【和工作表的顯示狀態相同】    一般選擇【和工作表的顯示狀態相同】。     設定完成後，【註解】真的列印出來了。     ※注意：欲列印【註解】時，不能從【預覽列印】→【設定】的地方設定，一定要從【版面設定】的地方進去才可以設定。須要先設定【顯示註解】，否則    "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/7986515114460615110\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=7986515114460615110\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/7986515114460615110"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/7986515114460615110"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/12\/excel-excel.html","title":"[Excel小撇步] 【Excel 註解】也可以列印"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh4.ggpht.com\/_R3506kYXSHI\/SUvLJzEpHBI\/AAAAAAAAALo\/wXiFFHFzpoY\/s72-c\/Excel_print21_thumb.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-3386047094779398528"},"published":{"$t":"2008-12-19T07:04:00.001-08:00"},"updated":{"$t":"2008-12-19T07:46:30.455-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 列印的一些觀念 III"},"summary":{"type":"text","$t":"4.  設定幾頁寬、幾頁高   上面提到【調整列印範圍】把列印資料調整到同一頁寬以節省紙張及方便閱讀，可是如果超出頁寬的資料太多，僅用【調整列印範圍】的方法是無法完全滿足的，這裡提供第二個方法，【設定幾頁寬、幾頁高】。          設定【幾頁寬、幾頁高】前要先留意預覽列印時的總頁數，以下面的例子，預覽列印時顯示總共有６頁，但是有一半的頁數為超出的頁面，所以實際頁數應該只有 3頁(=6\/2)，所以會設定成１頁寬及３頁高。原則上都是設計成１頁寬。          設定時，在功能表上選【檔案】→【版面設定】→ 切換到【頁面】頁簽 → 點選【調整成 頁寬 頁高】，然後填入【１】頁寬、【３】頁高 → 按【確定】鈕完成。      完成後可以看到原本超出頁面的兩個欄位已經縮到同一頁面了，總頁數也可以看得出來是３頁。          5. 調整百分比設定 → 建議再調小1～2%最為穩定   "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/3386047094779398528\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=3386047094779398528\u0026isPopup=true","title":"2 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/3386047094779398528"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/3386047094779398528"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/12\/excel-iii.html","title":"[Excel小撇步] 列印的一些觀念 III"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh5.ggpht.com\/_R3506kYXSHI\/SUu3yc7AeGI\/AAAAAAAAAKE\/MOCEndOkHsc\/s72-c\/excel_print10s_thumb%5B4%5D%5B2%5D.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"2"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-25788514215118021"},"published":{"$t":"2008-12-17T23:00:00.001-08:00"},"updated":{"$t":"2008-12-19T07:47:35.438-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 列印的一些觀念 II"},"summary":{"type":"text","$t":"    …續前一篇       3. 設定列印邊界  這是很討厭的一件事，由於列印的資料稍微超出了列印範圍，所以會有一欄資料被列印到另外一頁，這樣子不但浪費紙張，而且閱讀起來也不連貫。        像這一類的問題，可以有幾種方法可以克服。  方法一，是稍微調整一下【列印邊界】，讓頁面可以容納超出的那一欄。  從功能表上選【檔案】→【預覽列印】→ 點選【邊界(M)】按鈕 → 用滑鼠把列印邊界線拖曳向左右邊 → 原來列印在另一頁的資料已經出現在同一頁了。             未完，按後面的數字繼續閱讀 1…3                           延伸閱讀：    [Excel小撇步] 快速調整【最適欄寬】的方法     Excel小撇步整理  "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/25788514215118021\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=25788514215118021\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/25788514215118021"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/25788514215118021"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/12\/excel-ii.html","title":"[Excel小撇步] 列印的一些觀念 II"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh5.ggpht.com\/_R3506kYXSHI\/SUn1GO43j1I\/AAAAAAAAAKc\/5ngp-J9HneQ\/s72-c\/Excel_print07s_thumb%5B2%5D.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-5504693548052526576"},"published":{"$t":"2008-12-17T21:44:00.001-08:00"},"updated":{"$t":"2008-12-19T07:55:17.419-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 列印的一些觀念 I"},"summary":{"type":"text","$t":"Excel 報表列印人人會，但如何列印出一份美觀、簡潔又解省紙張的 Excel 報表，可能就需要一點功力了，這裡將個人的心得與大家分享。  Excel 列印前有幾個動作要先設定：     把欄位調整至最適欄寬。     設定列印文件水平置中。     設定列印邊界。     設定幾頁寬、幾頁高 。     調整百分比設定。              1. 把欄位調整至最適欄寬。         調整最適欄寬可以參考這篇文章。 快速調整【最適欄寬】的方法         列印時最怕有些欄寬調整不當而出現【＃】號，有時明明在 Excel畫面下檢查，所有的數值都可以正常顯示，但到了列印出來或是【預覽列印】時就變成【＃】。                         2. 設定列印文件水平置中               參考下面兩份同樣的文件，左邊的文件靠左對齊，右邊的文件為水平置中，相信"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/5504693548052526576\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=5504693548052526576\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/5504693548052526576"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/5504693548052526576"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/12\/excel-i.html","title":"[Excel小撇步] 列印的一些觀念 I"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh5.ggpht.com\/_R3506kYXSHI\/SUnjFAjDizI\/AAAAAAAAAJQ\/eWOe8y_PSWo\/s72-c\/Excel_print013_thumb2.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-2130214784744170173"},"published":{"$t":"2008-11-14T05:35:00.001-08:00"},"updated":{"$t":"2008-11-14T05:51:57.865-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 原來【欄位寬度】也可以複製"},"summary":{"type":"text","$t":"Excel中有些貼心小撇步可以幫我們節省一些操作步驟，這個【欄位寬度】複製就是個不錯的小撇步。  欄寬也可以複製，當你想要複製欄寬時：  1. 先選取您要複製寬度的欄標題。 (↓下圖Ａ欄為調整後的欄寬15.0，Ｂ欄則維持8.38的預設欄寬)          2. 按一下[格式] 工具列上的 [複製格式] 按鈕 。 (↓先點選要複製寬度的欄標題，然後再點 [複製格式]按鈕)         3. 然後再按一下您想要複製寬度到的欄標題。(※請注意：有合併儲存格時不能使用)      (↓將滑鼠移到欲變更欄寬的欄位標題位置後按滑鼠左鍵)         (↓完成欄寬複製)               延伸閱讀：    [Excel小撇步] 快速調整【最適欄寬】的方法     Excel小撇步整理  "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/2130214784744170173\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=2130214784744170173\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/2130214784744170173"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/2130214784744170173"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/11\/excel_14.html","title":"[Excel小撇步] 原來【欄位寬度】也可以複製"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh4.ggpht.com\/_R3506kYXSHI\/SR1-hN8OE3I\/AAAAAAAAAIo\/9XZSA4opJfE\/s72-c\/excel_change_column01_thumb.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-4616105112331914282"},"published":{"$t":"2008-11-14T01:10:00.001-08:00"},"updated":{"$t":"2008-11-14T01:10:29.512-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步]  【Ctrl】鍵在 Excel 中的妙用 ─ 以[區塊複製]取代[自動填滿]"},"summary":{"type":"text","$t":"一般來說，當我們同時選取兩個以上的相鄰儲存格，然後用滑鼠左鍵拖曳儲存格時，Excel 會依照[自訂清單]中的項目，幫我們自動填滿。  如下面的例子，當我們選取了一月、二月及三月的相鄰儲存格並往下拉時，Excel 會幫我們自動填滿［一月～十二月］。      如果我們只是純粹想要複製［一月～三月］的儲存格時，你會採取什麼方法呢？ 按 ［Ctrl］+[C] 複製，並按 [Ctrl]+[V] 貼上，如此重複。  其實我們有個更好了方法，就是用滑鼠來拖曳儲存格，請你按自動填滿的動作，但是按住 [Ctrl] 鍵，就可以把[自動填滿]，變成只有【區塊複製】，參考下圖的操作說明，如此就可以達到 [一月～三月］ 的儲存格重複複製的功效了，是不是簡單又方便呢？         這裡還有一些關於 [Ctrl] 鍵的一些特殊好用的功能     [Ctrl] + [C] 複製      [Ctrl] + [A]"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/4616105112331914282\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=4616105112331914282\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4616105112331914282"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4616105112331914282"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/11\/excel-ctrl-excel.html","title":"[Excel小撇步]  【Ctrl】鍵在 Excel 中的妙用 ─ 以[區塊複製]取代[自動填滿]"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh5.ggpht.com\/_R3506kYXSHI\/SR1AfFdD2gI\/AAAAAAAAAIY\/SFiecAdNDFw\/s72-c\/excel_drag04_thumb.gif?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-590280451738207361"},"published":{"$t":"2008-11-13T06:28:00.001-08:00"},"updated":{"$t":"2008-11-13T06:28:54.308-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] [複製格式]不需要重複按 ─ 持續多次「格式複製」"},"summary":{"type":"text","$t":" 這個方法可適用所有的 Excel、Word、PowerPoint。  當我們想要在 Excel 中「複製格式」時，通常就是把想要複製之格式的儲存格或範圍選取起來，然後在 [格式] 工具列上，按一下 [複製格式]的圖示 ，再選取想要將格式設定複製過去的儲存格或範圍。  如果有很多筆相同的格式要複製時，怎麼作？一個一個選取，按[複製格式]？其實有個好用的小撇步 ─ 繼續複製。  方法是，     選取具有想要複製之格式的儲存格或範圍。     在 [格式] 工具列上，連續按兩下 [複製格式]按鈕。這時游標會變成 的形狀。     可以一直選取想要將格式設定複製過去的儲存格或範圍直到完成。     當您完成格式的複製，請再按一下[複製格式]按鈕，或是按【ESC】鍵取消複製格式功能。      "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/590280451738207361\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=590280451738207361\u0026isPopup=true","title":"1 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/590280451738207361"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/590280451738207361"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/11\/excel.html","title":"[Excel小撇步] [複製格式]不需要重複按 ─ 持續多次「格式複製」"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh5.ggpht.com\/_R3506kYXSHI\/SRw5mZvXraI\/AAAAAAAAAIA\/ejd6l7TwBis\/s72-c\/format_painter-icon_thumb%5B5%5D.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"1"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-1364734148219704360"},"published":{"$t":"2008-10-30T05:40:00.001-07:00"},"updated":{"$t":"2008-10-30T05:41:23.372-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"財經知識"}],"title":{"type":"text","$t":"匯率之我見"},"summary":{"type":"text","$t":"一個國家的貨幣價值通常代表這個國家的經濟實力，如果以美金為基準時，當一國的美金匯率升值時，表示其經濟相對於美國經濟來得好；反之，則變差。這一點也可以反應在股票市場上，一般來說，當這個國家的股票市場大好時，匯率就會上升，因為有很多的外資及熱錢會湧入，就好像有很多人拿著美金要買台幣，如果台幣不夠，僧多粥少的情況下，就會有人出更高的價錢來買，所以台幣就會升值；反之，如果股票市場節節敗退時，匯率就會下降，就像這次的金融風暴，很多外資都抽離了新興亞洲地區，包括台灣，造成了亞洲的股票市場一敗塗地，也影響到大部分亞洲國家的貨幣匯率，台幣也從30元左右兌1美元的匯率掉到了33.5元左右，這兩天股票有點回穩了，匯率就昇回了32.8元左右。  所以有人會說，如果看準了一個國家的經濟向上時，就可以把錢換成當地的幣別，並投資在當地的股票市場，等時機成熟時，賣出股票，轉回自己的幣別，就可以股、匯雙賺。當然，有投資"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/1364734148219704360\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=1364734148219704360\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1364734148219704360"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1364734148219704360"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/10\/blog-post_30.html","title":"匯率之我見"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-1852801905125361731"},"published":{"$t":"2008-10-24T08:35:00.001-07:00"},"updated":{"$t":"2008-10-24T08:36:27.314-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"財經個人觀點"}],"title":{"type":"text","$t":"[財經個人觀點] 如果你是一間大集團的老闆?"},"summary":{"type":"text","$t":"有朋友問我『不景氣之下，公司經營越發困難，如果你是一位大集團公司的老闆，需要縮小公司規模已度過難關，你會優先選擇處理優良的子公司或是經營不善的子公司呢？』  一般人可能會覺得答案很簡單，應該優先處理經營不善的子公司吧！關掉不賺錢的子公司，剩下會賺錢的子公司，不就可以轉虧為盈了嗎。  問題要是這麼簡單，我們就不會在新聞的版面看到，某某大企業賣出金雞母了，如最近的ING要賣台灣的子公司，就是一例。那為何要賣掉金雞母的子公司呢？原因應該很簡單，這個集團缺少現金，只有賺錢的子公司有人願意買，而且比較可以賣得到好價錢；虧錢的子公司，不但可能沒人買，還可能需要拿錢出來給買家，幫忙處理爛攤子，如人事費用，或是欠款...等等，之前明碁買西門子的手機部門就是一例。  所以「如果你是一間大集團的老闆，你會如何處理呢？」，這要考慮這家集團是否急用資金，銀行是否願意借貸...等，才能下結論吧。還有資金時，當然"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/1852801905125361731\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=1852801905125361731\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1852801905125361731"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1852801905125361731"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/10\/blog-post.html","title":"[財經個人觀點] 如果你是一間大集團的老闆?"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-3741375669164219159"},"published":{"$t":"2008-10-11T21:44:00.001-07:00"},"updated":{"$t":"2008-10-11T21:44:18.314-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 中文排序(進階)"},"summary":{"type":"text","$t":"有沒有辦法讓Excel不要按照內碼的順序而按照國字一～九的順序來作排列呢？  答案是有的，但是要透過[自定清單]來達到。就以上面的問題『讓Excel按照國字一～九的順序來作排列』來作說明。  老實說，這個方法有點笨，但這是我到目前為止所知道的方法，有更好方法者，歡迎提供意見：  1. 首先要自己先把國字一～九的順序排好 (很笨吧!)，然後把國字一～九用滑鼠全部選起來，然後功能表的 [工具]\/[選項]。         2. 開啟 [選項]的對話框，選取 [自定清單] 的標籤，然後按 [匯入]按鈕。這時候會看到 [清單項目] 的框框裡出現了一～九的國字，而且 [自定清單] 的框框也會多出一組 一～九 的清單。按 [確定]按鈕關閉對話框。          3. 可以把剛剛事先排好的國字一～九刪除，開始進入我們的排序方法了。      選取要排序的資料，下面的資料選取儲存格 [A1]～["},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/3741375669164219159\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=3741375669164219159\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/3741375669164219159"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/3741375669164219159"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/10\/excel_4905.html","title":"[Excel小撇步] 中文排序(進階)"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh4.ggpht.com\/andrew.lu2000as\/SPGAghqUMZI\/AAAAAAAAAHY\/gONuXM4qnM0\/s72-c\/Excel_sort_define01%5B3%5D_thumb%5B1%5D.jpg","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-7126534847015988393"},"published":{"$t":"2008-10-11T20:32:00.001-07:00"},"updated":{"$t":"2008-10-11T21:45:36.779-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 中文排序的原理"},"summary":{"type":"text","$t":"有沒有想過Excel的中文是以什麼為順序排列出來的呢？  其實Excel是依照字的筆劃大小來作排序的，由最小的筆劃到最大的筆劃進行排序。如果筆劃相同，則依照內碼做排序，由最小的內碼到最大的內碼進行排序。說穿了，Excel就是依照中文字的內碼來進行排序的，當初排內碼順序時就是按照字的筆劃順序來排的。  (↓下面的例子是把國字一～九作由小到大的排序，結果可以看得出來完全是按照內碼來作排序。)         那有沒有辦法讓Excel按照國字一～九的順序來作排列呢？點這裡找答案         延伸閱讀：    [Excel小撇步] 中文排序(進階)  "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/7126534847015988393\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=7126534847015988393\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/7126534847015988393"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/7126534847015988393"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/10\/excel_11.html","title":"[Excel小撇步] 中文排序的原理"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh6.ggpht.com\/andrew.lu2000as\/SPFv2ZkTVmI\/AAAAAAAAAHQ\/uUjpGuqDx3Y\/s72-c\/Excel_sort_chinese_thumb.jpg","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-2944487176876446670"},"published":{"$t":"2008-10-10T07:02:00.001-07:00"},"updated":{"$t":"2008-10-10T07:43:14.873-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 簡單[轉置]直行資料變橫列"},"summary":{"type":"text","$t":"假設有一組如下圖的資料從儲存格[A1]到[A9]為直式排列：         想要將直行的資料變成橫列時，       1. 把所要轉置的資料用滑鼠選起來反白後按滑鼠右鍵。       2. 選擇 [複製]。       3. 將游標移到想要複製到的儲存格，假設要複製到儲存格[B1]。       4. 按滑鼠右鍵，點選[選擇性貼上]          5. 勾選[轉置]前面的框框打勾後並按[確定]。          6. 完成。資料已經變為橫行的資料了。           "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/2944487176876446670\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=2944487176876446670\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/2944487176876446670"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/2944487176876446670"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/10\/excel_10.html","title":"[Excel小撇步] 簡單[轉置]直行資料變橫列"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh3.ggpht.com\/andrew.lu2000as\/SO9gTbMKFRI\/AAAAAAAAAGw\/MyDZENyxk6k\/s72-c\/Excel_convert_row2column01_thumb%5B1%5D.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-9018811218376405334"},"published":{"$t":"2008-10-10T06:27:00.001-07:00"},"updated":{"$t":"2008-10-10T06:27:57.739-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 用NETWORKDAYS()計算工作天數"},"summary":{"type":"text","$t":"NETWORKDAYS (Start_date, End_date, Holidays)      Start_date 為代表起始日的日期序列       End_date為代表終止日的日期序列       Holidays 為從日曆上扣除之一個或多個連續日期的任意集合，如果不輸入時會自動扣除星期六及星期日。  請注意：如果找不到這項函數，請執行安裝程式以安裝 [分析工具箱] 。安裝 [分析工具箱] 之後，您必須使用 [工具] 功能表上的 [增益集] 指令來啟動。[工具]→[增益集(I)]→勾選[分析工具箱]按[確定]→執行安裝程式(可能會需要安裝光碟)            假設 [例假日] 為 2008-FEB-06~2008-FEB-11 及 2008-FEB-28。  公式如果包含上述的[例假日]，則實際的工作天數 = NETWORKDAYS(A2,B2,C2:C10) = "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/9018811218376405334\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=9018811218376405334\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/9018811218376405334"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/9018811218376405334"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/10\/excel-networkdays.html","title":"[Excel小撇步] 用NETWORKDAYS()計算工作天數"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh5.ggpht.com\/andrew.lu2000as\/SO9YPobfwQI\/AAAAAAAAAGg\/fUWBd0AayUo\/s72-c\/Excel_networkdays01_thumb%5B1%5D.jpg?imgmax=800","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-4964971885951494793"},"published":{"$t":"2008-10-09T01:33:00.001-07:00"},"updated":{"$t":"2008-10-09T07:15:45.472-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 同分同名次怎麼排 ─ 用Rank()"},"summary":{"type":"text","$t":"一般我們用Excel排名次時，大多是用【排序】的方法，但這種方法有一個小缺點，就是無法排出『同分同名次』的結果。那要如何做到『同分同名次』的結果呢？這時候就要使用函數 Rank()了。  (↓下圖是利用排序所完成的名次排名，排序的第一順位是[總計]，第二順位是[NB]，排出來的結果如下，總分相同，名次不同)   (↓這是用 Rank() 函數做出來的結果，總分相同，名次相同，記得要按 \u003CF4\u003E使用【絕對位址】)          Excel 對 Rank 的說明  傳回某數字在一串數字清單中的等級。數字的等級就是數字相對於清單中其它數值的大小。（如果你把這清單中的數字排序，則此數字的等級就是它所在的位置）。  語法  RANK(number,ref,order)  Number   是要知道等級的數字。  Ref   是一個數值陣列或數值參照位址，非數值將被忽略。  Order   是"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/4964971885951494793\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=4964971885951494793\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4964971885951494793"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4964971885951494793"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/10\/excel-rank.html","title":"[Excel小撇步] 同分同名次怎麼排 ─ 用Rank()"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh4.ggpht.com\/andrew.lu2000as\/SO3B3SjViAI\/AAAAAAAAAGQ\/FC2k2elXgZo\/s72-c\/Excel_rank01_thumb%5B1%5D.jpg","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-1331890375252603584"},"published":{"$t":"2008-10-06T18:35:00.001-07:00"},"updated":{"$t":"2008-11-14T05:40:34.989-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 快速切換【絕對位址】的方法 ─ 好用的 [F4] 按鍵"},"summary":{"type":"text","$t":"前一篇文章介紹過何謂「絕對位址」及「相對位址」，這裡在介紹一個好用的快速切換「絕對位址」的方法。  當儲存格的位址輸入後，把游標停在公式中要變成「絕對位址」的位置上，然後按下\u003CF4\u003E按鍵，就會從「相對位址」變為「絕對位址」，而且每按一次\u003CF4\u003E按鍵就會作一次變化，以下面的圖例來作說明，儲存格位址會從 [B12] → [$B$12]→ [B$12] → [$B12] → [B12] →...循環變化。  (↓把游標停放在要變更「相對位址」為「絕對位址」的儲存格上)     (↓按\u003CF4\u003E後儲存格公式從 [B12](相對位址) 變成 [$B$12] (絕對位址)           延伸閱讀：   Excel小撇步整理  "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/1331890375252603584\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=1331890375252603584\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1331890375252603584"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/1331890375252603584"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/10\/excel_06.html","title":"[Excel小撇步] 快速切換【絕對位址】的方法 ─ 好用的 [F4] 按鍵"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh6.ggpht.com\/andrew.lu2000as\/SOq8w6H4sgI\/AAAAAAAAAGA\/s_UbZyg8bx0\/s72-c\/Excel_absolute01_thumb.jpg","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-2713701442075335010"},"published":{"$t":"2008-10-06T06:26:00.001-07:00"},"updated":{"$t":"2008-10-06T18:41:57.112-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 了解【相對位址】及【絕對位址】"},"summary":{"type":"text","$t":"稍微熟悉 MS-Excel的朋友應該多知道，什麼是【絕對位址】？什麼是【相對位址】？哪你知道嗎？  就像小學生算數學一樣，某甲站在離火車站２公尺的地方，某乙站在離火車站５公尺的地方，那麼乙火車站為基準點，甲和乙的「絕對位置」方別為２公尺及５公尺，甲和乙距離３公尺就是「相對位置」，     MS-Excel 預設是位址是「相對位置」，如[A1]；那如果我們要用「絕對位置」只要在符號前面加上[$]，如[$A$1]表示行及列都使用「絕對位置」。當 MS-Excel 在作[複製][貼上]時，「相對位置」及「絕對位置」就顯得很重要了。  如果是「相對位置」，那麼[行]跟]列]的內容就會隨著儲存格的移動而移動，如果(圖二)及(圖三)中的[Ｂ]欄一樣，公式會從B1變到B9。  如果是「相對位置」，看[$]加在[欄]或者是[列]的前面，有[$]的就是「相對位置」，如圖中的[C]欄，[C$1]的位址，再"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/2713701442075335010\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=2713701442075335010\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/2713701442075335010"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/2713701442075335010"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/10\/excel.html","title":"[Excel小撇步] 了解【相對位址】及【絕對位址】"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh5.ggpht.com\/andrew.lu2000as\/SOoR2MGyoKI\/AAAAAAAAAFo\/FApSm_flPrA\/s72-c\/Excel_position_thumb.jpg","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-4834585940306455002"},"published":{"$t":"2008-09-30T08:24:00.001-07:00"},"updated":{"$t":"2008-10-06T18:42:31.146-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"Excel小撇步"}],"title":{"type":"text","$t":"[Excel小撇步] 快速調整【最適欄寬】的方法"},"summary":{"type":"text","$t":"調整Excel的【最適欄寬】除了開啟功能表的【格式】→【欄】→【最適欄寬】之外，還可以有下列的方法。  1. 先選取欲調整欄寬的儲存格。  2. 把滑鼠移到上端欄位的右邊緣，當出現  符號時，點兩下滑鼠的左鍵。          3. 完成後如下圖，已經自動將欄位調整成最適欄寬了。必須要注意的是，這個方法會對整欄做最適欄寬的調整。         (↓這是原來的最適欄寬的選取方法，【格式】→【欄】→【最適欄寬】)         延伸閱讀：  Excel小撇步整理  "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/4834585940306455002\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=4834585940306455002\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4834585940306455002"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4834585940306455002"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/09\/excel.html","title":"[Excel小撇步] 快速調整【最適欄寬】的方法"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh5.ggpht.com\/andrew.lu2000as\/SOJEe7cngqI\/AAAAAAAAAFI\/FeYxlTm6u-w\/s72-c\/Excel_coloum04_thumb.jpg","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-3123752994988023878"},"published":{"$t":"2008-09-26T02:46:00.001-07:00"},"updated":{"$t":"2008-09-26T02:46:04.136-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"股票"},{"scheme":"http://www.blogger.com/atom/ns#","term":"財經知識"}],"title":{"type":"text","$t":"[股票] 投資股票前的準備工作 (總整理)"},"summary":{"type":"text","$t":"所謂『危機入市』，台股從今年(5\/20)的最高點9309 一路下滑至今(9\/18)最低的5530，足足下跌了40%，跌幅不可謂不深。隨然不知道大盤是否已觸低，但相信離低點也不遠了。要投資股票前，，當然得先做功課，這裡整理了一些資料給準備進場的投資人，希望有個好的開始。  1. 資料收集：     現在是個資訊爆炸的時代，舉凡一般的報紙(經濟日報、工商時報)、財經雜誌(非凡週刊、今週刊，Money、智富、財訊、萬寶)、電視(非凡電視台、台視財經台、或是各名嘴老師電視台)...等。另外，還可以在網路上取得最新的資訊，如一些投資機構的研究報告、網路上的財經新聞 (Yahoo奇摩、番薯藤、中時新聞、聯合新聞)。    在台灣其實還有一些網站很值得投資朋友逛逛，如台灣證卷交易所的【公開資訊觀測站】、全球股市指數...等。    按這裡有更多財經網站的介紹   2. 技術分析     技術分析要先"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/3123752994988023878\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=3123752994988023878\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/3123752994988023878"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/3123752994988023878"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/09\/blog-post_26.html","title":"[股票] 投資股票前的準備工作 (總整理)"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh6.ggpht.com\/andrew.lu2000as\/SNyvWcJYAGI\/AAAAAAAAAE8\/KaPVuUZOYi4\/s72-c\/K_line_thumb.jpg","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-4749214761268927449"},"published":{"$t":"2008-09-17T09:22:00.001-07:00"},"updated":{"$t":"2009-04-05T20:36:26.426-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"股票"},{"scheme":"http://www.blogger.com/atom/ns#","term":"財經知識"}],"title":{"type":"text","$t":"[股票] 投資股票前的準備工作 I ─ 資訊取得"},"summary":{"type":"text","$t":"所謂『工欲善其事，必先利其器』，準備開始投資股票前，應該先了解現在的網路上，有那些網站提供有用的股票資訊，讓你可以不用總是聽老師說，而且這些網站都是免費的，如果覺得這些網站不錯的話，為了鼓勵這些網站繼續存在，可以幫忙點選網站中的廣告，增加其收入。  公開資訊觀測站      這是由『台灣證卷交易所』所經營的網站，資訊內容由各上市\/櫃公司自行上傳。內容包括 損益表、資產負債表、現金流量表、會計師查核報告、財務報告書、公開說明書、每月營收報表、股權轉讓資料查詢...等，可以說所有公開發行股票的公司營運資訊都可以從這裡取得。如前一篇的查詢「扣抵稅率\/扣抵稅率額」就是從這裡查詢的。很多基金的經理人也都會參考這裡的資訊。        公開資訊觀測站精華版      這是由『台灣證卷交易所』所經營的網站，顧名思義，就是公開資訊觀測站的精華版，因為公開資訊觀測站的資訊實在是太多了,有點讓人眼花撩亂的"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/4749214761268927449\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=4749214761268927449\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4749214761268927449"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/4749214761268927449"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/09\/i.html","title":"[股票] 投資股票前的準備工作 I ─ 資訊取得"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh5.ggpht.com\/andrew.lu2000as\/SNEukTdCvTI\/AAAAAAAAAEc\/xW66_PHJck8\/s72-c\/Newmops01_s_thumb%5B1%5D.jpg","height":"72","width":"72"},"thr$total":{"$t":"0"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-7693411304776121151"},"published":{"$t":"2008-09-13T01:26:00.001-07:00"},"updated":{"$t":"2008-09-13T02:17:15.917-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"股票"},{"scheme":"http://www.blogger.com/atom/ns#","term":"財經知識"}],"title":{"type":"text","$t":"[股票] 查詢「扣抵稅率\/扣抵稅率額」"},"summary":{"type":"text","$t":"常常在報章雜誌上看到「高殖利率」及「高扣抵稅率」，下面我門就來看看如何利用網路上的資源，來查詢到我們要的「扣抵稅率」資料。          1.所先進入「公開資訊觀測站」，開啟IE並鍵入底下網址 http:\/\/newmops.tse.com.tw\/ 。           2.先輸入欲查詢的公司代號並選擇「財務報告書」，再輸入欲查詢的「年度」。這裡以「合勤」為例：          3.選擇「第四季的財務報告書」的母子公司合併報表。          4.一般為PDF檔案，於搜尋欄輸入「扣抵」字根並開始搜尋。          5.找到「可扣抵稅額」並往下找到」「盈餘分配之稅額扣抵比率」，其右邊就會列出數字，有時候報告書裡只會用敘述的，上下文仔細找一下，一般 99% 都可找到。       "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/7693411304776121151\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=7693411304776121151\u0026isPopup=true","title":"3 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/7693411304776121151"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/7693411304776121151"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/09\/blog-post.html","title":"[股票] 查詢「扣抵稅率\/扣抵稅率額」"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"http:\/\/lh5.ggpht.com\/andrew.lu2000as\/SMuEgjDTejI\/AAAAAAAAADs\/NxLqyJOVHHs\/s72-c\/Stock-tax01s_thumb%5B1%5D.jpg","height":"72","width":"72"},"thr$total":{"$t":"3"}},{"id":{"$t":"tag:blogger.com,1999:blog-1696546084898555136.post-652040536089401171"},"published":{"$t":"2008-09-10T08:44:00.001-07:00"},"updated":{"$t":"2008-09-10T08:44:12.306-07:00"},"title":{"type":"text","$t":"[Temp.] 我的財經題目"},"summary":{"type":"text","$t":"   通膨問題     利率問題     油價 (100美元的油價)     匯率     石油及升值能源的開採成本     保值產品：土地、房子、黃金、及貴金屬    "},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/mymoneylook.blogspot.com\/feeds\/652040536089401171\/comments\/default","title":"張貼留言"},{"rel":"replies","type":"text/html","href":"http:\/\/www.blogger.com\/comment.g?blogID=1696546084898555136\u0026postID=652040536089401171\u0026isPopup=true","title":"0 個意見"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/652040536089401171"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/1696546084898555136\/posts\/default\/652040536089401171"},{"rel":"alternate","type":"text/html","href":"http:\/\/mymoneylook.blogspot.com\/2008\/09\/temp.html","title":"[Temp.] 我的財經題目"}],"author":[{"name":{"$t":"佑"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/17158336958573777972"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"32","height":"30","src":"http:\/\/3.bp.blogspot.com\/_R3506kYXSHI\/Sm0AlULKN3I\/AAAAAAAAAQ8\/r4G7ghh8PmY\/S220\/andrewlu2000as.jpg"}}],"thr$total":{"$t":"0"}}]}});