Berkeley CSUA MOTD:Entry 21062
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2025/04/07 [General] UID:1000 Activity:popular
4/7     

2001/4/23-24 [Computer/SW/Apps, Finance/Investment] UID:21062 Activity:moderate
4/22    I need something to keep track of my stock purchases, sales,
        gains, loss, splits, dividends, etc.  Should I just use Excel?
        \_ Quicken would probably be better than Excel.
           \_ not to mention quicker
           \_ Not to mention you can then transfer your data to TurboTax.
           \_ not to mention excel is a general use tool not designed for
              this.
        \_ On a related note, anyone know of a service where you can
           track foreign currenies and various other non-US financial
           instruments? My Yahoo! lets you get quoted prices for most
           of the ones I'm interested in but it doesn't do anything more.
           There are no histories, graphs, news items, etc...
                \_ You want to go into arbitrage like the guy in 9 & 1/2 weeks?
                   BTW, the original story didn't end with her 'empowerment'.
                   That was the Hollywood PC feel-good-about-being-a-woman-all
                   -men-suck version.
                   \_ forget arbitrage. Do Options now.
        \_ agreed.  Quicken is better.  But I believe if you want to
           customize your own analysis of your portfolio, Excel may be
           more flexible.
        \_ ObLinux: has anyone used GnuCash? 1.5 series looking good?
           \_ BOOT TO THE HEAD!!!
                \_ And he RIDES BIKE!
        \_ For those of you using Quicken for stocks, do you use
           their transaction download (from broker) feature.  I
           tried it with E*trade and it was full of mistakes.
                \_ You should be using Excel.
        \_ Is there somewhere where I can get a Excel worksheet
           already customized for stock tracking purposes?
                \_ http://www.google.com
2025/04/07 [General] UID:1000 Activity:popular
4/7     

You may also be interested in these entries...
2013/4/9-5/18 [Computer/SW/Languages/C_Cplusplus, Computer/SW/Apps, Computer/SW/Languages/Perl] UID:54650 Activity:nil
4/04    Is there a good way to diff 2 files that consist of columns of
        floating point numbers, such that it only tells me if there's a
        difference if the numbers on a given line differ by at least a given
        ratio?  Say, 1%?
        \_ Use Excel.
           1. Open foo.txt in Excel.  It should convert all numbers to cells in
	...
2008/9/1-3 [Computer/Companies/Google] UID:51015 Activity:moderate
9/1     THE GOOG had Scott McCloud do a comic explaining why THE GOOG Chrome
        (their open-source webbrowser) is cool.  I don't really think it worked
        http://blogoscoped.com/google-chrome
        \_ Oh boy, it comes with porn mode!
        \_ Oh boy, it comes with a porn hider feature!
           http://blogoscoped.com/google-chrome/22
	...
2008/3/17-21 [Computer/SW/Apps] UID:49481 Activity:kinda low
3/17    Is there a way to compare differences between two substantially
        similar Excel and/or Powerpoint documents other than going through
        them manually?
        \_ In Excel 2003, there is a "Compare and Merge Workbooks..." option
           under the Tools menu.  (But for some reason it is greyed out in my
           Excel 2003.)  In PowerPoint 2003 there is "Compare and Merge
	...
2008/1/5-7 [Computer/SW/Apps] UID:48895 Activity:moderate
1/5     I'm an Excel novice who needs help. Let us say I have a column of
        data A. I then take the absolute value of A1 and enter it in B1:
        (B1=ABS(A1)). All is good. My problem is when I want to delete
        Column A, Column B is still referencing A. How do I tell Excel to
        stop referencing the source data and instead let me have the
        result standalone? I don't want to keep A around anymore, but I
	...
2007/5/13-14 [Computer/SW/OS/Windows] UID:46613 Activity:nil
5/13    Someone please give us a 411 on Windows Vista? Is activation
        tougher than WinXP sp2? Is it impossible to get around now forcing
        you to pay for upgrades? Let me just say that I don't like Windows
        OS.  I don't mind using Microsoft Word, Excel, and Powerpoint,
        and they actually make decent games. However, for over a decade
        I've been sucked into using Windows3.0/95/98/2K/XP because
	...
2006/7/13 [Computer/SW/Apps] UID:43668 Activity:nil
7/13    In Excel, is it possible to average every 24th column in a particular
        row.  I googled this and found http://www.exceltip.com/st/Calculating_the_Average_Value_in_Every_Nth_Column,_Excluding_Zeros%09/862.html
        though I can't get it to work.  In my spreadsheet, I have
        =AVERAGE(IF((MOD(COLUMN(C156:CP156)-CELL("col",C156),24)=0),C156:CP156))
        It makes sense, but won't work.  It seems to do the if logic only
        on the first column, and then just average the entire range, rather
	...
