|
#1
| |||
| |||
| 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. |
| | |||
| |||
| 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
One can also create custom views.> 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. - quote - > But I am having an absolute devil of a time in trying to transfer (Copy &
The download spreadsheet is capturing the latest quotes and doesn't> 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. correspond to your view. - quote - > If I just do a regular Copy of their page, and Paste it directly into Excel,
A regular copy doesn't have special delimiters between the fields> it also comes up very, very, differently. - quote - > Does anyone perhaps kown how to do this so my Excel spreadsheet actually
You will have to do some manual editing.> mirrors their page ? - quote - > Is there a more appropriate Forum or Newsgroup to post this question ? http://office.microsoft.com/en-us/ex...646951033.aspx will giveyou more information on Excel. -- Ron |
|
#-1
| |||
| |||
| 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 | |
| |