i'm goin to write down all the steps i took so far:i first studied the stationarity of two time series: google search and bitcoin price. (by "google search" i mean the number of times the word BITCOIN is typed in a day, using google as search engine; then i considered the daily google searches, so that i could find how many times BITCOIN was typed every single day).
i downloaded a plug-in system to be able to use the ADFTest function in excel and i found that both time series are non- stationary on the basis of the ADF test.
now that i know they're both non-stationary, (this means they both have an integration of order 1, aka I(1)) i wish i could study the cointegration between the two series, but to do so, i need to know the residuals of the functions y=alfa+Beta*x+e (where "e" is the residual i need, and "y" the function used for the cointegration)
can anyone tell me where to find those residuals???
thank u so much!!!!
: actually, I need to know where I can download the GOOGLE SEARCH DATA, as the assignement I’m working on is the relation between GOOGLE and the research of the world BITCOIN with this search engine (in other words, if my goal is to know from GOOGLE how many times the word BITCOIN has been typed in a day (or on a specific day), can I reach my goal or not?)