Spreadsheet¶

Make a spreadsheet using pinkfish.  This is useful for developing trading strategies.
It can also be used as a tool for buy and sell signals that you then manually execute.
In [1]:
import datetime

import matplotlib.pyplot as plt
import pandas as pd

from talib.abstract import *

import pinkfish as pf
import pinkfish.itable as itable

# Format price data
pd.options.display.float_format = '{:0.2f}'.format

%matplotlib inline
In [2]:
# Set size of inline plots
'''note: rcParams can't be in same cell as import matplotlib
   or %matplotlib inline
   
   %matplotlib notebook: will lead to interactive plots embedded within
   the notebook, you can zoom and resize the figure
   
   %matplotlib inline: only draw static images in the notebook
'''
plt.rcParams["figure.figsize"] = (10, 7)

Some global data

In [3]:
symbol = 'SPY'
start = datetime.datetime(1900, 1, 1)
end = datetime.datetime.now()

Fetch symbol data from internet; do not use local cache.

In [4]:
ts = pf.fetch_timeseries(symbol, use_cache=False)
ts.tail()
Out[4]:
open high low close adj_close volume
date
2023-12-21 471.33 472.98 468.84 472.70 472.70 86667500
2023-12-22 473.86 475.38 471.70 473.65 473.65 67126600
2023-12-26 474.07 476.58 473.99 475.65 475.65 55387000
2023-12-27 475.44 476.66 474.89 476.51 476.51 68000300
2023-12-28 476.88 477.55 476.26 476.69 476.69 77106300

Select timeseries between start and end. Back adjust prices relative to adj_close for dividends and splits.

In [5]:
ts = pf.select_tradeperiod(ts, start, end, use_adj=False)
ts.head()
Out[5]:
open high low close adj_close volume
date
1993-01-29 43.97 43.97 43.75 43.94 24.84 1003200
1993-02-01 43.97 44.25 43.97 44.25 25.02 480500
1993-02-02 44.22 44.38 44.12 44.34 25.07 201300
1993-02-03 44.41 44.84 44.38 44.81 25.34 529400
1993-02-04 44.97 45.09 44.47 45.00 25.44 531500

Add technical indicators

In [6]:
# Add 200 day MA.
ts['sma200'] = pf.SMA(ts, timeperiod=200)

# Add ATR.
ts['atr'] = ATR(ts, timeperiod=14)

# Add 5 day high, and 5 day low
ts['high5'] = pd.Series(ts.high).rolling(window=5).max()
ts['low5'] = pd.Series(ts.low).rolling(window=5).min()

# Add RSI, and 2-period cumulative RSI
ts['rsi2'] = RSI(ts, timeperiod=2)
ts['c2rsi2'] = pd.Series(ts.rsi2).rolling(window=2).sum()

# Add midpoint
ts['mp'] = (ts.high + ts.low) / 2

# Add 10 day SMA of midpoint
ts['sma10'] = pd.Series(ts.mp).rolling(window=10).mean()

# Add temporary rolling 10 day Standard Deviation of midpoint
ts['__sd__'] = pd.Series(ts.mp).rolling(window=10).std()

# Add standard deviation envelope or channel around midpoint
ts['upper'] = ts.sma10 + ts['__sd__']*2
ts['lower'] = ts.sma10 - ts['__sd__']*2

# Drop temporary columns.
ts.drop(columns=['__sd__'], inplace=True)

Finalize timeseries

In [7]:
ts, start = pf.finalize_timeseries(ts, start, dropna=True)
ts.tail()
Out[7]:
open high low close adj_close volume sma200 atr high5 low5 rsi2 c2rsi2 mp sma10 upper lower
date
2023-12-21 471.33 472.98 468.84 472.70 472.70 86667500 432.19 4.33 475.90 467.43 62.09 88.26 470.91 467.81 478.24 457.37
2023-12-22 473.86 475.38 471.70 473.65 473.65 67126600 432.60 4.28 475.90 467.82 68.63 130.72 473.54 469.26 478.18 460.35
2023-12-26 474.07 476.58 473.99 475.65 475.65 55387000 433.05 4.19 476.58 467.82 81.82 150.45 475.28 470.71 478.10 463.33
2023-12-27 475.44 476.66 474.89 476.51 476.51 68000300 433.50 4.01 476.66 467.82 86.65 168.47 475.78 472.05 477.27 466.82
2023-12-28 476.88 477.55 476.26 476.69 476.69 77106300 433.93 3.82 477.55 468.84 87.98 174.63 476.90 473.00 477.93 468.06

Select a smaller time from for use with itable

In [8]:
df = ts['2023-01-01':]
df.head()
Out[8]:
open high low close adj_close volume sma200 atr high5 low5 rsi2 c2rsi2 mp sma10 upper lower
date
2023-01-03 384.37 386.43 377.83 380.82 375.12 74850700 399.62 6.96 386.43 376.42 38.39 96.67 382.13 381.28 384.29 378.27
2023-01-04 383.18 385.88 380.00 383.76 378.01 85934100 399.31 6.88 386.43 376.42 72.58 110.96 382.94 381.47 384.65 378.29
2023-01-05 381.72 381.84 378.76 379.38 373.70 76970500 398.99 6.75 386.43 377.83 27.35 99.93 380.30 381.50 384.63 378.37
2023-01-06 382.61 389.25 379.41 388.08 382.27 104189600 398.68 6.97 389.25 377.83 79.10 106.45 384.33 381.43 384.21 378.65
2023-01-09 390.37 393.70 387.67 387.86 382.05 73978100 398.40 6.90 393.70 377.83 76.35 155.44 390.69 382.45 388.83 376.06

