Hi I have a data set with "initial public offerings"(IPOs) and their IPO date. One column has the stock tickers and the other has the IPO date.
I want to find out how many tweets with the ticker symbol in the hashtag there are 1, 2 and 3 days prior to the IPO date. The problem is that I have nearly 3000 tickers...
Does anybody know how I can let Rstudio run these 3000 tickers as the query for these 3 points in time trough the count_all_tweets command? That would help me out massively
I'm sorry If i messed up the formatting of this post. I'm kind of new on here.
devtools::install_github("cjbarrie/academictwitteR", build_vignettes = TRUE)
#Load data into R
dataFrame <-read.csv("IPO excel data.csv", header = TRUE, sep = ";")
ticker <- dataFrame$Ticker
IPO_date <- dataFrame$Offer.date
#counting the tweets
tweets <- count_all_tweets(
query = '#Ticker',
start_tweets = '2015-01-05T00:00:00Z',
end_tweets = '2015-05-05T00:00:00Z',
bearer_token = get_bearer())