17
$\begingroup$

I'm looking for a model between stockprices of energy and the weather. I have the price of the MWatt bought between the countries of Europe, and a lot of values on the weather (Grib files). Each hours on a period of 5 years (2011-2015).

Price/day

enter image description here

This is per day for one year. I have this per hours on 5 years.

Example of weather

enter image description here 3Dscatterplot, in kelvin, for an hour. I have 1000 values per data per hour and 200 data, like klevin, wind, geopential etc..

I'm trying to forecast the mean price per hour of the Mwatt.

My data on the weather are very dense, more than 10000 values/hour and so with a high correlation. It's a problem of short,big data.

I've tried the Lasso, Ridge and SVR methods with the mean price of the MWatt as outcome and my weather's data as income. I took 70% as training data and 30% as test. If my test's data are non-forecasting (somwhere inside my training data) I have a good prediction( R² = 0.89). But i want to do forecasting on my data.

So if the test data are chronologically after my training data it doesn't predict anything (R²=0.05). I think it's normal because it's a time serie. And there is a lot of autocorrelation.

I thought that i had to use time serie model like ARIMA. I calculated the order of the method (the serie is stationary) and I tested it. But it doesn't work . I mean that the forecasting has a r² of 0.05.My prediction on the test data is not at all on my test data. I tried the ARIMAX method with my weather as regressor. Put it doesn't add any information.

ACF/PCF, Test/train data

So I've done a seasonal cut per day and per week

Day

enter image description here

Week on the trend of the first

enter image description here

And I can have this if I can predecit the trend of trend of my stock price : enter image description here

The blue is my prediction and the red the real value.

I'm going to do a regression with a rolling mean of the weather as income and the trend of the trend of the stockprice as outcome. But for now, I haven't find any relation.

But if there is no interaction, how can I know there isn't anything? maybe it's just that I haven't find it.

Improve this question
$\endgroup$
13
  • $\begingroup$ Your question is too broad to be answerable. What are you modeling? What "doesn't work"? Regression and ARIMA are totally different models, so what exactly were you doing..? $\endgroup$
    – Tim
    Commented Jul 4, 2016 at 7:50
  • $\begingroup$ I'm modeling the evolution of the price. And i got a R² less than 0.2 on my forecasting $\endgroup$
    – el Josso
    Commented Jul 4, 2016 at 8:11
  • 1
    $\begingroup$ And what exactly is the problem here? Could you elaborate about what is your data, what models have you tried, what problems do you have and most importantly: what is your question in here? How do you define "evolution of price"? As I said, your question is too vague and too broad and so is a candidate to be closed as unanswerable. $\endgroup$
    – Tim
    Commented Jul 4, 2016 at 8:15
  • $\begingroup$ Do i need to add graphics ? $\endgroup$
    – el Josso
    Commented Jul 4, 2016 at 8:55
  • $\begingroup$ You can if it helps (in many cases it does) :) $\endgroup$
    – Tim
    Commented Jul 4, 2016 at 9:06

1 Answer 1

Reset to default
10
$\begingroup$

You might be interested in a formal science domain called "computational mechanics." In an article by James Crutchfield and David Feldman, they lay out the program of computational mechanics—as far as I understand it—as parsing out the boundaries between (1) deterministic uncertainty and the information cost of inferring deterministic relationships, (2) stochastic uncertainty and the information cost of inferring probability distributions, and (3) entropic uncertainty and the consequences of being information poor.

To answer your question directly (albeit also quite broadly, since you asked a broad question), how we know when we have learned either "enough," or "all we can" from data is an open domain of research. The former will necessarily be contingent upon one's needs as a researcher and actor in the world (e.g., given how much time? how much processing power? how much memory, how much urgency, etc.).

I'm not up on this field, or even deep with this particular article, but they're some cool thinkers. :)

Crutchfield, J. P. and Feldman, D. P. (2003). Regularities unseen, randomness observed: Levels of entropy convergence. Chaos, 13(1):25–54.

Improve this answer
$\endgroup$
2
  • 3
    $\begingroup$ Not sure if this' answered OP question, but I like this perspective. $\endgroup$
    – horaceT
    Commented Jul 5, 2016 at 19:16
  • 1
    $\begingroup$ It's not really what i was looking for but it's a good article. $\endgroup$
    – el Josso
    Commented Jul 6, 2016 at 7:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.