Go Back   CDN Business Directory > Main Category > Financial Planning

 
 
Thread Tools Display Modes
  #1  
Old 03-03-2009, 08:56 PM
Avrum Lapin
Guest
 
Posts: n/a
Default Re: For Anyone Using "My Yahoo" Financial To List Their Portfolio, etc.

In article <goj8ru$o9n$1[at]news.motzarella.org> ,
"Robert11" <rgsros[at]xnotme.invalid> wrote:

- quote -

> Am getting on a bit in years now, so please bear with me a bit.
> I have my Portfolio of stocks on My Yahoo, the Financial page where you can
> list them, and it shows values etc.
> Works pretty well for me, and I use the different Views that it offers.
> Nice program, and nice presentation format(s) for the data.
> But I am having an absolute devil of a time in trying to transfer (Copy &
> Paste) the data to another text document.
> I can do it with a Print-Screen and a Paste, but this is not what I really
> want.
> I can use their Download-Spreadsheet button, but the downloaded Spreadsheet
> (into the latest Excel) which it opens up with on my PC looks nothing like
> what their page does.
> If I just do a regular Copy of their page, and Paste it directly into Excel,
> it also comes up very, very, differently.
> Does anyone perhaps kown how to do this so my Excel spreadsheet actually
> mirrors their page ?

I've tried the following with other on-line spread sheets.

Select the data that you want and paste it into Word (with page setup
for landscape)

You may see the data in a vertical column. Show the hidden characters.
Find and replace the paragraph symbols with tabs.

Save as text.

Open the text with Excel. Adjust the column width as required.

 
Old 03-03-2009, 02:17 PM
Ron Peterson
Guest
 
Posts: n/a
Default Re: For Anyone Using "My Yahoo" Financial To List Their Portfolio,etc.

On Mar 3, 7:25*am, "Robert11" <rgs...[at]xnotme.invalid> wrote:

- quote -

> I have my Portfolio of stocks on My Yahoo, the Financial page where you can
> list them, and it shows values etc.


> Works pretty well for me, and I use the different Views that it offers.
> Nice program, and nice presentation format(s) for the data.


One can also create custom views.

- quote -

> But I am having an absolute devil of a time in trying to transfer (Copy &
> Paste) the data to another text document.


> I can do it with a Print-Screen and a Paste, but this is not what I really
> want.


> I can use their Download-Spreadsheet button, but the downloaded Spreadsheet
> (into the latest Excel) which it opens up with on my PC looks nothing like
> what their page does.


The download spreadsheet is capturing the latest quotes and doesn't
correspond to your view.

- quote -

> If I just do a regular Copy of their page, and Paste it directly into Excel,
> it also comes up very, very, differently.


A regular copy doesn't have special delimiters between the fields

- quote -

> Does anyone perhaps kown how to do this so my Excel spreadsheet actually
> mirrors their page ?


You will have to do some manual editing.

- quote -

> Is there a more appropriate Forum or Newsgroup to post this question ?

http://office.microsoft.com/en-us/ex...646951033.aspx will give
you more information on Excel.

--
Ron

  #-1  
Old 03-03-2009, 12:25 PM
Robert11
Guest
 
Posts: n/a
Default For Anyone Using "My Yahoo" Financial To List Their Portfolio, etc.

Hello,

Am getting on a bit in years now, so please bear with me a bit.

I have my Portfolio of stocks on My Yahoo, the Financial page where you can
list them, and it shows values etc.
Works pretty well for me, and I use the different Views that it offers.
Nice program, and nice presentation format(s) for the data.

But I am having an absolute devil of a time in trying to transfer (Copy &
Paste) the data to another text document.

I can do it with a Print-Screen and a Paste, but this is not what I really
want.

I can use their Download-Spreadsheet button, but the downloaded Spreadsheet
(into the latest Excel) which it opens up with on my PC looks nothing like
what their page does.

If I just do a regular Copy of their page, and Paste it directly into Excel,
it also comes up very, very, differently.

Does anyone perhaps kown how to do this so my Excel spreadsheet actually
mirrors their page ?

Is there a more appropriate Forum or Newsgroup to post this question ?

Thank you very much,
Bob

 
Similar Threads
Thread Forum Replies Last Post
MSN De Lux Portfolio showing wrong data In the "% Gain" and "Averege Cost" columns
Fulvio Bizzaro: Hi, have a problem with the DeLux Portfolio: Since some days, from September 2008 the calculation in the Gain/Loss is not accurate: It is...
Microsoft Money 8 10-05-2008 10:41 PM
"TR all" vs. "% gain" in portfolio view?
brett: I'm using Money Plus Deluxe. What is the difference between these two columns? Their values are very different from each other. TR all might be...
Microsoft Money 8 09-25-2008 04:28 AM
"news" and "fyi" links on the "Track My Portfolio" page
tom: no longer work in my Money 2000. When I click them, I get "MSN Money-Page Not Found" and "The page you requested could not be found." But there is a...
Microsoft Money 7 10-25-2007 11:34 PM
Portfolio not updating "today's change" & "last updated" fields
evy38: Does anybody know why portfolio is not updating these fields?
Microsoft Money 1 06-13-2006 05:05 PM
Money 2002 transaction status flags ("E", "C", "R") have all disappeared
Nick Tonkin: Hi, After many months of using Money 2002, yesterday I suddenly noticed that the column in my resgister that shows the cleared status of each...
Microsoft Money 4 02-28-2004 04:39 AM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 03:44 PM.