SQL-均線糾結+成交量大於5日均量3倍

select a.xDate , a.StockNo , b.Close_5MA ,c.Close_20MA , d.Close_55MA ,e.Volume_5MA, a.xVolume
from StockDailyHis2 as a
join Close_5MA as b on a.StockNo = b.StockNo and a.Date = b.Date
join Close_20MA as c on b.StockNo = c.StockNo and b.Date = c.Date
and ((cast(b.Close_5MA as float) / cast(c.Close_20MA as float) >=0.9)
or (cast(b.Close_5MA as float) / cast(c.Close_20MA as float) <=1.1))
join Close_55MA as d on b.StockNo = d.StockNo and b.Date = d.Date
and ((cast(b.Close_5MA as float) / cast(d.Close_55MA as float) >=0.9)
or (cast(b.Close_5MA as float) / cast(d.Close_55MA as float) <=1.1))

join Volume_5MA as e on a.StockNo = e.StockNo and a.Date = e.Date
and (cast(e.Volume_5MA as float) * 3 < cast(a.xVolume as float))

where a.xDate >= '20150101'
and cast(a.xVolume as float) > 1000
order by a.xDate , StockNo


紀錄: 9/11 跑出 2443,4526
過陣子再來看結果 XD

AVAST-Google Chrome 瀏覽器無法正常看到Yahoo首頁的圖片

Google Chrome 瀏覽器無法正常看到Yahoo首頁
經測試原來是 AVAST掃毒軟體在作怪

avast介面>>設定>>主動防護>>網頁防護>>自定>>取消勾選"啟用HTTPS掃描"

關閉瀏覽器再重新打開就正常囉

Python-如何利用Gmail發信

import smtplib
from email.MIMEMultipart import MIMEMultipart
from email.MIMEText import MIMEText

def sendGmailSmtp(strGmailUser,strGmailPassword,strRecipient,strSubject,strContent):
    strMessage = MIMEMultipart()
    strMessage['From'] = strGmailUser
    strMessage['To'] = strRecipient
    strMessage['Subject'] = strSubject
    strMessage.attach(MIMEText(strContent))
    mailServer = smtplib.SMTP('smtp.gmail.com', 587)
    mailServer.ehlo()
    mailServer.starttls()
    mailServer.ehlo()
    mailServer.login(strGmailUser, strGmailPassword)
    mailServer.sendmail(strGmailUser, strRecipient, strMessage.as_string())
    mailServer.close()
    return 'send successed'


print sendGmailSmtp('寄件人@gmail.com','Gmail應用程式密碼','收件人@gmail.com','subject','Gino Test')

Ps, 記得先至Gmail申請應用程式密碼，才能順利發信。

Python-字串處理語法

[Substring]

sTmp='2015-09-05'
sYY=sTmp[0:4]
sMM=sTmp[5:-3]
sDD=sTmp[8:]

---

[Trim]

左trim
info[0].lstrip()
右trim
info[0].rstrip()

---

[Replace]

tmpData = tmpData.replace('=','')
tmpData = tmpData.replace('\""','')
tmpData = tmpData.replace(' ','')

Stock-K線圖顏色含意

K線圖的紅黑K，取決於開盤與收盤價的高低

開盤價高於收盤價，開高走低，當日K線呈黑K
開盤價低於收盤價，開低走高，當日K限呈紅K
開盤至收盤上下震盪，收盤價與開盤價接近，產生上下影線,收十字線
開盤價高於收盤價，收黑十字線
開盤價低於收盤價，收紅十字線
開盤價收盤價持平，收黑十字線


成交量是紅棒綠棒，完全取決於收盤價是收漲收跌

收跌，成交量呈綠棒
收漲，成交量呈紅棒
收平，成交量呈白棒

ASP.NET - GridView流水號

參考位置:
http://blog.xuite.net/xiaolian/blog/46204394-%E5%9C%A8GridView%E4%B8%AD%E5%8A%A0%E5%85%A5%E8%87%AA%E5%8B%95%E7%B7%A8%E8%99%9F%E7%9A%84%E5%BA%8F%E8%99%9F
很實用的範例:

在Aspx檔案中GridView表格內插入一個欄位，在第一欄加上TemplateField的欄位，語法如下：

流水號從第一筆編起
  <asp:TemplateField HeaderText="序號">
          <ItemTemplate>
             <%#GridView1.PageIndex * GridView1.PageSize + GridView1.Rows.Count + 1%>
           </ItemTemplate>
           <HeaderStyle Wrap="False"  />
            <ItemStyle  HorizontalAlign="Center" VerticalAlign="Middle" />
  </asp:TemplateField>

OR

  <asp:TemplateField HeaderText="序號">
         <ItemTemplate>
            <%#Container.DataItemIndex + 1%>
         </ItemTemplate>
         <HeaderStyle Wrap="False"  />
         <ItemStyle  HorizontalAlign="Center" VerticalAlign="Middle" />
  </asp:TemplateField>


  流水號每頁從1編起
  <asp:TemplateField HeaderText="序號">
          <ItemTemplate>
             <%#Container.DisplayIndex + 1%>
           </ItemTemplate>
           <HeaderStyle Wrap="False"  />
           <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
  </asp:TemplateField>