<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="ko">
	<id>https://devcafe.co.kr/w/index.php?action=history&amp;feed=atom&amp;title=%EC%A3%BC%EC%8B%9D_rsi</id>
	<title>주식 rsi - 편집 역사</title>
	<link rel="self" type="application/atom+xml" href="https://devcafe.co.kr/w/index.php?action=history&amp;feed=atom&amp;title=%EC%A3%BC%EC%8B%9D_rsi"/>
	<link rel="alternate" type="text/html" href="https://devcafe.co.kr/w/index.php?title=%EC%A3%BC%EC%8B%9D_rsi&amp;action=history"/>
	<updated>2026-11-18T07:51:04Z</updated>
	<subtitle>이 문서의 편집 역사</subtitle>
	<generator>MediaWiki 1.42.1</generator>
	<entry>
		<id>https://devcafe.co.kr/w/index.php?title=%EC%A3%BC%EC%8B%9D_rsi&amp;diff=2849&amp;oldid=prev</id>
		<title>Devcafe: 개발노트 양식 일괄 적용</title>
		<link rel="alternate" type="text/html" href="https://devcafe.co.kr/w/index.php?title=%EC%A3%BC%EC%8B%9D_rsi&amp;diff=2849&amp;oldid=prev"/>
		<updated>2026-11-12T03:45:02Z</updated>

		<summary type="html">&lt;p&gt;개발노트 양식 일괄 적용&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;ko&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;← 이전 판&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;2026년 11월 12일 (목) 12:45 판&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l1&quot;&gt;1번째 줄:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;1번째 줄:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;{{개발노트&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;|요약=&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;|핵심=&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;|분야=Python&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;|작성일=2024-10-04&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;}}&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;source lang=python&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;source lang=python&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;import dbcon&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;import dbcon&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Devcafe</name></author>
	</entry>
	<entry>
		<id>https://devcafe.co.kr/w/index.php?title=%EC%A3%BC%EC%8B%9D_rsi&amp;diff=49&amp;oldid=prev</id>
		<title>Devcafe: 새 문서: &lt;source lang=python&gt; import dbcon import pymysql import datetime import UTIL_SLACK_CALL  db = dbcon.conn() cursor = db.cursor(pymysql.cursors.DictCursor)   def selectStockList(cursor):     selectSql = &quot;select ifnull(date_format(date_add(max(sr.date),interval +1 day),&#039;%Y%m%d&#039;)                  &quot;\                 &quot;               , date_format(date_add(curdate( ),interval -850 day),&#039;%Y%m%d&#039;))as start_date &quot;\                 &quot;    	,date_format((SELECT MAX(DATE) FROM tb_stock_daily_i...</title>
		<link rel="alternate" type="text/html" href="https://devcafe.co.kr/w/index.php?title=%EC%A3%BC%EC%8B%9D_rsi&amp;diff=49&amp;oldid=prev"/>
		<updated>2024-10-04T15:33:24Z</updated>

		<summary type="html">&lt;p&gt;새 문서: &amp;lt;source lang=python&amp;gt; import dbcon import pymysql import datetime import UTIL_SLACK_CALL  db = dbcon.conn() cursor = db.cursor(pymysql.cursors.DictCursor)   def selectStockList(cursor):     selectSql = &amp;quot;select ifnull(date_format(date_add(max(sr.date),interval +1 day),&amp;#039;%Y%m%d&amp;#039;)                  &amp;quot;\                 &amp;quot;               , date_format(date_add(curdate( ),interval -850 day),&amp;#039;%Y%m%d&amp;#039;))as start_date &amp;quot;\                 &amp;quot;    	,date_format((SELECT MAX(DATE) FROM tb_stock_daily_i...&lt;/p&gt;
&lt;p&gt;&lt;b&gt;새 문서&lt;/b&gt;&lt;/p&gt;&lt;div&gt;&amp;lt;source lang=python&amp;gt;&lt;br /&gt;
import dbcon&lt;br /&gt;
import pymysql&lt;br /&gt;
import datetime&lt;br /&gt;
import UTIL_SLACK_CALL&lt;br /&gt;
&lt;br /&gt;
db = dbcon.conn()&lt;br /&gt;
cursor = db.cursor(pymysql.cursors.DictCursor)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
def selectStockList(cursor):&lt;br /&gt;
    selectSql = &amp;quot;select ifnull(date_format(date_add(max(sr.date),interval +1 day),&amp;#039;%Y%m%d&amp;#039;)                  &amp;quot;\&lt;br /&gt;
                &amp;quot;               , date_format(date_add(curdate( ),interval -850 day),&amp;#039;%Y%m%d&amp;#039;))as start_date &amp;quot;\&lt;br /&gt;
                &amp;quot;    	,date_format((SELECT MAX(DATE) FROM tb_stock_daily_info), &amp;#039;%Y%m%d&amp;#039;) as end_date    &amp;quot;\&lt;br /&gt;
                &amp;quot;  from tb_stock_daily_result sr                                                             &amp;quot;&lt;br /&gt;
&lt;br /&gt;
    cursor.execute(selectSql)&lt;br /&gt;
    result = cursor.fetchall()&lt;br /&gt;
    return result&lt;br /&gt;
&lt;br /&gt;
#time.sleep(3600)&lt;br /&gt;
if __name__ == &amp;quot;__main__&amp;quot;:&lt;br /&gt;
&lt;br /&gt;
    for vStockList in selectStockList(cursor):&lt;br /&gt;
        now = datetime.datetime.now()&lt;br /&gt;
        if vStockList[&amp;#039;start_date&amp;#039;] &amp;lt;= vStockList[&amp;#039;end_date&amp;#039;]:&lt;br /&gt;
&lt;br /&gt;
            #입력파라미터 : 시작일자, 종료일자, 엔벨로퍼%(0.2 =&amp;gt; 20%)&lt;br /&gt;
            cursor.callproc(&amp;quot;sp_stock_daily_result&amp;quot;, (vStockList[&amp;#039;start_date&amp;#039;], vStockList[&amp;#039;end_date&amp;#039;], 0.2));&lt;br /&gt;
            print(vStockList[&amp;#039;start_date&amp;#039;], vStockList[&amp;#039;end_date&amp;#039;])&lt;br /&gt;
&lt;br /&gt;
    dbcon.close(db)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
UTIL_SLACK_CALL.send_slack(&amp;quot;STEP_03 - Finish .. Stock_Daily_Result&amp;quot;);&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
[[Category:python]]&lt;/div&gt;</summary>
		<author><name>Devcafe</name></author>
	</entry>
</feed>