or Connect
New Posts  All Forums:

Posts by dsgNYC

GQ Forum Styleforum
Saw Brooke Shields walking with her kids and husband on W. 70th then saw John Turturo, who was in front of me in line at Maoz, between 70th & 71st on Amsterdam. This happened probably about 2 minutes apart. Of course my girlfriend was the one who recognized Brooke Shields and I was the one who recognized John Turturo.
Quote: Originally Posted by CunningSmeagol I have lost my touch. I can't visualize these problems without actually using excel It sure is a sad day when this happens. From here on out we have to institute manditory practice sessions if you post in this thread.
Quote: Originally Posted by JesterM Thanks, I really appreciate the help. I ended up using stata to match the dates (I created a master file with company id and actual trading days then used the joinby command to match it with the current file), then moved it back to excel for the formulas. Now I just have to use R for the analysis.....excel>stata>excel>R....FML. If I can't do it in Excel or Access, I don't do it. You have to draw the...
The new site has a great layout. The only thing I would recommend would be an "All" option instead of allowing the user to only drill down into a specific Tie, PS and/or Cufflink choice.
Quote: Originally Posted by AgentQ He already has a column with the trading days he needs in the same sheet. See below. Who reads the actual questions, anyway?
I don't understand what's weird about any of this.
Quote: Originally Posted by CunningSmeagol I was thinking more =if(iserror(vlookup(date,listofdates,pricecolumn,false)),,vlookup(date,listofdates,pricecolumn,false)) Exactly. The problem I was talking about was where do the new dates/prices go? I think the easiest solution would be to create a new dataset by listing every date starting with the oldest date until today. Then you can use the...
Quote: Originally Posted by CunningSmeagol Well the next step would be with entries that return an error to fill with the price immediately above, which shouldn't be hard, right? The problem would be that he'd be entering all the missing dates at the bottom of the dataset in one lump. I guess it shouldn't be too hard to grab the last date using a formula. Does an approximate VLOOKUP (TRUE) work with dates?
Paid for my ties last night and received them today. Nice when the seller lives around the corner. Great seller, very nice selection of ties and you can't really beat the prices.
New Posts  All Forums: