棕櫚油月間差量化整理

1、印度港口供應=t印度國內供需全球產區(qū)供應（其他國家出口主票是印度出口，馬來產量L印尼產量中國供應中國需求馬來庫存 除國內消貫7小阡百 出口剩下的）印尼庫存中國庫存內庫消比外庫消比I國外庫存國內壓力）棕油月間價差1.棕桐油基本面框架:內盤庫銷比對價差解釋有28%負相關，無直接線性關系，但在庫銷比在100%300%這段有與價差明顯的接近線性的負相關關系。內盤庫銷比在100%300%這段與59價差的負相關度更高些:國內庫銷比與59價差59價差內盤庫消比700%600%500%400%300%200%100%0%外盤庫銷比當月與價差比較，有23%的負相關。Res i duals;Min 1Q Medi

2、an 3Q Max00.0010.01 f 0.050.1-467.52 -98.5634.35 118.23 302.77Es ti mateStd- ErrorL VdluePr(|t|)(InterceptJ509.41198.342.5680.0151 *mxb-336.25162,232 0720.0464 6nxb-47.8827791.7230.0945 .Coeff i cientb;Signn f- codes:Residual standard -err|t|)2.5680.0151*-2.0720.0464*-L.72J(J.094b.0.001 0.01 * 0.05

3、1 Q.l LRes i dual standard error: 191 on 32 degrees of freedom Multiple R-squared: 0.2334, Adjusted R-squar*ed: 0.L855F -statnc ： 4.871 on 2 ind 32 OF . p-value ： 0. 01423解釋度低的原因：第一，月頻數據，數據較少（2013年開始一共就42行數），誤差會較大。第二，還有其他基本面數據指標沒有放進來。解決方案：跟量化結合后加入其他的自變量因子新加入：1 .中國月度庫存，月度需求絕對值；2 .印尼棕油月度庫存，產量絕對值；3 .馬來

4、月度庫存，單產，出口，產量；4 .馬來月度出口分別至中國，歐洲I,印度。具體價差與基本面量化指標之間的關系5-9價差結果：模型匯總模型RR方調整R方標準估計的誤1.916a.839.67887.6991系數模型非標準化系數標準系數tSig.B標準誤差試用版（常量）China_Beginning_Invento815.079405.6982.009.052ry-.227.127-.416-1.792.082China_Inventory 0-25%China_Inventory-146.36555.946-.317-2.616.013175%-100%China_Port_Arrival_Vol

5、u2.98259.516.009.050.960me.024.170.024.140.889China_Total_DemandChina_Inventory_to_Sale-.044.266-.038-.165.870s_Ratio10.73824.231.088.443.660Indonesia_Palm_Oil_Yields-.017.077-.057-.213.832Indonesia_Yields 0-25%-101.48591.777-.248-1.106.276Indonesia_Yields25%-75%-96.03956.502-.312-1.700.098Indonesia

6、_Palm_Oil_Inventory.119.064.5231.862.071Indonesia_Inventory0-25%103.04658.993.2671.747.089Indonesia_Inventory75%-100%-95.04256.699-.290-1.676.103MA_Beginning_Inventory.000.000-.712-2.227.032MA_Inventory 0-25%101.52245.980.2562.208.034MA_Inventory 75%-100% -26.00354.618-.082-.476.637MA_Yields.000.000

7、-.576-1.526.136MA_Yields 25%-75%76.24150.760.2431.502.142MA_Yields 75%-100%60.64695.814.178.633.531MA_Outport_Volume.000.000.4761.170.250MA_Outport 0-25%-85.62583.540-.228-1.025.312MA_Outport 25%-75%-149.22257.601-.486-2.591.014MA_Import_Volume5.760E-005.000.018.167.868MA_Domestic_Consumpti on.001.0

8、00.2371.654.107MA_Invcntory_to_Sales_71.60373.260.130.977.335RatioMA_Ratio 0-25%-93.796103.774-.213-.904.372MA_Ratio 25%-75%-43.03660.291-.139-.714.480MA_To_India.000.000-.188-.697.491MA_India 0-25%-80.291102.654-.146-.782.439MA_India 25%-75%-35.40666.001-.112-.536.595MA_To_China-.001.000-.325-1.336

9、.190MA_China 25%-75%-17.67160.032-.057-.294.770MA_China 75%-100%-4.781104.584-.013-.046.964MA_To_Europe-.001.001-.460-1.842.074MA_Euro 0-25%-104.98461.666-.303-1.702.098MA_Euro 75%-100%65.70448.754.1931.348.186對于5-9價差而言,重點關注因子：中國期初庫存，中國庫存 0-25% ,印尼庫存，印尼 0-25% ,和75%-100%分段的庫存，馬來的期初庫存，馬來庫存0-25%分段，馬來出口

10、 25%-75% ,馬來出口給中國，馬來出口給歐洲0-25%分段。對于59價差模型里基本面因子未來三個月變化可能基本面解釋分類因子（萬噸）12月3月比例變化中國方卸:中國期初庫存506224%仍在增庫存馬來單產（噸/公頃）1.61.36-15%減產幅度不夠馬來總出口131.3132.71%馬來力回：J來期初庫存279275-1%庫存仍然較高馬來國內消費26.523.9-10%馬來出口給中國3528-20%出口較差馬來出口至歐洲28.420-30%出口較差印尼方面印尼產量311.8259.1-17%印尼的產量，及庫存的下印尼庫存256159-38%降會抑制價差下跌的空間因此把明年1-4月的基本面

11、因子數據帶進去得到2018年1-4月的月均5-9價差結果如下:1月5-9平均價差：-462月5-9平均價差：-673月5-9平均價差：-834月5-9平均價差：-21 UntitldS普告.X is rsnk dficx/irt to witiiin adimc prcisiojik-40, 2777 -w* g 舊 -B3.0963 TO. 61641-5價差結果:模型匯總模型RR方調整R方標準估計的誤1.917a.842.69267.5248介差3002 on100-100-200-300-500-6do-7001 4 7 10 13 16 1口 22 25 28 31 34 37 40

12、43 46 4D 52 55 58 G1 64 G7 70 73真文值模擬值系數a模型非標準化系數標準系數tSig.B標準誤差試用版（常量）China_Beginning_Invento125.395310.130.404.688ry-.128.111-.301-1.155.255China_Inventory 0-25%China_Inventory144.23374.356.4571.940.060125%-75%China_Port_Arrival_Volu43.61043.874.180.994.327me-.530.138-.709-3.837.000China_Total_Dema

13、ndChina_Inventory_to_Sale.519.217.5912.393.022s_Ratio14.86923.823.122.624.536Indonesia_Palm_Oil_Yields.060.061.236.980.334Indonesia_Yields 0-25%-224.232102.683-.216-2.184.035Indonesia_Yields75%-100%-35.47147.189-.142-.752.457Indonesia_Palm_Oil_Inventory-.012.049-.062-.234.817Indonesia_Inventory0-25%

14、-113.85385.364-.324-1.334.190Indonesia_Inventory25%-75%-29.35643.794-.121-.670.507MA_Beginning_Inventory.000.000-.446-1.440.158MA_Inventory 0-25%-6.74267.281-.022-.100.921MA_Inventory 25%-75%68.50243.700.2841.568.125MA_Yields.000.000-.411-1.494.144MA_Yields 0-25%131.46054.654.2992.405.021MA_Yields 7

15、5%-100%25.10240.311.103.623.537MA_Outport_Volume.000.000.164.552.585MA_Outport 0-25%-39.81153.436-.091-.745.461MA_Outport 75%-100%22.28239.588.090.563.577MA_Import_Volume.001.000.1831.541.132MA_Domestic_Consumpti-1.090E-005.000-.004-.032.975onMA_Invcntory_to_Sales_55.77061.121.105.912.367RatioMA_Rat

16、io 0-25%-1.69241.490-.006-.041.968MA_Ratio 75%-100%-19.29949.674-.065-.389.700MA_To_India.000.000.099.430.669MA_India 0-25%-85.48543.793-.194-1.952.059MA_India 75%-100%-8.53647.717-.034-.179.859MA_To_China.000.000-.188-.735.467MA_China 25%-75%23.76437.891.096.627.534MA_China 75%-100%15.46564.134.057

17、.241.811MA_To_Europe.000.001.047.197.845MA_Euro 0-25%-6.29953.074-.022-.119.906MA_Euro 75%-100%-34.15741.339-.126-.826.4149-1價差結果:卜型匯總模型RR方調整R方標準估計的誤差1.855 a.731.489101.16249-1價差1 4 7 10 13 1G 19 22 2S 28 31 34 37 40 43 46 49 &2 S& S8 6 4 67 70 73真實值模擬值系數a模型非標準化系數標準系數tSig.B標準誤差試用版（常量）933.107366.9602

18、.543.015China_Beginning_Invento1-.157.147-.348-1.070.291ryChina_Inventory 0-25%-.99670.915-.002-.014.989China_Inventory75%-100%29.55467.723.101.436.665China_Port_Arrival_Volu-.204.293-.195-.698.490meChina_Total_Demand-.364.346-.343-1.052.299China_Inventory_to_Sale-14.42332.091-.130-.449.656s_RatioIn

19、donesia_Palm_Oil_Yiel.028.098.099.290.774dsIndonesia_Yields 0-25%-20.21464.703-.053-.312.756Indonesia_Yields-66.17475.422-.205-.877.38675%-100%Indonesia_Palm_Oil_Inve-.003.072-.012-.038.970ntoryIndonesia_Inventory-86.77472.130-.307-1.203.23625%-75%Indonesia_Inventory-114.997122.150-.300-.941.35275%-

20、100%MA_Beginning_Inventory-2.399E-005.000-.054-.133.895MA_Inventory 25%-75%-42.32351.931-.150-.815.420MA_Inventory 75%-100% 85.746103.088.255.832.411MA_Yields.000.000-.300-.836.408MA_Yields 25%-75%11.00460.515.039.182.857MA_Yields 75%-100%216.340108.935.6571.986.054MA_Outport_Volume.000.000.127.294.770