7 New Messages
Digest #2670
Messages
Mon Jun 24, 2013 9:39 am (PDT) . Posted by:
"V. Shankar" tarakayan
When you download daily stock market info in Excel using MSN Money Central, using Data Query, it used to accept 100 stock symbols at a time for various data.
Now it looks like it can accept 50 symbols only...Anyone experienced this?
thanks,
Shankar
Now it looks like it can accept 50 symbols only...Anyone experienced this?
thanks,
Shankar
Mon Jun 24, 2013 10:19 am (PDT) . Posted by:
"Henry Oppenheimer" hroppenheimer
Over the weekend it seemed not accept much.
Sent from my iPhone
On Jun 24, 2013, at 12:39 PM, "V. Shankar" <tarakayan@yahoo.com > wrote:
> When you download daily stock market info in Excel using MSN Money Central, using Data Query, it used to accept 100 stock symbols at a time for various data.
>
> Now it looks like it can accept 50 symbols only...Anyone experienced this?
>
> thanks,
> Shankar
>
Sent from my iPhone
On Jun 24, 2013, at 12:39 PM, "V. Shankar" <tarakayan@yahoo.
> When you download daily stock market info in Excel using MSN Money Central, using Data Query, it used to accept 100 stock symbols at a time for various data.
>
> Now it looks like it can accept 50 symbols only...Anyone experienced this?
>
> thanks,
> Shankar
>
Mon Jun 24, 2013 12:19 pm (PDT) . Posted by:
"Frederick Knight Jr" frederickknightjr
Hi
I use MSN portmanager to view all my listings. Since Jun 23 2013 it does not up date the data.. It shows all my stocks but does not update the prices.
Fred
--------------------------------------------
On Mon, 6/24/13, V. Shankar <tarakayan@yahoo.com > wrote:
Subject: [smf_addin] MSN Moneycentral Investor Stock Quotes in excel..
To: "smf_addin@yahoogroups.com " <smf_addin@yahoogroups.com >
Date: Monday, June 24, 2013, 8:52 AM
When
you download daily stock market info in Excel using MSN
Money Central, using Data Query, it used to accept 100 stock
symbols at a time for various data.
Now
it looks like it can accept 50 symbols only...Anyone
experienced this?
thanks,Shankar
I use MSN portmanager to view all my listings. Since Jun 23 2013 it does not up date the data.. It shows all my stocks but does not update the prices.
Fred
------------
On Mon, 6/24/13, V. Shankar <tarakayan@yahoo.
Subject: [smf_addin] MSN Moneycentral Investor Stock Quotes in excel..
To: "smf_addin@yahoogrou
Date: Monday, June 24, 2013, 8:52 AM
When
you download daily stock market info in Excel using MSN
Money Central, using Data Query, it used to accept 100 stock
symbols at a time for various data.
Now
it looks like it can accept 50 symbols only...Anyone
experienced this?
thanks,Shankar
Mon Jun 24, 2013 4:05 pm (PDT) . Posted by:
"Henry Oppenheimer" hroppenheimer
Just tried to update a spreadsheet of 110 stocks. Only five gave new values. All did so a week ago. Most of them give result of 'VALUE'; rest give '-'.
Sent from my iPhone
On Jun 24, 2013, at 3:19 PM, "Frederick Knight Jr" <73fvkjr73@sbcglobal.net > wrote:
> Hi
>
> I use MSN portmanager to view all my listings. Since Jun 23 2013 it does not up date the data.. It shows all my stocks but does not update the prices.
> Fred
> --------------------------------------------
> On Mon, 6/24/13, V. Shankar <tarakayan@yahoo.com > wrote:
>
> Subject: [smf_addin] MSN Moneycentral Investor Stock Quotes in excel..
> To: "smf_addin@yahoogroups.com " <smf_addin@yahoogroups.com >
> Date: Monday, June 24, 2013, 8:52 AM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> When
> you download daily stock market info in Excel using MSN
> Money Central, using Data Query, it used to accept 100 stock
> symbols at a time for various data.
> Now
> it looks like it can accept 50 symbols only...Anyone
> experienced this?
> thanks,Shankar
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Sent from my iPhone
On Jun 24, 2013, at 3:19 PM, "Frederick Knight Jr" <73fvkjr73@sbcglobal
> Hi
>
> I use MSN portmanager to view all my listings. Since Jun 23 2013 it does not up date the data.. It shows all my stocks but does not update the prices.
> Fred
> ------------
> On Mon, 6/24/13, V. Shankar <tarakayan@yahoo.
>
> Subject: [smf_addin] MSN Moneycentral Investor Stock Quotes in excel..
> To: "smf_addin@yahoogrou
> Date: Monday, June 24, 2013, 8:52 AM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> When
> you download daily stock market info in Excel using MSN
> Money Central, using Data Query, it used to accept 100 stock
> symbols at a time for various data.
> Now
> it looks like it can accept 50 symbols only...Anyone
> experienced this?
> thanks,Shankar
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Tue Jun 25, 2013 1:03 am (PDT) . Posted by:
"Randy H" rharmelink
Sounds like adding a third parameter may help?
http://www.excelforum.com/excel-formulas-and-functions/932893-msn-stock-quotes-plugin-stopped-working-june-2013-a.html
http://www.excelfor
Mon Jun 24, 2013 11:48 am (PDT) . Posted by:
"schlange.meister" schlange.meister
Hey Randy
I just tried some MSN codes from the
RCHGetElementNumber-Element-Definitions in the SMF folder.
I used code 25 for last price and it worked
Then I used codes 27 and 1088 for the 3 month performance and both gave errors. Am I getting errors because the codes are invalid or because something is wrong with my excel?
Considering that last price code (25) worked, I thought the others would work. The same situation occured when trying to do the price performance sheet with arrays v4. The price is updated, but the performance from yahoo gives me #NA after processing for 10 mins.
Thanks
I just tried some MSN codes from the
RCHGetElementNumber
I used code 25 for last price and it worked
Then I used codes 27 and 1088 for the 3 month performance and both gave errors. Am I getting errors because the codes are invalid or because something is wrong with my excel?
Considering that last price code (25) worked, I thought the others would work. The same situation occured when trying to do the price performance sheet with arrays v4. The price is updated, but the performance from yahoo gives me #NA after processing for 10 mins.
Thanks
Mon Jun 24, 2013 12:01 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
MSN appears to have dropped their performance measures from the stock print
page, which is why element #27 (and similar element numbers) won't work.
Element #25 still has the issue it's had for the last year -- it's the
previous day's closing price, not the last traded price. Because that's
what MSN is posting as "Last Price".
Element #1088 comes from an ETF website, so it won't work for stocks.
The v4 spreadsheet recalculates almost immediately for me.
On Mon, Jun 24, 2013 at 11:48 AM, schlange.meister <
schlange.meister@yahoo.com > wrote:
>
> I just tried some MSN codes from the
> RCHGetElementNumber-Element-Definitions in the SMF folder.
>
> I used code 25 for last price and it worked
>
> Then I used codes 27 and 1088 for the 3 month performance and both gave
> errors. Am I getting errors because the codes are invalid or because
> something is wrong with my excel?
>
> Considering that last price code (25) worked, I thought the others would
> work. The same situation occured when trying to do the price performance
> sheet with arrays v4. The price is updated, but the performance from yahoo
> gives me #NA after processing for 10 mins.
>
page, which is why element #27 (and similar element numbers) won't work.
Element #25 still has the issue it's had for the last year -- it's the
previous day's closing price, not the last traded price. Because that's
what MSN is posting as "Last Price".
Element #1088 comes from an ETF website, so it won't work for stocks.
The v4 spreadsheet recalculates almost immediately for me.
On Mon, Jun 24, 2013 at 11:48 AM, schlange.meister <
schlange.meister@
>
> I just tried some MSN codes from the
> RCHGetElementNumber
>
> I used code 25 for last price and it worked
>
> Then I used codes 27 and 1088 for the 3 month performance and both gave
> errors. Am I getting errors because the codes are invalid or because
> something is wrong with my excel?
>
> Considering that last price code (25) worked, I thought the others would
> work. The same situation occured when trying to do the price performance
> sheet with arrays v4. The price is updated, but the performance from yahoo
> gives me #NA after processing for 10 mins.
>
Tidak ada komentar:
Posting Komentar