Use itable to format the spreadsheet. New 5 day high has blue highlight; new 5 day low has red highlight.

In [11]:
pt = itable.PrettyTable(
    df, tstyle=itable.TableStyle(theme='theme1'), header_row=True, rpt_header=20)

# pt = itable.PrettyTable(
#      df, tstyle=itable.TableStyle(theme='theme1'), header_row=True, rpt_header=20)

pt.update_col_header_style(
    format_function=lambda x: x.upper(), text_align='right')
pt.update_row_header_style(
    format_function=lambda x: pd.to_datetime(str(x)).strftime('%Y/%m/%d'), text_align='right')

for col in range(pt.num_cols):
    if pt.df.columns[col] == 'volume':
        pt.update_cell_style(cols=[col], format_function=lambda x: format(x, '.0f'), text_align='right')
    else:
        pt.update_cell_style(cols=[col], format_function=lambda x: format(x, '.2f'), text_align='right')

for row in range(pt.num_rows):
    if row == 0:
        continue
    if (pt.df['high5'].iloc[row] == pt.df['high'].iloc[row]) and \
       (pt.df['high5'].iloc[row] > pt.df['high'].iloc[row-1]):
        col = df.columns.get_loc('high5')    
        pt.update_cell_style(rows=[row], cols=[col], color='blue')
    if (pt.df['low5'].iloc[row] == pt.df['low'].iloc[row]) and \
       (pt.df['low5'].iloc[row] < pt.df['low'].iloc[row-1]):
        col = df.columns.get_loc('low5')
        pt.update_cell_style(rows=[row], cols=[col], color='maroon')          