2006/6/13-15 [Computer/SW/Security] UID:43377 Activity:nil
6/13    ok, memorizing all these passwords is driving me insane. I
        know this has been asked before but I cant find it: whats the
        best way to keep a password-protected file of very sensitive
        information? in this case, all my other passwords. thanks
        \_ I use http://www.bugmenot.com
        \_ Whatever happened to this single login thing called the
	...
2006/5/15-16 [Computer/SW/Apps] UID:43062 Activity:low
5/15    MS Excel question: I have a moderately large sheet with one column
        filled with entries that are in this form: "num; stuff", meaning
        it's a number followed by a semicolon followed by anything. Is there
        a way to split up this column into 2, with the first containing
        the number and the second containing everything after the semicolon?
        Thanks.
	...
2013/7/31-9/16 [Reference/RealEstate, Finance/Investment] UID:54720 Activity:nil
7[31    Suppose you have a few hundred thousand dollars in the bank earning
        minimum interest rate and you're not sure whether you're going to
        buy a house in 1-5 years. Should one put that money in a more
        risky place like Vanguard ETFs and index funds, given that the
        horizon is only 1-5 years?
        \_ I have a very similar problem, in that I have a bunch of cash
	...
2013/5/9-7/3 [Finance/Investment] UID:54675 Activity:nil
5/9     I'm stock newbie. Let's say  I made $1000 in Jan 2012 and then
        lost  $1000 in Feb 2012, does that mean I'm not liable to pay
        any tax given that I made $0?
        \_ Yes.
        \_ Are both long term gains/both short term gains? And I assume you
           mean realized gains, i.e. you actually sold the stock in an
	...
2013/1/25-2/19 [Finance/Investment] UID:54588 Activity:nil
1/25    Is there a site that tells you the % of people shorting
        on a particular stock? I'm trying to see if I can gauge
        "confidence level", that sort of thing.
        \_ http://www.nasdaq.com/symbol/intc/short-interest
           I'm not sure how to read this, I'm guessing the higher
           "days to cover" the more short activities there are?
	...
2013/1/16-2/17 [Industry/Startup, Finance/Investment] UID:54582 Activity:nil
1/16    Fred Wilson says you should focus on the cash value of your
        options, not the percentages:
        http://www.avc.com/a_vc/2010/11/employee-equity-how-much.html
        \_ Or at least, so says a VC trying increase his profit margin...
        \_ A VC wants to keep as much of the stock for themselves (and give
           as little to employees as possible).  That maximizes their return.
	...
2012/12/21-2013/1/24 [Industry/Startup, Finance/Investment] UID:54568 Activity:nil
12/21   http://techcompanypay.com
        Yahooers in Sunnyvale don't seem to average 170K/year.
        \_ Googlers average $104k/yr? Uh huh.
           \_ what is it suppose to be?
              \_ link:preview.tinyurl.com/a36ejr4
                 Google Sr. Software Engineer in Sunnyvale averages $193k in total pay,
	...
2012/1/18-3/3 [Computer/SW/Languages/Java, Finance/Investment] UID:54290 Activity:nil
1/18    I own a bunch of NFLX stocks bought at several different periods
        (from high $200 all the way down to $80). I dumped a few and
        still have a few. Why the hell is Reid Hastings still making
        $500,000/year? How do I join the pending NFLX Class Action
        Lawsuit?
        \_ Why would you buy stock in a company run by a narcissistic
	...
2011/12/9-2012/1/10 [Industry/Startup, Finance/Investment] UID:54254 Activity:nil
12/9    A public company (NASDAQ/NYSE) needs to publicly disclose
        important information right? Is there a way to find data that
        shows who owns most of the stocks, when they're dumping (to measure
        their confidence in the company), and how many people are shorting?
        \_ It has been a few years since I took a business organizations
           course, but from what I remember, there isn't a requirement for
	...
2011/9/21-11/8 [Finance/Investment] UID:54178 Activity:nil 63%like:54180
9/21    I'd like to run a test algorithm on the stock market. Where's a
        good source to get stock market price (minute-per-minute resolution)
        from?
        I've been away procreating. Looks like wall is no more. Where have all of
        the old-timers gone to chat/argue/share? How are we all communicating these
        days. Sorry for the ignorant questions. :( -- joeking
	...
Cache (199 bytes)
www.google.com -> www.google.com/
Web Images Groups News Froogle^ New! Google Search I'm Feeling Lucky Advanced Search Preferences Language Tools Advertising Programs - Business Solutions - About Google Graduating? Come work with us.