快速瀏覽各公司月營收(Excel分享) - 股票

Megan avatar
By Megan
at 2016-08-09T23:47

Table of Contents


各位股神晚安，
小弟用Excel來抓取各公司每月營收，在這邊分享給需要的朋友們。

檔案連結如下:
https://goo.gl/xPUhVH


關於此Excel幾點說明:

1. 製作此簡式Excel動機在於，不用到處找新聞，一鍵即能查詢營收。

2. 此Excel所抓取的數據來自於公開資訊觀測站。

3. 使用方法有兩種:

A. 在上市Data及上櫃Data工作表下載營收資料後，
使用Ctrl+F來搜尋想知道的公司營收狀況。

B. 觀察名單工作表可以填入自己的觀察股or持股，當營收資料下載完成，
此觀察名單會抓取營收資料，並進行帶入的動作。


簡單的Excel分享，謝謝大家。

--

Sent From My Boeing 777-300ER

--
Tags: 股票

All Comments

Victoria avatar
By Victoria
at 2016-08-12T18:55
推 好心
Hazel avatar
By Hazel
at 2016-08-15T20:02
推
Erin avatar
By Erin
at 2016-08-16T15:55
感謝分享
Mary avatar
By Mary
at 2016-08-20T08:03
好心人幫推
Daniel avatar
By Daniel
at 2016-08-23T14:29
謝謝分享
Christine avatar
By Christine
at 2016-08-27T17:18
推分享
Elizabeth avatar
By Elizabeth
at 2016-09-01T11:08
感謝分享！
Audriana avatar
By Audriana
at 2016-09-04T12:07
謝謝分享
William avatar
By William
at 2016-09-07T22:20
感謝分享!!!
Emma avatar
By Emma
at 2016-09-10T20:52
讚！好心人
Hamiltion avatar
By Hamiltion
at 2016-09-12T09:09
拜...
Margaret avatar
By Margaret
at 2016-09-12T15:27
推好心
Gilbert avatar
By Gilbert
at 2016-09-13T02:03
感謝！
Dinah avatar
By Dinah
at 2016-09-14T13:48
感謝
Mason avatar
By Mason
at 2016-09-16T06:52
推好心人！
Kama avatar
By Kama
at 2016-09-17T16:42
謝謝
Andrew avatar
By Andrew
at 2016-09-22T10:29
推
Kama avatar
By Kama
at 2016-09-23T07:31
有下有推~
Delia avatar
By Delia
at 2016-09-27T12:43
溫馨實用感謝您
Jacob avatar
By Jacob
at 2016-10-01T02:32
感謝分享!
Anonymous avatar
By Anonymous
at 2016-10-01T20:10
有下有推 感謝
Jack avatar
By Jack
at 2016-10-06T06:15
推
Victoria avatar
By Victoria
at 2016-10-07T10:59
推
Genevieve avatar
By Genevieve
at 2016-10-09T22:19
好心 推推推
Bennie avatar
By Bennie
at 2016-10-14T19:07
請問 : "1. 先按Clean" 這個是甚麼意思呢? 謝謝
接下來的: "2. 填入年月" 要怎麼讓他執行呢? 謝謝
Candice avatar
By Candice
at 2016-10-16T12:34
好心必有好報!
Lydia avatar
By Lydia
at 2016-10-17T15:22
很實用 推~
Kyle avatar
By Kyle
at 2016-10-20T00:25
感謝分享
Joseph avatar
By Joseph
at 2016-10-22T14:13
推好心
Catherine avatar
By Catherine
at 2016-10-24T23:15
讚喔～
Eden avatar
By Eden
at 2016-10-29T06:15
我以前也整理過這種東西~
Enid avatar
By Enid
at 2016-11-01T20:31
fj 現在呢？..
Susan avatar
By Susan
at 2016-11-01T21:57
推
Queena avatar
By Queena
at 2016-11-05T12:37
謝謝分享!
Genevieve avatar
By Genevieve
at 2016-11-09T21:55
推 謝分享
Jacky avatar
By Jacky
at 2016-11-12T01:46
人也太好 謝謝你
Madame avatar
By Madame
at 2016-11-15T11:09
感謝～～～～
Agatha avatar
By Agatha
at 2016-11-19T10:41
謝謝分享！
Carolina Franco avatar
By Carolina Franco
at 2016-11-19T14:49
感謝
Carolina Franco avatar
By Carolina Franco
at 2016-11-21T12:40
ㄒㄒㄈㄒ
謝謝分享
Wallis avatar
By Wallis
at 2016-11-23T20:15
感謝!
Selena avatar
By Selena
at 2016-11-23T21:57
感謝分享阿
Quintina avatar
By Quintina
at 2016-11-25T04:14
好人
James avatar
By James
at 2016-11-25T12:38
謝謝你～
Callum avatar
By Callum
at 2016-11-26T09:45
謝謝
Sandy avatar
By Sandy
at 2016-11-30T19:59
感謝分享！
Mia avatar
By Mia
at 2016-12-03T01:55
推分享
Valerie avatar
By Valerie
at 2016-12-04T19:19
推一下
Rosalind avatar
By Rosalind
at 2016-12-07T18:37
推大大好心人~~
Jake avatar
By Jake
at 2016-12-09T13:25
推，謝謝
Elvira avatar
By Elvira
at 2016-12-10T14:27
謝
Genevieve avatar
By Genevieve
at 2016-12-14T19:16
推熱心，謝謝。
Belly avatar
By Belly
at 2016-12-16T12:20
P謝大大無私分享
Connor avatar
By Connor
at 2016-12-19T12:50
有下有推，謝謝泥!
Kumar avatar
By Kumar
at 2016-12-20T07:11
推
Jack avatar
By Jack
at 2016-12-22T14:48
推
Anonymous avatar
By Anonymous
at 2016-12-26T09:00
感謝
Emma avatar
By Emma
at 2016-12-30T19:25
推好心人
Selena avatar
By Selena
at 2017-01-04T10:46
哇 等等下 先推
Daniel avatar
By Daniel
at 2017-01-09T07:13
好心人感謝！！！
Ursula avatar
By Ursula
at 2017-01-10T16:47
推好心腸
Isla avatar
By Isla
at 2017-01-13T22:30
推!
Anthony avatar
By Anthony
at 2017-01-18T04:48
讚
Yuri avatar
By Yuri
at 2017-01-19T19:47
推
Ursula avatar
By Ursula
at 2017-01-22T14:28
謝謝分享
Hedy avatar
By Hedy
at 2017-01-23T22:08
推好心人!!!
Mary avatar
By Mary
at 2017-01-24T03:45
感謝分享
Emily avatar
By Emily
at 2017-01-27T16:35
推
Agnes avatar
By Agnes
at 2017-01-28T22:48
推
Megan avatar
By Megan
at 2017-01-29T13:36
網路上有資料庫阿 只要點幾下不就都有了...
Steve avatar
By Steve
at 2017-01-30T08:46
感謝分享，正想寫一個類似功能的
Ursula avatar
By Ursula
at 2017-01-30T14:56
謝謝分享！
Olga avatar
By Olga
at 2017-01-30T19:32
推太棒了
Liam avatar
By Liam
at 2017-02-02T00:54
推
Edwina avatar
By Edwina
at 2017-02-05T00:45
謝謝分享
William avatar
By William
at 2017-02-07T04:41
推好心
Delia avatar
By Delia
at 2017-02-11T13:17
感謝分享
Isla avatar
By Isla
at 2017-02-11T16:13
你是好人，你全家都好人!
Franklin avatar
By Franklin
at 2017-02-15T07:35
推
Rae avatar
By Rae
at 2017-02-18T01:46
好心人
Damian avatar
By Damian
at 2017-02-19T20:22
感謝分享
Sandy avatar
By Sandy
at 2017-02-23T17:46
有下有推
Daniel avatar
By Daniel
at 2017-02-27T07:16
謝謝
Elvira avatar
By Elvira
at 2017-02-27T20:18
感謝分享
Sierra Rose avatar
By Sierra Rose
at 2017-03-02T03:19
Good Job
Todd Johnson avatar
By Todd Johnson
at 2017-03-02T16:47
有下有推
Emma avatar
By Emma
at 2017-03-03T07:21
感謝分享，好久沒看到這麼好的好人惹~~~
Ivy avatar
By Ivy
at 2017-03-06T05:59
推好心人
Oscar avatar
By Oscar
at 2017-03-10T06:43
推
Anonymous avatar
By Anonymous
at 2017-03-14T22:36
有下有推~
Charlie avatar
By Charlie
at 2017-03-16T11:32
感謝!!
Frederica avatar
By Frederica
at 2017-03-17T16:27
推~~~~~~~~~~~~~~~~~~~
Zenobia avatar
By Zenobia
at 2017-03-20T19:03
堆!!!!!!!!!!!!!!
Mia avatar
By Mia
at 2017-03-21T06:05
推..感謝分享
Damian avatar
By Damian
at 2017-03-23T02:44
感謝大大分享
Necoo avatar
By Necoo
at 2017-03-27T22:12
推
Damian avatar
By Damian
at 2017-03-30T05:27
感謝分享
Gilbert avatar
By Gilbert
at 2017-04-02T05:37
感謝分享
Jake avatar
By Jake
at 2017-04-07T04:33
有下有推 感謝
Iris avatar
By Iris
at 2017-04-08T19:58
推，好人

