I need my stock portfolio tracker to be updated nightly. It should calculate performance of the stocks and indices (i.e. percentage change). It should also match up positions that are closed (Buy/Close or Sell/Close) and move them to a table of historical trades. It should record how many days a position has been open too.
1) Match up Buys/Close & Sell/Close trades.
2) Download data from Yahoo.
3) Calculate Performance.
4) Create table of Historical Trades for each user.
The code should run nightly.
Also - Yahoo only allows you to download 200 quotes at a time. After it downloads 200, it should stop and wait 30 minutes before downloading another 200 stock quotes.
I have the code that will allow you to download stock quotes from Yahoo.
See attached PDF for more detail