search for: marketcap

Displaying 6 results from an estimated 6 matches for "marketcap".

2004 Nov 30
3
Relative subscripting
Hi! I'm trying to do the following. I have monthly a dataset with, among other things, "marketcap", and "return". I want to multiply return by the marketcap of the previous month. How do I do this? In STATA (which I have used frequently in the past) I would simply use an expression of the form return[_n]*marketcap[_n-1] I believe they call this relative subscripting. Is th...
2011 Mar 16
2
Need to abstract changing name of column within loop
...I want to change the 7th column name: > colnames(A)[7] [1] "A.Adjusted.1" I need to do that through a reference to i: > i [1] "A" This works: > colnames(get(i))[7] [1] "A.Adjusted.1" And this is what I want to change the column name to: > paste(i, ".MarketCap", sep = "") [1] "A.MarketCap" But how do I make the assignment? This clearly doesn't work: > colnames(get(i))[7] <- paste(i, ".MarketCap", sep = "") Error in colnames(get(i))[7] <- paste(i, ".MarketCap", sep = "") :...
2020 Jul 15
2
read.csv fails in R console in Ubuntu terminal but works in RStudio after R 3.6.3 upgrade to R 4.0.2
...d R code output and sessionInfo(). *Works in RStudio* > read.csv("https://old.nasdaq.com/screening/companies-by-name.aspx?letter=0&exchange=1&render=download", header=TRUE, as.is=TRUE, na="n/a") Symbol Name LastSale MarketCap IPOyear 1 TXG 10x Genomics, Inc. 87.4400 $8.6B 2019 2 YI 111, Inc. 6.4800 $533.69M 2018 3 PIH 1347 Property Insurance Holdings, Inc. 4.5350 $27.52M 2014 sessionInfo() R version 4...
2008 Aug 20
1
How to send Html using SQL Server db mail
All, I have a variable called `go` and it has a single quote in the name column of line 47 that I am trying to get rid of. I have tried using gsub, but I cannot get the syntax correct to tell R to remove the ' (single quote). > go[47,] gvkey Symbol Name Rank MarketCap MemoDate Action Analyst Reason SharesHeld 75 065105 BJ BJ'S WHOLESALE CLUB INC 0.9579 2258.24 <NA> <NA> <NA> <NA> <NA> > I have tried every combination I could think of, some of them being: gsub(go, `'`, ` `) gsub(go, "'",...
2020 Jul 16
2
read.csv fails in R console in Ubuntu terminal but works in RStudio after R 3.6.3 upgrade to R 4.0.2
...PP" ... ?$ Name???????? : chr? "10x Genomics, Inc." "111, Inc." "1347 Property Insurance Holdings, Inc." "1347 Property Insurance Holdings, Inc." ... ?$ LastSale???? : chr? "90.93" "6.31" "4.528" "24.35" ... ?$ MarketCap??? : chr? "$8.94B" "$519.69M" "$27.48M" "n/a" ... ?$ IPOyear????? : chr? "2019" "2018" "2014" "n/a" ... ?$ Sector?????? : chr? "Capital Goods" "Health Care" "Finance" "Finance"...
2020 Jul 15
0
read.csv fails in R console in Ubuntu terminal but works in RStudio after R 3.6.3 upgrade to R 4.0.2
...this got easier. I clicked on the link (in Ubuntu 20.04) and it downloaded it. From there few problems. `read.csv()` just reads it: edd at rob:~/Downloads$ Rscript -e 'data.table::fread("companylist.csv", header=TRUE)' Symbol Name LastSale MarketCap IPOyear Sector industry Summary Quote V9 1: TXG 10x Genomics, Inc. 88.91 $8.75B 2019 Capital Goods Biotechnology: Laboratory Analytical Instruments https://old.n...