| Author |
Message
|
| vetelmo |
Posted: Mon May 08, 2006 11:50 am Post subject: |
|
|
 Moderator

|
My portfolio did something screwy twice today, one it said my portfolio was at -14% but it corrected itself once I clicked on the monthly return link. It did it again just now but said i was -5%. Just in case you need to know this stuff.  |
|
| Back to top |
|
 |
| Dave Rathbun |
Posted: Sat May 13, 2006 3:59 pm Post subject: |
|
|
 CFO

|
I don't, but thanks.
I know what the issue is, but so far my attempts to correct it have proven to be less than successful. When I have to update everyone's portfolios at once I'm asking for nearly a thousand different symbol quotes. Most of the time Yahoo returns them all, but on occasion it does not. When that happens the quote value is treated as zero, and your return goes south.
I'm working on a better way to handle it. |
|
| Back to top |
|
 |
| jdunn72 |
Posted: Sun May 14, 2006 12:49 am Post subject: |
|
|
 Member of The Month March

Joined: 26 Jan 2006
  Posts: 1407 This Month: 0
10586.77 e$
Net worth: 10,586.77 Portfolio Value: 0.00 Monthly Return: 0.00% Trades this month: 0 Churn Rate: 0.00%Items
|
| Dave Rathbun wrote: | I don't, but thanks.
I know what the issue is, but so far my attempts to correct it have proven to be less than successful. When I have to update everyone's portfolios at once I'm asking for nearly a thousand different symbol quotes. Most of the time Yahoo returns them all, but on occasion it does not. When that happens the quote value is treated as zero, and your return goes south.
I'm working on a better way to handle it. |
Dave, maybe in your scripts it might help if you have MYSQL dynamically Create a clone of the table with the quote data and schema in it and return the new yahoo data to the newly created table. After it gets the data........ run a query that pulls all the quotes >0 from it and use that query for the update query on the real table then have it Drop the dynamically created table for the process to start all over again, or basically something like that. Thereby not updating quotes with a zero val on the real table  |
|
| Back to top |
|
 |
| Dave Rathbun |
Posted: Sun May 14, 2006 4:35 am Post subject: |
|
|
 CFO

|
My simple approach was to simply count how many quotes I requested versus how many quotes I got, and retry until the two matched. Something in the logic is incorrect, as I still will get quote bundles that contain fewer quotes than requested.
The quote system is being redone for a variety of reasons, so I'm adding some additional checks. I'm also adding an automatic insert for all invalid quotes into a table viewable by the admins, so instead of waiting for users to complain about stock symbol changes (or whatever) the admin screen will already show that something is wrong. |
|
| Back to top |
|
 |
| SwashBuckler |
Posted: Mon Dec 11, 2006 10:12 am Post subject: |
|
|
 Investing Sr. Associate

Joined: 13 Aug 2006
 Posts: 88 This Month: 0
38197.74 e$
Net worth: 38,197.74 Portfolio Value: 0.00 Monthly Return: 0.00% Trades this month: 0 Churn Rate: 0.00%Items
|
| Can we now trade .OB and .PK stocks starting this week? |
|
| Back to top |
|
 |
| rick103054 |
Posted: Fri May 18, 2007 3:37 am Post subject: |
|
|
 Investing Sr. Associate

Joined: 08 Mar 2007
 Posts: 123 This Month: 0
126.77 e$
Net worth: 27,892.87 Portfolio Value: 27,766.10 Monthly Return: 5.98% Trades this month: 0 Churn Rate: 0.00%Items
|
| I WISH I WORKED AT THE STOCK MARKET. NICE HOURS 8:30-3:00 |
|
| Back to top |
|
 |
| eamoses |
Posted: Thu Jun 28, 2007 8:12 am Post subject: |
|
|
 Investing Sr. Associate

Joined: 08 Jun 2007 Posts: 54 This Month: 0
184.43 e$
Net worth: 22,188.23 Portfolio Value: 16,701.80 Monthly Return: 0.51% Trades this month: 0 Churn Rate: 0.00%Items  |
| i was wondering if we would be able to set up limits/stops anytime soon. that would be a big plus |
|
| Back to top |
|
 |
| Dave Rathbun |
Posted: Thu Jun 28, 2007 8:14 am Post subject: |
|
|
 CFO

|
| We don't have any scheduled release dates. Limits and shorts are two features on the priority list. |
|
| Back to top |
|
 |
| jutiki |
Posted: Tue Jul 31, 2007 10:15 am Post subject: |
|
|
 Investing Sr. Associate

Joined: 06 Aug 2006
 Posts: 50 This Month: 1
71970.24 e$
Net worth: 71,970.24 Portfolio Value: 0.00 Monthly Return: 0.00% Trades this month: 0 Churn Rate: 0.00%Items
|
| I wanted to short AHM, NFI, BZH, & FMT last week but we don't have that feature :( |
|
| Back to top |
|
 |
|
|