漫談QE

Sandy avatar
By Sandy
at 2016-08-08T10:27
2008年金融海嘯以來，各大國都靠印鈔來救經濟(QE政策)。經過多年鬼畜變態的瘋狂印鈔 後，主要國家貨幣發行量都變態多。 資本主義陣營中，貨幣發行量市值的前三名是「美日歐」，在瘋狂印鈔後，現在美日歐的 貨幣發行量各大約值3兆美元~4兆美元。 (2008年4月金融海嘯前，美元發行量大約8570億美元， ...

怎麼用EXCEL抓每日資料？

Emily avatar
By Emily
at 2016-07-28T04:10
只要網路上有的資料都可以抓(期交所、證交所...) 可以製作自己專屬的籌碼應用分析 更進階的當然可以用來做程式交易 附上簡單應用的範例： 大盤籌碼變化：http://i.imgur.com/zAJB1Gx.png 月選未平倉變化http://i.imgur.com/OlK3e8X.png 週選未平倉變化ht ...

利用公開說明書的運氣

Carolina Franco avatar
By Carolina Franco
at 2016-07-25T22:49
原文恕刪 我個人寫過兩間公司的公開說明書，我只能說真的很恐怖，可能我都沒遇到正直善良的好 老闆。裡面的東西讓我自己寫完晚上會睡不著。 公開說明書是個非常神奇的東西，每個投資人都如果要買該公司的股票，都會非常認真研 究，但是如果是公司內部資訊人，通常只在乎是否合規跟怎樣可以完成上市即可，對許多 公司來說只要 ...

公開收購的解說

Adele avatar
By Adele
at 2016-07-25T15:19
目前至少有四、五個人站內信問我公開收購的事情 我看我還是把一些常常會被問的答案寫出來好了 讓許多新手日後也能夠爬文找到這樣的資料 1.公開收購是什麼? 公開收購就是其他公司要把這一間被收購的公司收購下來 基本上會是以高於盤面上的股價收購該公司發行的股票 2.為什麼要花更多的錢來收購? 收購如果成功之後 將 ...

Stock發文門檻調整

Kyle avatar
By Kyle
at 2016-07-24T21:59
※ [本文轉錄自 Law-Service 看板 #1NbCbvXh ] 作者: IanLi (IanLi) 看板: Law-Service 標題: Fw: [申請] Stock發文門檻調整 時間: Sun Jul 24 21:58:16 2016 ※ [本文轉錄自 AboutBoards 看板 #1NaZ ...