In [12]:
pt
Out[12]:
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/01/03384.37386.43377.83380.82375.1274850700399.626.96386.43376.4238.3996.67382.13381.28384.29378.27
2023/01/04383.18385.88380.00383.76378.0185934100399.316.88386.43376.4272.58110.96382.94381.47384.65378.29
2023/01/05381.72381.84378.76379.38373.7076970500398.996.75386.43377.8327.3599.93380.30381.50384.63378.37
2023/01/06382.61389.25379.41388.08382.27104189600398.686.97389.25377.8379.10106.45384.33381.43384.21378.65
2023/01/09390.37393.70387.67387.86382.0573978100398.406.90393.70377.8376.35155.44390.69382.45388.83376.06
2023/01/10387.25390.65386.27390.58384.7365358100398.106.72393.70378.7687.28163.63388.46383.24390.48375.99
2023/01/11392.23395.60391.38395.52389.6068881100397.826.60395.60378.7695.25182.53393.49384.45394.00374.89
2023/01/12396.67398.49392.42396.96391.0290157700397.526.56398.49379.4196.52191.78395.46386.00397.19374.81
2023/01/13393.62399.10393.34398.50392.5363903900397.216.51399.10386.2797.79194.31396.22387.45399.86375.04
2023/01/17398.48400.23397.06397.77391.8162677300396.906.27400.23386.2772.70170.49398.65389.27402.45376.09
2023/01/18399.01400.12391.28391.49385.6399632300396.606.45400.23391.2813.4386.13395.70390.62403.32377.92
2023/01/19389.36391.08387.26388.64382.8286958900396.286.29400.23387.267.7221.14389.17391.25402.83379.66
2023/01/20390.10396.04388.38395.88389.9591806400395.976.39400.23387.2670.8078.52392.21392.44401.10383.77
2023/01/23396.72402.65395.72400.63394.6384178800395.726.43402.65387.2684.61155.41399.18393.92401.43386.41
2023/01/24398.88401.15397.64400.20394.2159524900395.496.22402.65387.2677.94162.55399.40394.79402.64386.94
2023/01/25395.95400.70393.56400.35394.3684800300395.256.29402.65387.2679.09157.02397.13395.66402.21389.11
2023/01/26403.13404.92400.03404.75398.6972287400395.046.19404.92388.3894.85173.94402.48396.56404.17388.95
2023/01/27403.66408.16403.44405.68399.6168346200394.866.08408.16393.5696.09190.94405.80397.59407.11388.08
2023/01/30402.80405.13400.28400.59394.5974202000394.686.03408.16393.5626.36122.46402.71398.24408.21388.27
2023/01/31401.13406.53400.77406.48400.3986811800394.496.03408.16393.5672.5298.88403.65398.74409.29388.19
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/02/01405.21413.67402.35410.80404.65101459200394.366.40413.67400.0385.68158.20408.01399.97411.74388.20
2023/02/02414.86418.31412.88416.78410.54101654500394.256.48418.31400.2893.84179.53415.60402.62415.43389.80
2023/02/03411.59416.97411.09412.35406.1894736800394.096.44418.31400.2850.87144.72414.03404.80417.16392.44
2023/02/06409.79411.29408.10409.83403.6960295300393.916.28418.31400.7733.4584.32409.70405.85417.87393.83
2023/02/07408.87416.49407.57415.19408.9790990700393.806.47418.31402.3572.91106.36412.03407.11418.77395.45
2023/02/08413.13414.53409.93410.65404.5076227500393.726.39418.31407.5736.37109.29412.23408.62418.27398.97
2023/02/09414.41414.57405.81407.09401.0078694900393.616.56416.97405.8120.3756.74410.19409.39418.04400.75
2023/02/10405.86408.44405.01408.04401.9370769700393.576.33416.49405.0135.5155.88406.73409.49417.98400.99
2023/02/13408.72412.97408.24412.83406.6564913500393.556.23416.49405.0177.90113.41410.60410.28417.31403.24
2023/02/14411.24415.05408.51412.64406.4688389300393.486.25415.05405.0174.04151.94411.78411.09416.39405.79
2023/02/15410.35414.06409.47413.98407.7861555700393.496.13415.05405.0184.72158.76411.76411.46416.30406.63
2023/02/16408.79412.91408.14408.28402.1776431500393.456.11415.05405.0118.83103.55410.53410.96414.84407.07
2023/02/17406.06407.51404.05407.26401.1689257800393.415.98415.05404.0514.7333.55405.78410.13414.58405.68
2023/02/21403.06404.16398.82399.09393.1282655900393.266.16415.05398.823.2818.01401.49409.31416.38402.25
2023/02/22399.52401.13397.02398.54392.5783742300393.186.01414.06397.022.976.25399.07408.02417.28398.76
2023/02/23401.56402.20396.25400.66394.6696242400393.136.00412.91396.2543.9246.89399.23406.72416.95396.48
2023/02/24395.42397.25393.64396.38390.45108194400393.126.08407.51393.6416.2460.16395.45405.24417.33393.15
2023/02/27399.87401.29396.75397.73391.7880444700393.115.99404.16393.6440.0756.31399.02404.47417.11391.83
2023/02/28397.23399.28396.15396.26390.3396438600393.135.79402.20393.6424.7464.81397.71403.18415.67390.70
2023/03/01395.41396.69393.38394.74388.8399706800393.145.61402.20393.3813.8138.55395.04401.51413.34389.67
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/03/02392.68398.69392.33397.81391.8585127800393.125.67401.29392.3369.0482.86395.51399.88409.76390.01
2023/03/03399.71404.45399.03404.19398.1490120000393.145.74404.45392.3391.55160.59401.74399.00405.73392.27
2023/03/06405.05407.45404.01404.47398.4172795900393.125.57407.45392.3392.06183.61405.73399.00405.71392.29
2023/03/07404.42404.67397.63398.27392.31108310600393.165.68407.45392.3325.18117.23401.15398.96405.62392.31
2023/03/08398.39399.71396.59398.92392.9574746600393.205.49407.45392.3335.0760.24398.15398.87405.55392.20
2023/03/09399.74401.48390.53391.56385.70111945300393.215.88407.45390.538.7843.85396.01398.55405.46391.64
2023/03/10390.99393.16384.32385.91380.13189253000393.166.09407.45384.324.0812.86388.74397.88407.05388.71
2023/03/13381.81390.39380.65385.36379.59157790000393.126.35404.67380.653.707.78385.52396.53408.50384.56
2023/03/14390.50393.45387.05391.73385.87149752400393.096.48401.48380.6569.7773.46390.25395.78408.35383.22
2023/03/15385.89389.49383.71389.28383.45172996900393.016.59401.48380.6545.67115.43386.60394.94408.79381.09
2023/03/16386.82396.47386.29396.11390.18143254200392.916.85396.47380.6581.43127.10391.38394.53408.55380.50
2023/03/17393.22394.40388.55389.99385.62140553400392.806.90396.47380.6537.36118.79391.47393.50406.65380.35
2023/03/20390.80394.17390.07393.74389.3393055800392.726.70396.47383.7162.3499.70392.12392.14402.09382.19
2023/03/21397.24399.41395.58398.91394.4491524200392.636.63399.41383.7182.06144.40397.49391.77400.44383.11
2023/03/22398.73402.49392.07392.11387.71111746600392.536.90402.49386.2934.51116.58397.28391.69400.08383.29
2023/03/23395.09399.29390.35393.17388.76119351300392.447.05402.49388.5544.5379.05394.82391.57399.72383.41
2023/03/24391.84395.84389.40395.75391.31107682400392.347.00402.49389.4068.21112.74392.62391.96399.88384.03
2023/03/27398.12398.92395.56396.49392.0474010400392.276.74402.49389.4074.46142.67397.24393.13400.25386.01
2023/03/28395.77396.49393.69395.60391.1662871700392.246.46402.49389.4050.55125.01395.09393.61400.52386.71
2023/03/29399.93401.60398.68401.35396.8577497900392.306.43401.60389.4090.40140.95400.14394.97401.02388.92
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/03/30404.09404.35401.76403.70399.1769840000392.446.18404.35389.4094.21184.61403.06396.13403.48388.79
2023/03/31404.66409.70404.55409.39404.80112062600392.626.17409.70393.6998.02192.23407.13397.70407.03388.37
2023/04/03408.85411.37408.44410.95406.3467391100392.785.94411.37393.6998.54196.56409.90399.48410.68388.28
2023/04/04411.62411.92407.24408.67404.0966601500392.995.85411.92398.6855.52154.06409.58400.69413.43387.94
2023/04/05407.91408.70405.88407.60403.0365200200393.195.63411.92401.7639.3894.90407.29401.69414.81388.56
2023/04/06406.77409.48405.68409.19404.6063743300393.365.50411.92404.5567.48106.86407.58402.96415.59390.33
2023/04/10406.61409.69405.97409.61405.0263681000393.545.37411.92405.6873.87141.35407.83404.48415.08393.89
2023/04/11410.26411.18408.92409.72405.1359297900393.705.15411.92405.6876.31150.19410.05405.76415.53396.00
2023/04/12411.87412.17407.44408.05403.4886420400393.795.12412.17405.6819.8996.21409.81407.24413.75400.72
2023/04/13409.18413.84407.99413.47408.8385814800393.915.17413.84405.6886.19106.08410.91408.31412.89403.74
2023/04/14412.81415.09410.06412.46407.8478161500394.075.16415.09405.9765.87152.06412.57409.27412.82405.71
2023/04/17412.37413.96411.09413.94409.3066436400394.245.00415.09407.4479.81145.68412.52409.81413.55406.06
2023/04/18415.58415.72412.78414.21409.5763560000394.434.85415.72407.4482.43162.25414.25410.24414.93405.55
2023/04/19412.22415.08412.16414.14409.5055227300394.594.71415.72407.9977.24159.67413.62410.64415.76405.53
2023/04/20411.21413.70410.27411.88407.2675840400394.744.65415.72410.0615.2392.47411.99411.11415.69406.54
2023/04/21412.19412.68410.17412.20407.5873457400394.884.50415.72410.1730.9446.17411.43411.50415.34407.65
2023/04/24411.99413.07410.60412.63408.0064332100395.004.36415.72410.1753.8984.82411.84411.90414.75409.04
2023/04/25410.58411.16406.02406.08401.5397766700395.094.52415.08406.024.8458.73408.59411.75415.13408.38
2023/04/26406.72407.84403.78404.36399.8380447000395.194.48413.70403.783.288.12405.81411.35416.32406.38
2023/04/27407.00412.69406.74412.41407.7992968400395.354.76413.07403.7875.9879.26409.71411.23416.31406.16
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/04/28411.49415.94411.43415.93411.2789335600395.534.74415.94403.7885.51161.49413.68411.34416.59406.09
2023/05/01415.47417.62415.27415.51410.8562122300395.724.57417.62403.7878.12163.62416.44411.74417.89405.59
2023/05/02414.77414.82407.82410.84406.23103998500395.854.79417.62403.7826.73104.84411.32411.44417.33405.55
2023/05/03411.36413.87407.77408.02403.4591531800395.984.89417.62406.7414.8941.62410.82411.16416.86405.47
2023/05/04406.93407.27403.74405.13400.5994901900396.044.84417.62403.747.8122.70405.50410.51417.19403.84
2023/05/05408.91413.72408.64412.63408.0087844000396.135.11417.62403.7473.4381.23411.18410.49417.15403.83
2023/05/08412.97413.24411.28412.74408.1150046800396.204.89414.82403.7473.97147.40412.26410.53417.23403.83
2023/05/09411.13412.09410.69410.93406.3249220100396.284.68413.87403.7444.21118.18411.39410.81417.39404.24
2023/05/10413.88414.54408.87412.85408.2296142900396.374.75414.54403.7469.90114.11411.71411.40416.96405.85
2023/05/11411.95412.43409.97412.13407.5170157100396.484.62414.54408.6451.96121.86411.20411.55416.99406.12
2023/05/12413.42413.64409.07411.59406.9870439400396.534.62414.54408.8737.5189.47411.36411.32416.54406.09
2023/05/15412.22413.43410.23413.01408.3854289400396.564.52414.54408.8774.62112.13411.83410.86414.70407.01
2023/05/16411.86412.82410.24410.25405.6557705500396.554.39414.54408.8722.5597.18411.53410.88414.74407.02
2023/05/17412.35415.86410.64415.23410.5787287000396.584.48415.86409.0777.99100.54413.25411.12415.26406.98
2023/05/18414.90419.67414.67419.23414.5397177200396.634.51419.67409.0789.76167.75417.17412.29415.94408.64
2023/05/19420.17420.72417.35418.62413.93103679700396.654.43420.72410.2377.17166.93419.04413.07418.57407.57
2023/05/22418.64420.39417.35418.79414.0960745400396.684.33420.72410.2478.83156.00418.87413.73420.29407.18
2023/05/23417.08418.72413.68414.09409.4586383500396.684.39420.72410.6415.7494.56416.20414.21420.71407.72
2023/05/24412.42412.82409.88411.09406.4889213700396.674.38420.72409.887.7823.52411.35414.18420.74407.62
2023/05/25414.74416.16412.41414.65410.0090961600396.694.43420.72409.8858.0765.86414.29414.49420.71408.27
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/05/26415.33420.77415.25420.02415.3193830000396.694.55420.77409.8884.15142.22418.01415.15421.31409.00
2023/05/30422.03422.58418.74420.18415.4772216000396.694.50422.58409.8884.72168.87420.66416.04422.59409.48
2023/05/31418.28419.22416.22417.85413.17110811800396.644.46422.58409.8841.51126.23417.72416.66422.44410.87
2023/06/01418.09422.92416.79421.82417.0988865000396.614.58422.92412.4178.64120.15419.86417.32422.88411.75
2023/06/02424.50428.74423.95427.92423.1291366700396.604.74428.74415.2592.76171.40426.35418.23426.20410.27
2023/06/05428.28429.62426.37427.10422.3165460200396.604.64429.62416.2278.76171.52427.99419.13429.23409.03
2023/06/06426.67428.58425.99428.03423.2364022200396.604.49429.62416.2284.18162.94427.28419.97431.30408.64
2023/06/07428.44429.62426.11426.55421.7785373300396.624.42429.62416.7946.46130.64427.86421.14433.12409.15
2023/06/08426.62429.60425.82429.13424.3261952800396.704.38429.62423.9579.10125.57427.71422.77433.19412.36
2023/06/09429.96431.99428.87429.90425.0885742800396.794.29431.99425.8284.68163.78430.43424.39433.92414.86
2023/06/12430.92433.88430.17433.80428.9476104300396.894.26433.88425.8295.86180.54432.03425.79435.28416.30
2023/06/13435.32437.33434.63436.66431.7695899700396.984.21437.33425.8298.00193.86435.98427.32438.00416.64
2023/06/14437.01439.06433.59437.18432.28100612100397.134.30439.06425.8298.32196.32436.32429.18438.86419.50
2023/06/15436.33443.90436.23442.60437.64110303100397.334.54443.90428.8799.61197.93440.07431.20440.66421.74
2023/06/16443.02443.61438.97439.46436.15114121300397.544.55443.90430.1752.73152.34441.29432.70443.39422.00
2023/06/20437.45438.37435.03437.18433.8876160400397.754.54443.90433.5931.3284.05436.70433.57443.97423.16
2023/06/21436.16436.99434.33434.94431.6676982300397.944.42443.90433.5917.4248.74435.66434.40443.87424.94
2023/06/22433.95436.62433.60436.51433.2270637200398.164.32443.90433.6049.0966.51435.11435.13443.40426.86
2023/06/23432.93435.06432.47433.21429.9492074500398.384.30443.61432.4718.7967.88433.76435.73442.31429.16
2023/06/26432.62434.61431.19431.44428.1972823600398.554.24438.37431.1911.3130.10432.90435.98441.81430.15
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/06/27432.35436.81431.88436.17432.8872813700398.724.32436.99431.1971.6582.96434.35436.21441.50430.93
2023/06/28435.05437.44434.41436.39433.1075636000398.874.23437.44431.1973.34145.00435.93436.21441.50430.92
2023/06/29435.96438.28435.54438.11434.8167882300399.014.12438.28431.1986.19159.53436.91436.27441.57430.96
2023/06/30441.44444.30441.11443.28439.94104921500399.264.27444.30431.1996.46182.65442.70436.53442.84430.22
2023/07/03442.92444.08442.63443.79440.4432793400399.514.07444.30431.8896.91193.37443.35436.74443.83429.64
2023/07/05441.91443.89441.90443.13439.7958418400399.773.92444.30434.4172.81169.72442.90437.36445.45429.27
2023/07/06439.42440.10437.06439.66436.3580658300400.044.07444.30435.5420.1492.94438.58437.65445.68429.62
2023/07/07438.63442.64438.30438.55435.2486076100400.294.09444.30437.0613.7733.90440.47438.18446.18430.19
2023/07/10438.18439.84437.59439.66436.3562443500400.573.96444.08437.0647.1960.95438.71438.68446.04431.32
2023/07/11440.45442.97439.44442.46439.1264463800400.893.93443.89437.0682.13129.31441.21439.51445.77433.26
2023/07/12446.39447.48444.91446.02442.6691924500401.254.01447.48437.0693.34175.47446.20440.70447.09434.30
2023/07/13447.90450.38447.45449.56446.1772425200401.664.03450.38437.5997.04190.37448.92441.99449.29434.69
2023/07/14450.48451.36448.49449.28445.8969761800402.093.95451.36437.5989.20186.24449.92443.30451.18435.41
2023/07/17449.13451.93449.08450.84447.4452680200402.523.87451.93439.4494.32183.52450.50444.08453.16434.99
2023/07/18450.50454.86450.05454.19450.7780744400402.943.94454.86444.9198.13192.44452.45444.99455.46434.51
2023/07/19455.01456.43454.11455.20451.7765891700403.403.82456.43447.4598.67196.79455.27446.22458.39434.06
2023/07/20454.17455.10451.44452.18448.7770591600403.883.82456.43448.4936.25134.92453.27447.69459.29436.09
2023/07/21453.96454.17452.17452.18448.7771245400404.313.69456.43449.0836.2572.51453.17448.96459.80438.12
2023/07/24453.37455.04452.30454.20450.7854023400404.693.63456.43450.0576.32112.58453.67450.46458.87442.05
2023/07/25453.92456.74453.87455.44452.0155191200405.083.57456.74451.4486.64162.96455.30451.87457.72446.01
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/07/26454.47456.99453.38455.51452.0871052900405.493.58456.99451.4487.26173.90455.18452.77457.38448.15
2023/07/27459.02459.44451.55452.49449.0892194400405.943.89459.44451.5517.30104.56455.49453.42457.44449.41
2023/07/28455.88457.78452.49456.92453.4880011800406.423.99459.44451.5575.3392.63455.13453.95457.22450.67
2023/07/31457.41458.16456.05457.79454.3462040400406.923.85459.44451.5580.66155.99457.10454.61457.43451.78
2023/08/01456.27457.25455.49456.48453.0455291500407.423.74459.44451.5548.87129.52456.37455.00457.57452.43
2023/08/02453.25453.52449.35450.13446.7493933400407.843.98459.44449.3510.1359.00451.43454.61458.02451.21
2023/08/03448.04450.79447.37448.84445.4664276100408.303.94458.16447.377.6717.80449.08454.19459.05449.34
2023/08/04450.72452.90446.27446.81443.44100052300408.704.13458.16446.274.3412.01449.58453.84459.49448.18
2023/08/07448.71450.87447.99450.71447.3158357500409.104.13457.25446.2764.1468.48449.43453.41459.72447.10
2023/08/08448.08450.70445.27448.75445.3771361300409.504.22453.52445.2739.39103.53447.99452.68459.68445.68
2023/08/09449.03449.20444.96445.75442.3978789600409.904.22452.90444.9618.0657.45447.08451.87459.43444.31
2023/08/10448.19451.70444.70445.91442.5593005500410.264.42452.90444.7022.5340.59448.20451.14458.55443.73
2023/08/11443.97446.70443.35445.65442.2968664600410.594.35451.70443.3519.1441.67445.03450.13457.87442.39
2023/08/14444.70448.11444.38448.11444.7347867400410.914.30451.70443.3579.0198.15446.24449.04455.35442.74
2023/08/15446.27446.64442.30442.89439.5575707500411.214.41451.70442.3019.0798.08444.47447.85452.20443.50
2023/08/16442.46444.18439.53439.64436.3380107200411.514.43451.70439.539.8128.88441.85446.90451.91441.88
2023/08/17441.16441.43435.75436.29433.0095711300411.754.52448.11435.754.9014.71438.59445.85452.83438.86
2023/08/18433.37437.57433.01436.50433.2198758400412.004.52448.11433.0110.5115.42435.29444.42453.53435.31
2023/08/21437.55440.11435.32439.34436.0368719000412.274.54446.64433.0165.5476.05437.71443.25452.50433.99
2023/08/22441.18441.18437.57438.15434.8565062900412.594.47444.18433.0143.25108.79439.38442.38451.28433.49
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/08/23439.25443.67439.10443.03439.6968441000412.954.55443.67433.0185.02128.27441.39441.82450.08433.55
2023/08/24444.69445.22436.86436.89433.6088517300413.254.82445.22433.0129.81114.83441.04441.10448.04434.16
2023/08/25438.68441.30435.00439.97436.65102325100413.554.93445.22435.0057.5087.31438.15440.41446.98433.85
2023/08/28442.24443.40439.97442.76439.4261595400413.864.82445.22435.0075.21132.71441.68439.96445.22434.69
2023/08/29442.65449.45442.46449.16445.7783081900414.234.97449.45435.0091.49166.70445.96440.10445.99434.22
2023/08/30449.51451.67448.78451.01447.6169053900414.514.82451.67435.0093.83185.32450.23440.94449.64432.24
2023/08/31451.65452.83450.16450.35446.9566084600414.774.67452.83435.0078.43172.26451.49442.23452.97431.49
2023/09/01453.17453.67449.68451.19447.7958875700415.054.62453.67439.9784.79163.22451.68443.87454.90432.84
2023/09/05450.73451.06449.17449.24445.8555166200415.314.44453.67442.4635.81120.59450.12445.11455.85434.37
2023/09/06448.40448.51443.81446.22442.8670758500415.564.51453.67443.8112.8448.64446.16445.79455.74435.84
2023/09/07443.11445.55442.75444.85441.5070355400415.814.43453.67442.758.1120.95444.15446.06455.62436.51
2023/09/08444.90447.11444.53445.52442.1661659700416.064.30453.67442.7532.4340.54445.82446.54455.44437.65
2023/09/11448.24448.77446.47448.45445.0760180100416.334.23451.06442.7579.61112.04447.62447.49454.15440.83
2023/09/12446.95448.53445.39445.99442.6367565400416.564.15448.77442.7536.64116.26446.96448.02453.33442.70
2023/09/13446.22447.71445.08446.51443.1460199300416.784.04448.77442.7548.4285.06446.39448.06453.31442.82
2023/09/14449.07451.08447.72450.36446.9683430800417.024.08451.08444.5386.25134.66449.40447.98453.10442.86
2023/09/15447.14447.48442.92443.37441.58111761400417.264.32451.08442.9223.54109.79445.20447.35452.08442.62
2023/09/18443.05444.97442.56443.63441.8455752200417.504.18451.08442.5627.4751.01443.76446.56450.68442.44
2023/09/19442.68443.29439.94442.71440.9266514600417.684.15451.08439.9420.1547.62441.62445.71450.07441.35
2023/09/20444.01444.44438.43438.64436.8782562600417.834.28451.08438.436.0026.15441.43445.24450.34440.13
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/09/21435.70435.97431.23431.39429.65103976100417.964.50447.48431.231.717.72433.60444.18453.17435.20
2023/09/22432.45434.10429.99430.42428.68100829700418.114.48444.97429.991.443.15432.04442.80454.49431.12
2023/09/25429.17432.27428.72432.23430.4870874500418.304.41444.44428.7238.3639.80430.49441.09454.53427.65
2023/09/26429.09429.82425.02425.88424.1696168400418.464.61444.44425.0210.5748.93427.42439.14454.35423.93
2023/09/27427.09427.67422.29426.05424.33104705800418.614.66435.97422.2913.9124.48424.98437.00453.63420.36
2023/09/28425.48430.25424.87428.52426.7992258300418.794.72434.10422.2958.7172.62427.56434.81449.87419.76
2023/09/29431.67431.85425.91427.48425.75115078500418.934.80432.27422.2940.8299.53428.88433.18446.69419.67
2023/10/02426.62428.60424.46427.31425.5883798600419.064.76431.85422.2937.1277.95426.53431.46443.25419.66
2023/10/03425.06427.37420.18421.59419.89103760600419.174.93431.85420.185.2342.36423.77429.67439.93419.41
2023/10/04422.07425.43420.56424.66422.9587453000419.354.93431.85420.1850.7055.93422.99427.83434.79420.86
2023/10/05424.36425.37421.17424.50422.7970142700419.554.87431.85420.1848.2898.98423.27426.79432.97420.62
2023/10/06421.97431.13420.60429.54427.81113202700419.805.28431.13420.1887.07135.35425.87426.18431.14421.21
2023/10/09427.58432.88427.01432.29430.5480374400420.065.32432.88420.1892.89179.96429.95426.12430.88421.36
2023/10/10432.94437.22432.53434.54432.7978607300420.305.29437.22420.5695.91188.80434.88426.87434.18419.56
2023/10/11435.64436.58433.18436.32434.5662451700420.585.16437.22420.6097.55193.46434.88427.86436.58419.14
2023/10/12436.95437.34431.23433.66431.9181154200420.835.22437.34420.6044.34141.89434.29428.53438.14418.92
2023/10/13435.21436.45429.88431.50429.7695143100421.085.32437.34427.0123.5167.85433.17428.96439.01418.91
2023/10/16433.82437.14433.57436.04434.2875433200421.385.34437.34429.8874.2997.80435.36429.84440.48419.20
2023/10/17432.81438.14432.45436.02434.2675324700421.645.37438.14429.8873.85148.14435.30430.99441.20420.79
2023/10/18434.19435.18429.09430.21428.4793559800421.885.48438.14429.0916.8790.72432.13431.91440.43423.39
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/10/19430.95432.82425.73426.43424.71121323000422.115.59438.14425.738.4225.29429.28432.51438.90426.11
2023/10/20425.98426.54421.08421.19419.49123845800422.305.59438.14421.083.5211.94423.81432.30439.70424.91
2023/10/23419.61424.45417.80420.46418.7692035100422.505.66438.14417.803.036.56421.13431.42441.63421.21
2023/10/24422.65424.82420.74423.63421.9278564200422.685.57435.18417.8056.1459.17422.78430.21441.42419.00
2023/10/25421.89421.92417.02417.55415.8694223200422.835.64432.82417.0218.1074.24419.47428.67441.19416.15
2023/10/26416.45417.33411.60412.55410.88115156800422.945.66426.54411.608.5626.67414.46426.69441.35412.03
2023/10/27414.19414.60409.21410.68409.02107367700423.015.65424.82409.216.1414.70411.90424.56441.09408.03
2023/10/30413.56416.68412.22415.59413.9186562700423.115.67424.82409.2162.2368.37414.45422.47438.20406.74
2023/10/31416.18418.53414.21418.20416.5179665200423.205.57421.92409.2176.90139.13416.37420.58433.81407.35
2023/11/01419.20423.50418.65422.66420.9598068100423.335.55423.50409.2190.08166.98421.07419.47429.98408.97
2023/11/02426.58430.92426.56430.76429.0294938900423.535.75430.92409.2196.77186.85428.74419.42429.71409.13
2023/11/03433.14436.29433.01434.69432.93100110800423.765.73436.29412.2298.05194.82434.65420.50434.47406.53
2023/11/06435.47436.15433.68435.69433.9367831700423.955.50436.29414.2198.37196.42434.91421.88438.58405.18
2023/11/07435.69437.59434.51436.93435.1764256100424.145.33437.59418.6598.85197.23436.05423.21442.18404.24
2023/11/08437.55438.09434.87437.25435.4861746000424.325.18438.09426.5699.00197.85436.48424.91445.38404.44
2023/11/09438.43438.47433.40433.84432.0983174400424.495.17438.47433.0126.02125.03435.93427.06447.16406.95
2023/11/10435.98440.93433.83440.61438.8389462200424.675.31440.93433.4081.16107.18437.38429.60447.51411.70
2023/11/13439.23441.33438.42440.19438.4152236100424.845.14441.33433.4074.29155.45439.88432.15447.53416.76
2023/11/14446.32450.06446.09448.73446.9297176900425.085.47450.06433.4094.21168.50448.07435.32449.25421.38
2023/11/15450.11451.38448.80449.68447.8677327600425.305.27451.38433.4095.06189.28450.09438.22451.01425.43
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/11/16449.22450.56448.12450.23448.4166665800425.495.07451.38433.8395.78190.85449.34440.28452.92427.64
2023/11/17450.24451.42449.29450.79448.9783133200425.664.86451.42438.4296.75192.53450.36441.85455.26428.44
2023/11/20450.53455.13450.52454.26452.4369936200425.874.84455.13446.0999.15195.90452.82443.64457.70429.58
2023/11/21453.18454.13451.96453.27451.4449244600426.094.66455.13448.1269.74168.89453.04445.34459.43431.25
2023/11/22454.98456.38453.89455.02453.1859394900426.294.55456.38448.1285.23154.97455.14447.21461.02433.39
2023/11/24455.07455.50454.73455.30453.4629737400426.514.28456.38449.2987.31172.54455.12449.12461.20437.05
2023/11/27454.65455.49454.08454.48452.6450506000426.754.07456.38450.5247.86135.17454.78450.86460.10441.63
2023/11/28454.08456.27453.50454.93453.0962115000426.993.98456.38451.9665.14113.00454.88452.36457.74446.99
2023/11/29457.15458.32454.20454.61452.7763146000427.193.99458.32453.5044.27109.41456.26453.18458.13448.24
2023/11/30455.48456.76453.34456.40454.5679752700427.413.95458.32453.3487.84132.11455.05453.68458.22449.14
2023/12/01455.77459.65455.16459.10457.2589097900427.643.99459.65453.3496.38184.23457.40454.49458.43450.54
2023/12/04455.60459.12454.34456.69454.8572430900427.884.05459.65453.3442.77139.15456.73455.12458.02452.23
2023/12/05455.26457.59454.87456.60454.7669793500428.133.95459.65453.3441.0683.83456.23455.46457.93453.00
2023/12/06458.81458.84454.31454.76452.9269124700428.413.99459.65453.3415.6156.67456.57455.82457.68453.96
2023/12/07456.91458.90456.29458.23456.3866995400428.704.00459.65454.3174.7290.32457.60456.06458.16453.97
2023/12/08457.46460.75457.21460.20458.3483080900429.003.97460.75454.3185.92160.64458.98456.45459.11453.78
2023/12/11459.69462.17459.47461.99460.1265002200429.333.88462.17454.3192.20178.12460.82457.05460.62453.48
2023/12/12461.63464.20460.60464.10462.2368327600429.663.86464.20454.3196.20188.40462.40457.80462.37453.24
2023/12/13464.49470.76464.12470.50468.6093278000430.034.06470.76456.2999.07195.27467.44458.92466.37451.47
2023/12/14472.50473.73469.25472.01470.10119026000430.424.09473.73457.2199.32198.39471.49460.57470.91450.22
OPENHIGHLOWCLOSEADJ_CLOSEVOLUMESMA200ATRHIGH5LOW5RSI2C2RSI2MPSMA10UPPERLOWER
2023/12/15469.49470.70467.43469.33469.33141319300430.784.12473.73459.4751.36150.67469.07461.73473.07450.39
2023/12/18470.98472.98469.89471.97471.9770375300431.124.09473.73460.6075.07126.43471.44463.20475.44450.97
2023/12/19472.53474.92472.45474.84474.8455761800431.474.01474.92464.1287.90162.97473.69464.95477.73452.16
2023/12/20473.96475.90467.82468.26468.26102921000431.824.30475.90467.4326.16114.06471.86466.48478.44454.51
2023/12/21471.33472.98468.84472.70472.7086667500432.194.33475.90467.4362.0988.26470.91467.81478.24457.37
2023/12/22473.86475.38471.70473.65473.6567126600432.604.28475.90467.8268.63130.72473.54469.26478.18460.35
2023/12/26474.07476.58473.99475.65475.6555387000433.054.19476.58467.8281.82150.45475.28470.71478.10463.33
2023/12/27475.44476.66474.89476.51476.5168000300433.504.01476.66467.8286.65168.47475.78472.05477.27466.82
2023/12/28476.88477.55476.26476.69476.6977106300433.933.82477.55468.8487.98174.63476.90473.00477.93468.06
In [ ]: