Friday, June 29

Jun 29, 2007

Our systems went down for about 2-3 hours today, right in the middle of running macros for month-end. And the whole dynamic of the situation, of using macros, and how it would be more efficient to have a program run the process instead of locking out computers came up.

It's interesting, although the company is relatively stable, we're still using macros on excel to do our work, when it is evident that people should be creating programs to run the same process. The only drawback is having to create the program... which would take a long time. Or it was suggested that the programs not run on our local computers... but somehow the programs are still loaded onto our local computers, and when macros need to be run for month/quarter/half-year/year end, nearly all activity becomes impossible, because we need excel to do a lot of our work.

I wonder why no one has thought to fix this, or anyone with the capability to...

Thursday, June 28

Jun 28, 2007

When I started at Schwab about a month ago, I thought since the former CEO returned to the company to help the company grow, I would one day, not soon, post outside of the very building which houses his office, and wait until he appeared, so I could either take a picture with him, or just introduce myself. (A fan thing to do, I know)

I was going downstairs to get my usual afternoon beverage at the Cafe on the first floor, and just as the door opened, the floor was swamped with men in business suits. It was a little strange, but I brushed it off as another potential client that upper management was trying to schmooze. Just as I walked in front of the group, a man says "Mr. Schwab, this way...", so I did a double and triple take of the group of 20 - 30 men, and spotted Charles Schwab near the corner of the group of men.

He looks exactly like his profile picture on the internal website, the Schweb!, except seeing him in person is so much more thrilling than seeing him on the web. He would probably be the first "celebrity" I have seen SO close, I potentially could have reached my arms out and touched him, had I known he was in front of my face the entire time. Too bad I saw him just as I was passing by him to go through security.

*Phew*

Anyway, isn't this interesting....

Execution of Mentally Ill Killer Blocked on NYTimes.com today.

Monday, June 25

Jun 25, 2007

I often thought that my closest friends would be the most understanding; however, through the years, I've also learned they are the ones most likely to stab you in the back and not have any regrets, and if not stab in the back, they "fight" the dirtiest because over time they've in a sense gained my confidance and trust.

Last night for the first time, I felt really betrayed. Although it was between the two of us, it was still what I'd consider a "low blow". I made a comment, and retrospectively, I probably should have chosen my audience for that comment more carefully, but I had thought that he'd be truly accepting of any opinion I had, merely because he's a close friend and should know that my comments are entirely my opinion. Yet at the same time, even without disclosure, that fact should be duly noted.

I commented on how another friend and I wanted to date older guys.

I guess to begin with, there was a problem there, my close friend is OUR age, so he may have already taken that to be insulting, and maybe not even insulting so much, that.

In any case, he stupidly asks, why would you want to?

So I explained why I wanted to, and how I felt that guys our age didn't have the same mentality. Noting nothing further than that. He somehow got enraged, and decided to make completely belligerent remarks, without having thought over what he was saying. He essentially started telling me what I was saying, (putting words in my mouth) that what I WAS saying was that guys my age were not UP TO PAR. Not my words.

I further explained that I thought guys my age acted younger, and for example the guys that we met the previous night, although were "much older" seemed no older than late 25-26, which is essentially perfect because mentality and personality, everything as one, how a person behaves adds to the age factor. Of course this latter part is an embellishment to further explain my train of thought. I told him no more than that the guys from the night before seemed like they were OUR age.

I'm not sure if this seems out of the blue, or not, but I was insulted nonetheless. "I think you only want to date older guys because they're more established, and have more to offer".

No, that doesn't have accusation written all over it. That doesn't show that my CLOSE friend just called me a "gold digger". Maybe some of you think that he didn't actually say that, but coming from someone who has been my friend for some 9 years, that's hurtful. Yes I made a generalization that I shouldn't have made to him, possibly only to females, because apparently I have a really sensitive friend, but no less, it was my opinion based on my experiences. And outright he says that's what I'm doing.

I'm sure if I confided in some of my other closer friends, they'll simply reject my feelings, and tell me that he had no intention of saying what I thought he said, instead, he was just stating a fact, that I am generalizing a whole group of people.

Yes, I do admit, for the umpteenth time that I did generalize. I did in the course of our discussion/argument tell him that in choosing to date an older man, the chance of meeting someone who still acted/behaved as though they were 14 was smaller. His only remark was that I didn't make any sense. I'm sure I made perfect sense. Dating someone my age there's a 75% possibly higher chance that he still thinks/wants to be in college. And to add on top of that, I'm already much older than most of my friends, because I was born several days later than the cut off date. I've never acted as though I was 12 when I was 12, and have not acted that way while growing up. I was forced in a sense to grow up and fend for myself, and here comes someone who's just beginning to understand me and what I have to live with telling me what I'm after when making a choice for myself. Hmmm interesting.

It only makes me that much more angry when discussing it. Thankfully I have the one friend who agrees, and to make it even better thinks he's also a little well young for his age. I often feel like I have to explain why I think what I think to him, as though explaining to a 2 year old why it is that the sky is blue... maybe not that bad.

Vent over!

Sunday, June 24

Jun 24, 2007

Okay, it's not so dramatic as the title... anyhow...

Although for the most part, my life seems almost entirely defined by work, things have been interesting otherwise... at least for the brief moments that I do engage in the outside life.

I have found my career. The only downside is that the woman who has been training me somehow decided that I was hired for the sole purpose of taking over her responsibilities so that when she returns from maternity leave, she would be able to learn something new. I don't complain often, and I'm usually content, but I will not let someone walk all over me, without my objections! After much conversation, I learned that in some grand scheme of things, there is a reorganization abrewing, and part of this reorganization is cross training everyone in the section so that everyone is familiar with everyone else's work, for day to day security, in the off chance that everyone who happens to know one particular task is out, there will be others who can fill in. Currently there are at most 2 people who know any given position, and no more. So the director, who hired me, is trying to start me off in what we call the Non Market desk so that I can learn to use the systems, and to see hands-on what trading encompasses. Although my purpose at the organization has not been finalized, their intent for me has never been, at least when my team lead and the others discussed what they wanted me to be responsible for, to stay at the Non Market desk, not in the long run. So that's good news...!

In other news, for the first time last night, I think I may have been very blatantly hit on by an older man.

Sunday afternoon, Henry calls unexpectedly to ask what my plans were for the night, and later discloses that he had free tickets to this invite-only party at Club Fanatics in SF. After some more discussions, Lauren and Cynthia joined the bandwagon, and at 10:00PM we were getting ready, and for the first time, I was actually consciously applying make-up as though I wanted to go home with someone other than the people I arrived with. To our utter disappointment, the club event was an entirely invite-only, closed party, that was half empty for a club that size. We mulled around for a bit, until Henry finally relented and let us leave the place.

We ended up at Bubble Lounge on Montgomery, where Henry and I had firsted decided to go many months ago, only to find it deserted, and unlit. Our recollections of the place were a little biased, until we got there, and the place was slammin'! Okay, the place was crowded, and well, not super fun, but still crowded enough to say that the place was not boring.

We walked from the entrance to the dance floor, crawled through the stench of too many human bodies in one living space, and found the bathroom and eventually walked back up the stairs to the front entrance area. Eventually we decided it was too late to go anywhere else, so we'd stay, find some seats and hang out, catch up, etc, except there were no seats available. WE paced from the front to the back, and retraced our steps to this one man sitting alone, only none of us were bold enough to ask to sit with him, because we weren't "drunk enough". So my friend and I were laughing about it, and eventually I let my eyes wander and lock gaze with this older Asian male sitting right behind my friend, with no intention to... his gaze was seductive, and one of longing, but well, far too old for my taste, and it scared me a little. I joked about the possibility and likelihood that the guys at the table would somehow offer us to sit with them, and we laughed about that. And sure enough, about 5 minutes later, one of the guys move over, and asked us to sit with them, commenting on the fact that they would not bite.

My friend jumped at the chance, and sat down. I was hesitant, because it was too predictable, and well too inviting for my taste, but eventually sat down beside her and my guy friend. All the while exchanging texts with my guy friend that I was suppose to meet up in the city. That didn't happen of course, but still it was attempt during the entire time we were at the lounge. The lone white guy of the group chatted up my friends, eventually asking my guy friend how he's lucky enough to hang with such "beautiful women", then asked if he was filipino. At the word "filipino" I wondered what the guy thought I was, so I asked. That was the flood gates opening...
the conversation literally went to his perception of my looks, and it was a rather uncomfortable position to be in, considering I didn't even formally meet him like the others. The guy made some really bold, and forward comments to me, and asked for confirmation from my guy friend, my guy friend however put it more lightly, so it was okay... he referenced my white shorts, and having noticed me early on when we had walked by... and well, kept refering to them. He even mentioned having noticing them to my good friend/ex roommate before he commented on it when we were engaged in conversation.

If that's not weird, I don't know what is. It wasn't even a comment about me, it was "I noticed you walking by earlier in your white shorts...", why thank you, I like my white shorts, too!

HAHA

Wednesday, June 13

Jun 13, 2007

Isn't this funny?

negligence

How often have you heard, "trust me, I'm a doctor."? Or things referring to how much better informed, or educated medical staff, doctors, surgeons, etc. are?

I only wish people would be less ignorant...

Jun 13, 2007

Yesterday morning, after the usual morning trading routine, I have literally no work from 9AM to around 11AM. In the past week I have cleaned up my notes from the activity, but seeing that I'm going into the end of my second week, most of my notes are more than elaborate. So I went in to speak with my director, and told him, for the second time, that I had free hours between these hours. He racked his brains for something to preoccupy me.

He came up with the monthly error report that they have had issues with at the beginning of each month. The finances department sends a detailed report of all the profits and gains from the previous month, and asks each department to justify the numbers. My director had decided to find out from where all the numbers came, and had not had the time to do the grunt of the work. He asked me to see if one column added up to the number found in the summary, at the end.

He was mainly concerned with the losses to the company, and after some hundreds of monetary transactions, the numbers matched. Good, we were done. Wrong. The conclusion only solved one of the problems, the larger problem were a couple of "unrealized profit and losses". The numbers seemed entirely random, and were not easily detectable on the detailed report. My instructions were simply "play around with these numbers and see if you can get this number".

The report, for all fund companies' transactions in a month, included columns: buy/sell, quantity (units), price, average price, position, and profit/loss, with rows: opening balance, the dates of transactions, and closing balance. At the end of each fund, was the market price, unrealized p&l, and the realized p&l.



The realized P&L was easy to calculate, they were simply the difference between the day's transactions at the previous price before correction multiplied by the day's quantity, and the day's transactions at the corrected price multiplied by the new day's quantity.

The uneralized P&L just didn't make sense. Especially when I looked at the numbers, unrealized didn't jump out at me, as realized had. I played around with some numbers, and came to the sad conclusion that my director had played me a fool... had decided to give me an unsolvable problem (that potentially no one before me, outside of the finances department, or the creator of the macro).

It was at this point that I decided that there had to be a way to calculate the numbers. I had three funds with the same problem, most of the other transactions were not flagged. By simply going over the ones with problems, I couldn't see what was wrong, so I glanced over the hundreds of pages of other transactions, and noted the difference between the two sets. The most notable part was that the ones without issues had the same beginning and end balance, usually equivalent to zero, while the ones with issues arose from having different balances. At this point, it became clear to me that the thing to consider had to seem out of balance compared to all the others, so I started to single out transaction days with no apparent matching opposite. I manipulated the numbers that looked like they could potentially equal the unrealized.

Still the problem didn't get easier to solve. It was only after noticing that the positions also looked to play a role, did the solution became apparent. An unrealized profit and loss had to come from something that isn't quite apparent, first I thought, well the units are different in the "position" so maybe it's the difference between the two multiplied by the price. That didn't work. Maybe it's the difference multiplied by the average price, still nothing. Or it could be the difference between the open balance and the closing balance multiplied by the price/average price. Nope, not it. After some more of this sort of logic, it came to me!

The market price value had remained untouched in the entirety of the previous calculations, surely they had some impact on the unrealized... for what reason? Not sure. Anyhow it turns out, the market price minus the corrected market price multiplied by the difference between quantity and the current position equals to the unrealized p&l to the penny! SOLVED! Not quite.

When I worked out the other errors in the report, my director came up with another issue... the market price. What impact did it play in the overall picture? Where was the finances department getting this number?

So he called up someone in finances, and walked them through the issue, and the result? Nothing extraordinary. What we concluded after the hour and a half meeting was that the report is pulling phantom units from somewhere in the past, and those numbers roll into each month's report, creating the same problem at the end of each month. Transactions on the last couple of days of the month also roll over into the next month, and do not post onto the current month's report, and then, of course, there's the problem of the market price. We still do not know why the number is being used, when the values in the price column are the prices that the client and the broker use.

It was decided that the report should be scraped, but still finances will need a justification, and an explanation for all the losses and profits. What they need to do is find out where the market price is coming from, what the unrealized p&l signifies, and who owns the report/macro that sends out the report each month.

Easy enough, for now.

Tuesday, June 12

Jun 12, 2007

It's now my second week at work, well really, as of tomorrow morning, I'll have completed 2 weeks here at Charlie Schwab. I've been training mostly with one person, occasionally shadowing some of the non-nonmarket people, and weekly cash settlements. I've gone through the process some 3-4 turns alone, and it seems as though hands-on is a better learning tool than the text book, watch as I perform the tasks. And although there is a lot to learn, everything that I've performed up to this point has been relatively routine, at specific times, and most work can be expected to be completed within an hour of two of the start time.

By around 3PM each afternoon, I sit around with literally nothing to do, and I feel guilty for sitting around surfing the internet for personal reasons and not for work, yet there is nothing I can do to change that. So I went to speak with my director after the morning trade, afternoon, etc, and he gave me a mathematical issue to work with, one that seemed to really have no end. Like most jobs, instruction is rare... but this was along the lines of "We work with this report every month, and we get this unrealized number, and we don't know how we get it. Here... play aruond with these numbers, and see if you can get this number." For the first five minutes, I worked ratherly blindly with the numbers, and didn't get anywhere. I thought for a brief second that my supervisor really was out of work, and needed something... anything to keep me busy, so he gave me basically an impossible task, and asked me to figure it out, when there is no tangible

Thursday, June 7

Jun 7, 2007

FROM dictionary.com, a/o 6/7/07

epicene \EP-uh-seen\,
adjective:
1. Having the characteristics of both sexes.
2. Effeminate; unmasculine.
3. Sexless; neuter.
4. (Linguistics) Having but one form of the noun for both the male and the female.

noun:
1. A person or thing that is epicene.
2. (Linguistics) An epicene word.

Wednesday, June 6

Jun 6, 2007

It seems so much more relaxed here, I'm not especially bugged by people watching dramas on youtube, or chatting on the company messenger system, or even talking on the phone, when I once was while I was at the department of health.

I have a chiropractor appointment today at 5PM, and I want to get shoes/pants today!

Monday, June 4

Jun 4, 2007

So true...

I had jury duty this morning, and I was about half an hour early, at least when I reached around Hanover and Lakeshore. I had just stopped at the stop light because the light turned red, 2 seconds later, the car behind me slams into me. I didn't see it coming, and my head jerked forward, and then slammed into the head rest of my seat. My head throbbed the whole two blocks that we drove to the next available parking area. I finally got out, and the woman comes out completely apologetic, "I'm so sorry, I wasn't paying attention, and I couldn't stop in time." She gave me all of her information, and then just as we were finishing up the exchange of information, we realized that her car was leaking some sort of fluid. She was really nice about it, but I guess for me, I was so shaken that I didn't grab the information I needed, like her DL#, license plate, or her address, I got all that other stuff like her VIN #, policy #, year and make of the car. I just wasn't altogether there at that point. I kept thinking, I have to go to jury duty, I have to go to jury duty, and didn't ask for anything. I didn't think I had injured anything, but about an hour later when I was sitting in the assembly room of the courthouse, I realized I couldn't turn my neck too close to 90 degrees, because it hurt too much. The side that had slammed into my seat had taken a beating, and that whole side is either numb or throbbing.

I went to the chiropractor and she said she would feel my back side to see how everything was. She was feeling my neck, the part that bothered me the least when I had gotten out of the accident, and the first thing she said to me was that my neck was noticeably swollen, and without reason, I started to cry. I know I'm a little sentimental, but I couldn't help it. I was injured at this point. She went further down my back, and determined that my right shoulder was resting at a lower angle than the left side of my body, and for the most part, my right side was throbbing near the lower back, and when I couldn't turn far to my left stretching my right side, or when I had to raise my arms, my right side was not doing as well as my left. By the time she told me that my pelvis was twisted to the side a little, it wasn't shocking, at all.

When she got around to the x-rays, I asked her how she could tell that my neck was swollen... so she explained to me that normally necks curve inwards from the nape to the collar bone-ish area, mine was lumped out. At this point, she had me feel for myself that it was swollen, and sure enough a GIANT lump outwards, and I teared up. She snapped a bunch of x-rays, and then told me she would help me release some tension, and put on some cooling gel for my swelling. Sure enough, the gel helped, frankly, I'm not sure how swollen my neck would have been if I just brushed off going in to get things checked out. I'm glad I did.

For the most part, everything is dandy, the rear-end of my car is completely gone, it was smashed in almost entirely, the trunk door is arched upwards, leaving about a 2-3 inch open gap, and the sides are about an inch ruptured, and the bumper is dropping about 1/2 a foot to a foot off the ground. Otherwise, everything is good. The upside is I get a spankin' new bumper, it's almost like a new car, now if only they would turn it into unbreakable/unbendable steel, I'd be good to go. Anyway, the woman's car barely dented at all, but some sort of fluid was leaking out of her car. At least no one was walking across the street when she rammed into me, so for the most part, everyone is nice and safe.