So I have been wanting to write an algo for trading natural gas for a while. I trade natural gas quite a bit on my own accounts and am pretty familiar with industry workings. Essentially what I have in mind is a algo that pulls years of historical data (more for back testing reasons) out to a 2 week forecast (to then take positions using) of average daily temperature information from WSI trader (a temperature forecasting service) into a excel file for several regional interconnections using fetch_csv. Using that data I want to assign a weighting to each based on estimated future usage (for instance PJM would be 15.34%). Then add all these regional loads to give one total US estimated load. Then basically if the number is above or below a certain level (hot or cold) then it would take a bullish position. On the other hand if it was at a certain range with mild temperatures it would take a bearish stance as load usage would be low. I personally have what I would call a low to working knowledge of python I have been trying to figure out how to use the fetcher function with no success. I feel like this could work, but for me to spend to time to learn how to get the skill to get this working would take a lot of work and time. Basically I was hoping someone (with a better knowledge of python) would help me to work on this. I don't know if anyone would be willing to, but I figured I wouldn't hurt to ask if anyone has a bit of time and would be interested in working with me to see my brainchild to realization. Also if anyone sees any obvious flaws with my idea I welcome constructive criticism.
-Spencer