How do you get option quotes in MS Money with new symbols

Discussion in 'Microsoft Money' started by Paul, Jan 26, 2010.

  1. Paul

    Paul Guest

    Does anyone know how to get the new symbol option quotes into the Portfolio
    Manager within MS Money? The symbol format changed on 1/25/2010 from the old
    format (ex.. Dell february 13 put was .dlyno) which is no longer valid.
     
    Paul, Jan 26, 2010
    #1
    1. Advertising

  2. Paul

    Mark Guest

    Go out to MSN Money and loop up the Options chain:
    http://moneycentral.msn.com/investor/options/default.asp?Symbol=DELL

    Don't know whether or not those new symbols will work within Money though?

    -Mark

    "Paul" <> wrote in message
    news:...
    > Does anyone know how to get the new symbol option quotes into the
    > Portfolio
    > Manager within MS Money? The symbol format changed on 1/25/2010 from the
    > old
    > format (ex.. Dell february 13 put was .dlyno) which is no longer valid.
     
    Mark, Jan 26, 2010
    #2
    1. Advertising

  3. Paul

    Paul Guest

    Mark, I tried doing that earlier and there didn't seem to have enough space
    within Money field for the symbol. When I enter the entire symbol with the
    back slashes, it gets truncated. I assumed the updates come from the
    moneycentral source you referenced. I'll keep looking.
    thanks
    Paul

    > Go out to MSN Money and loop up the Options chain:
    > http://moneycentral.msn.com/investor/options/default.asp?Symbol=DELL
    >
    > Don't know whether or not those new symbols will work within Money though?
    >
    > -Mark
    >
    > "Paul" <> wrote in message
    > news:...
    > > Does anyone know how to get the new symbol option quotes into the
    > > Portfolio
    > > Manager within MS Money? The symbol format changed on 1/25/2010 from the
    > > old
    > > format (ex.. Dell february 13 put was .dlyno) which is no longer valid.

    >
    > .
    >
     
    Paul, Jan 27, 2010
    #3
  4. Paul

    Bob A. Guest

    "Paul" wrote:

    > Does anyone know how to get the new symbol option quotes into the Portfolio
    > Manager within MS Money? The symbol format changed on 1/25/2010 from the old
    > format (ex.. Dell february 13 put was .dlyno) which is no longer valid.
     
    Bob A., Jan 27, 2010
    #4
  5. Paul

    Bob A. Guest

    Paul - I'm having the same problem and am not happy about it. In addition to
    Mark's suggestion (looking up the option chain in MSN Money) you can also use
    the symbol lookup function when adding your new option investment within MS
    Money. That will find the option chain, and displays the new symbols. Only
    problem is, when the new symbol is saved by MS Money it doesn't appear to
    work. The quote server must not recognize it. It appears that the Symbol
    field in MS Money is 12 chars. long, but the new symbols are 15 chars. long.
    MS Money saves something, but displays only the first 6 chars. or so,
    followed by "...". It's hard to know what it actually saved behind the
    scenes. I suspect MS Money needs a "fix" in order to get it to work with the
    new option symbol format. Has anyone else found a solution?

    "Paul" wrote:

    > Does anyone know how to get the new symbol option quotes into the Portfolio
    > Manager within MS Money? The symbol format changed on 1/25/2010 from the old
    > format (ex.. Dell february 13 put was .dlyno) which is no longer valid.
     
    Bob A., Jan 27, 2010
    #5
  6. Paul

    Paul Guest

    Bob A., I came to the same conclusion that the symbol field in MS Money is
    only 12 characters long and gets truncated. You can enter 15 characters then
    you get a beep but when you go back to look at what you entered it only
    displays 12. I agree that MS Money needs to get this fixed to work around
    this problem. I don't see any alternative.

    Paul

    "Bob A." wrote:

    > Paul - I'm having the same problem and am not happy about it. In addition to
    > Mark's suggestion (looking up the option chain in MSN Money) you can also use
    > the symbol lookup function when adding your new option investment within MS
    > Money. That will find the option chain, and displays the new symbols. Only
    > problem is, when the new symbol is saved by MS Money it doesn't appear to
    > work. The quote server must not recognize it. It appears that the Symbol
    > field in MS Money is 12 chars. long, but the new symbols are 15 chars. long.
    > MS Money saves something, but displays only the first 6 chars. or so,
    > followed by "...". It's hard to know what it actually saved behind the
    > scenes. I suspect MS Money needs a "fix" in order to get it to work with the
    > new option symbol format. Has anyone else found a solution?
    >
    > "Paul" wrote:
    >
    > > Does anyone know how to get the new symbol option quotes into the Portfolio
    > > Manager within MS Money? The symbol format changed on 1/25/2010 from the old
    > > format (ex.. Dell february 13 put was .dlyno) which is no longer valid.
     
    Paul, Jan 27, 2010
    #6
  7. Paul

    teabag Guest

    Do you KNOW that the MS servers carry the option price that interests you?

    Given that MS will discontinue price downloads after 2011-01-31 I think it
    is highly unlikely that they will create patches to increase the symbol
    field length from 12 to 15 (or more) characters for obsolescent versions of
    Money and it is beyond belief that they will create patches for obsolete
    versions.

    An alternative is to enter option prices manually.

    teabag



    "Paul" <> wrote in message
    news:...
    > Bob A.,
    > I came to the same conclusion that the symbol field in MS Money is only 12
    > characters long and gets truncated.
    > I agree that MS Money needs to get this fixed to work around this problem.
    > I don't see any alternative.
    >
    > Paul
     
    teabag, Jan 27, 2010
    #7
  8. Paul

    Paul Guest

    Teabag, I believe your right, we will have to update the prices manually.
    MSFT will most likely not create a patch to extend the symbol field length
    although it does appear to be a simple change.

    Paul

    "teabag" wrote:

    > Do you KNOW that the MS servers carry the option price that interests you?
    >
    > Given that MS will discontinue price downloads after 2011-01-31 I think it
    > is highly unlikely that they will create patches to increase the symbol
    > field length from 12 to 15 (or more) characters for obsolescent versions of
    > Money and it is beyond belief that they will create patches for obsolete
    > versions.
    >
    > An alternative is to enter option prices manually.
    >
    > teabag
    >
    >
    >
    > "Paul" <> wrote in message
    > news:...
    > > Bob A.,
    > > I came to the same conclusion that the symbol field in MS Money is only 12
    > > characters long and gets truncated.
    > > I agree that MS Money needs to get this fixed to work around this problem.
    > > I don't see any alternative.
    > >
    > > Paul

    >
    >
    > .
    >
     
    Paul, Jan 27, 2010
    #8
  9. Paul

    MikeLV Guest

    Do I understand this correctly? That after Jan 31, 2011 MS Money will no
    longer get any stock quotes updated? Tracking portfolio value is one of the
    main reasons I use MS Money.

    "teabag" wrote:

    > Given that MS will discontinue price downloads after 2011-01-31 I think it
    > is highly unlikely that they will create patches to increase the symbol
    > field length from 12 to 15 (or more) characters for obsolescent versions of
    > Money and it is beyond belief that they will create patches for obsolete
    > versions.
     
    MikeLV, Jan 27, 2010
    #9
  10. Paul

    Bob A. Guest

    Agreed teabag. Yes - I do know that the MS servers carry the options prices,
    and as I had mentioned you can look up the options chains (and prices) when
    adding a new option investment from within MS Money. I guess I'm just
    expressing my frustration with the fact that MS Money is slowly becoming less
    and less useful to track investments, and as you mentioned that will be
    capped off by the discontinuation of price downloads in 2011. For now it
    appears that manually entering option prices as I've started doing is the
    only recourse. Very sad. Money is an excellent product for the most part.

    "teabag" wrote:

    > Do you KNOW that the MS servers carry the option price that interests you?
    >
    > Given that MS will discontinue price downloads after 2011-01-31 I think it
    > is highly unlikely that they will create patches to increase the symbol
    > field length from 12 to 15 (or more) characters for obsolescent versions of
    > Money and it is beyond belief that they will create patches for obsolete
    > versions.
    >
    > An alternative is to enter option prices manually.
    >
    > teabag
    >
    >
    >
    > "Paul" <> wrote in message
    > news:...
    > > Bob A.,
    > > I came to the same conclusion that the symbol field in MS Money is only 12
    > > characters long and gets truncated.
    > > I agree that MS Money needs to get this fixed to work around this problem.
    > > I don't see any alternative.
    > >
    > > Paul

    >
    >
    > .
    >
     
    Bob A., Jan 28, 2010
    #10
  11. Paul

    gcraig Guest

    OK, glad I found this thread before struggling too long. Ran into all this
    and doesn't seem to be a work around. Curiously an older call option I have
    outstanding which has the old format symbol continues to update. Tried to
    recreate the older format for a new call I bought yesterday but it won't take.

    Here is something that works outside of Money. If you have Excel you can
    download the Excel 2003 add in "MS Money Stock Quote for Excel" (I think I
    got it from MSFT web site). It takes the new format and updates correctly.
    Not perfect but at least gets an automated way of doing it.

    "Paul" wrote:

    > Does anyone know how to get the new symbol option quotes into the Portfolio
    > Manager within MS Money? The symbol format changed on 1/25/2010 from the old
    > format (ex.. Dell february 13 put was .dlyno) which is no longer valid.
     
    gcraig, Feb 2, 2010
    #11
  12. Paul

    FrankV Guest

    It's for Excel 2002 and 2003:
    http://www.microsoft.com/downloads/...D8-9305-4535-B939-3BF0A740A9B1&displaylang=en

    Frank

    "gcraig" <> wrote in message
    news:...
    > OK, glad I found this thread before struggling too long. Ran into all this
    > and doesn't seem to be a work around. Curiously an older call option I
    > have
    > outstanding which has the old format symbol continues to update. Tried to
    > recreate the older format for a new call I bought yesterday but it won't
    > take.
    >
    > Here is something that works outside of Money. If you have Excel you can
    > download the Excel 2003 add in "MS Money Stock Quote for Excel" (I think I
    > got it from MSFT web site). It takes the new format and updates correctly.
    > Not perfect but at least gets an automated way of doing it.
    >
    > "Paul" wrote:
    >
    >> Does anyone know how to get the new symbol option quotes into the
    >> Portfolio
    >> Manager within MS Money? The symbol format changed on 1/25/2010 from the
    >> old
    >> format (ex.. Dell february 13 put was .dlyno) which is no longer valid.
     
    FrankV, Feb 2, 2010
    #12
  13. Paul

    gcraig Guest

    gcraig, Feb 3, 2010
    #13
  14. Paul

    gcraig Guest

    OK, weirdness, today my call options started pricing correctly. The
    following format for calls starting pricing correctly today in money:

    WGE1221A12.5
     
    gcraig, Feb 5, 2010
    #14
  15. Paul

    Jim Hawley Guest

    Haven't got it to work - an example please?

    Hi
    Have been struggling trying to get my spreadsheets updated to show options pricing using the new symbology. Have been completely frustrated.
    I think if I saw one example that actually worked it would become instantly clear. You say you got it to work. Can you post the actual excel stockquotes formula that will return a value. Here is an example of one of my old forumula...
    =MSNStockQuote("."&$B7,"Bid","US")
    In these equations, cell B7 would contain the old symbol, for example CATEM or somesuch.
    If you could post an example, any example, that actually returns a value I could figure out what I am doing wrong.
    Thanks




    gcraig wrote:

    I installed in Excel 2007 and it works fine."FrankV" wrote:
    02-Feb-10

    I installed in Excel 2007 and it works fine.

    "FrankV" wrote:

    Previous Posts In This Thread:


    Submitted via EggHeadCafe - Software Developer Portal of Choice
    EggHeadCafe Chat Chaos in Silverlight Released Today
    http://www.eggheadcafe.com/tutorial...6-54f31bdede5d/eggheadcafe-chat-chaos-in.aspx
     
    Jim Hawley, Feb 10, 2010
    #15
  16. Paul

    ameridan Guest

    I stumbled on information that indicates that Money should accomodate the new
    21-digit symbology for options and felt I had to share it here. If in fact
    it works, the next step will be to get the OFX scripts to obtain the data
    from Yahoo! along with stock quotes so that we will be able to import into
    Money after Microsoft pulls the plug.

    Anyways, check out the link to a slide show from Schwab on how to change the
    option symbol. They don't seem to think there is a 12 digit max...

    http://microsoftmoneyoffline.wordpr...options-symbology-microsoft-money-compatible/

    "Paul" wrote:

    > Bob A., I came to the same conclusion that the symbol field in MS Money is
    > only 12 characters long and gets truncated. You can enter 15 characters then
    > you get a beep but when you go back to look at what you entered it only
    > displays 12. I agree that MS Money needs to get this fixed to work around
    > this problem. I don't see any alternative.
    >
    > Paul
    >
    > "Bob A." wrote:
    >
    > > Paul - I'm having the same problem and am not happy about it. In addition to
    > > Mark's suggestion (looking up the option chain in MSN Money) you can also use
    > > the symbol lookup function when adding your new option investment within MS
    > > Money. That will find the option chain, and displays the new symbols. Only
    > > problem is, when the new symbol is saved by MS Money it doesn't appear to
    > > work. The quote server must not recognize it. It appears that the Symbol
    > > field in MS Money is 12 chars. long, but the new symbols are 15 chars. long.
    > > MS Money saves something, but displays only the first 6 chars. or so,
    > > followed by "...". It's hard to know what it actually saved behind the
    > > scenes. I suspect MS Money needs a "fix" in order to get it to work with the
    > > new option symbol format. Has anyone else found a solution?
    > >
    > > "Paul" wrote:
    > >
    > > > Does anyone know how to get the new symbol option quotes into the Portfolio
    > > > Manager within MS Money? The symbol format changed on 1/25/2010 from the old
    > > > format (ex.. Dell february 13 put was .dlyno) which is no longer valid.
     
    ameridan, Feb 18, 2010
    #16
  17. Paul

    Jim Hawley Guest

    Second request

    In February you stated that the new symbols would work in Excel using the MSNstockquotes addin. I asked for an example so I could see why I was not getting it to work. No reply. Asking again - can you give one example that works for you. I would need the symbol and the formula that refers to that symbol and returns a (any) value.
    Thanks




    gcraig wrote:

    OK, glad I found this thread before struggling too long.
    02-Feb-10

    OK, glad I found this thread before struggling too long. Ran into all thi
    and does not seem to be a work around. Curiously an older call option I hav
    outstanding which has the old format symbol continues to update. Tried t
    recreate the older format for a new call I bought yesterday but it will not take

    Here is something that works outside of Money. If you have Excel you ca
    download the Excel 2003 add in "MS Money Stock Quote for Excel" (I think
    got it from MSFT web site). It takes the new format and updates correctly
    Not perfect but at least gets an automated way of doing it

    "Paul" wrote:

    Previous Posts In This Thread:

    On Tuesday, January 26, 2010 3:39 PM
    Paul wrote:

    How do you get option quotes in MS Money with new symbols
    Does anyone know how to get the new symbol option quotes into the Portfoli
    Manager within MS Money? The symbol format changed on 1/25/2010 from the ol
    format (ex.. Dell february 13 put was .dlyno) which is no longer valid.

    On Tuesday, January 26, 2010 4:47 PM
    Mark wrote:

    Go out to MSN Money and loop up the Options chain:http://moneycentral.msn.
    Go out to MSN Money and loop up the Options chain
    http://moneycentral.msn.com/investor/options/default.asp?Symbol=DEL

    Don't know whether or not those new symbols will work within Money though

    -Mark

    On Tuesday, January 26, 2010 8:03 PM
    Paul wrote:

    Mark, I tried doing that earlier and there did not seem to have enough
    Mark, I tried doing that earlier and there did not seem to have enough spac
    within Money field for the symbol. When I enter the entire symbol with th
    back slashes, it gets truncated. I assumed the updates come from th
    moneycentral source you referenced. I will keep looking
    thank
    Paul

    On Tuesday, January 26, 2010 11:13 PM
    Bob A. wrote:

    "Paul" wrote:
    "Paul" wrote:

    On Tuesday, January 26, 2010 11:21 PM
    Bob A. wrote:

    Paul - I am having the same problem and am not happy about it.
    Paul - I am having the same problem and am not happy about it. In addition t
    Mark's suggestion (looking up the option chain in MSN Money) you can also us
    the symbol lookup function when adding your new option investment within M
    Money. That will find the option chain, and displays the new symbols. Onl
    problem is, when the new symbol is saved by MS Money it does not appear t
    work. The quote server must not recognize it. It appears that the Symbo
    field in MS Money is 12 chars. long, but the new symbols are 15 chars. long
    MS Money saves something, but displays only the first 6 chars. or so
    followed by "...". it is hard to know what it actually saved behind th
    scenes. I suspect MS Money needs a "fix" in order to get it to work with th
    new option symbol format. Has anyone else found a solution

    "Paul" wrote:

    On Wednesday, January 27, 2010 10:31 AM
    Paul wrote:

    Bob A.
    Bob A., I came to the same conclusion that the symbol field in MS Money i
    only 12 characters long and gets truncated. You can enter 15 characters the
    you get a beep but when you go back to look at what you entered it onl
    displays 12. I agree that MS Money needs to get this fixed to work aroun
    this problem. I do not see any alternative

    Pau

    "Bob A." wrote:

    On Wednesday, January 27, 2010 11:01 AM
    teabag wrote:

    Do you KNOW that the MS servers carry the option price that interests you?
    Do you KNOW that the MS servers carry the option price that interests you

    Given that MS will discontinue price downloads after 2011-01-31 I think i
    is highly unlikely that they will create patches to increase the symbo
    field length from 12 to 15 (or more) characters for obsolescent versions o
    Money and it is beyond belief that they will create patches for obsolet
    versions.

    An alternative is to enter option prices manually.

    teabag

    On Wednesday, January 27, 2010 3:32 PM
    Paul wrote:

    Teabag, I believe your right, we will have to update the prices manually.
    Teabag, I believe your right, we will have to update the prices manually.
    MSFT will most likely not create a patch to extend the symbol field length
    although it does appear to be a simple change.

    Paul

    "teabag" wrote:

    On Wednesday, January 27, 2010 5:39 PM
    MikeLV wrote:

    Do I understand this correctly?
    Do I understand this correctly? That after Jan 31, 2011 MS Money will no
    longer get any stock quotes updated? Tracking portfolio value is one of the
    main reasons I use MS Money.

    "teabag" wrote:

    On Wednesday, January 27, 2010 9:57 PM
    Bob A. wrote:

    Agreed teabag.
    Agreed teabag. Yes - I do know that the MS servers carry the options prices,
    and as I had mentioned you can look up the options chains (and prices) when
    adding a new option investment from within MS Money. I guess I am just
    expressing my frustration with the fact that MS Money is slowly becoming less
    and less useful to track investments, and as you mentioned that will be
    capped off by the discontinuation of price downloads in 2011. For now it
    appears that manually entering option prices as I have started doing is the
    only recourse. Very sad. Money is an excellent product for the most part.

    "teabag" wrote:

    On Tuesday, February 02, 2010 11:31 AM
    gcraig wrote:

    OK, glad I found this thread before struggling too long.
    OK, glad I found this thread before struggling too long. Ran into all this
    and does not seem to be a work around. Curiously an older call option I have
    outstanding which has the old format symbol continues to update. Tried to
    recreate the older format for a new call I bought yesterday but it will not take.

    Here is something that works outside of Money. If you have Excel you can
    download the Excel 2003 add in "MS Money Stock Quote for Excel" (I think I
    got it from MSFT web site). It takes the new format and updates correctly.
    Not perfect but at least gets an automated way of doing it.

    "Paul" wrote:

    On Tuesday, February 02, 2010 3:49 PM
    FrankV wrote:

    it is for Excel 2002 and 2003:http://www.microsoft.com/downloads/details.aspx?
    it is for Excel 2002 and 2003:
    http://www.microsoft.com/downloads/...D8-9305-4535-B939-3BF0A740A9B1&displaylang=en

    Frank

    On Tuesday, February 02, 2010 8:31 PM
    gcraig wrote:

    I installed in Excel 2007 and it works fine."FrankV" wrote:
    I installed in Excel 2007 and it works fine.

    "FrankV" wrote:

    On Friday, February 05, 2010 1:08 PM
    gcraig wrote:

    OK, weirdness, today my call options started pricing correctly.
    OK, weirdness, today my call options started pricing correctly. The
    following format for calls starting pricing correctly today in money:

    WGE1221A12.5

    On Wednesday, February 10, 2010 11:29 AM
    Jim Hawley wrote:

    Haven't got it to work - an example please?
    Hi
    Have been struggling trying to get my spreadsheets updated to show options pricing using the new symbology. Have been completely frustrated.
    I think if I saw one example that actually worked it would become instantly clear. You say you got it to work. Can you post the actual excel stockquotes formula that will return a value. Here is an example of one of my old forumula...
    =MSNStockQuote("."&$B7,"Bid","US")
    In these equations, cell B7 would contain the old symbol, for example CATEM or somesuch.
    If you could post an example, any example, that actually returns a value I could figure out what I am doing wrong.
    Thanks

    On Wednesday, February 17, 2010 8:38 PM
    ameridan wrote:

    I stumbled on information that indicates that Money should accomodate the
    I stumbled on information that indicates that Money should accomodate the new
    21-digit symbology for options and felt I had to share it here. If in fact
    it works, the next step will be to get the OFX scripts to obtain the data
    from Yahoo! along with stock quotes so that we will be able to import into
    Money after Microsoft pulls the plug.

    Anyways, check out the link to a slide show from Schwab on how to change the
    option symbol. They do not seem to think there is a 12 digit max...

    http://microsoftmoneyoffline.wordpr...options-symbology-microsoft-money-compatible/

    "Paul" wrote:


    Submitted via EggHeadCafe - Software Developer Portal of Choice
    BizTalk Configure and Send SMTP Mail Based on Message Within an Orchestration
    http://www.eggheadcafe.com/tutorial...1-a2f309a021c2/biztalk-configure-and-sen.aspx
     
    Jim Hawley, Mar 31, 2010
    #17
  18. Paul

    Jack Guest

    MSN MoneyCentral Stock Add-in

    Microsoft appears to have removed the link. MS support has not been able to help. Do you know the name of the add-in file or could you provide a link to another source?



    FrankV wrote:

    it is for Excel 2002 and 2003:http://www.microsoft.com/downloads/details.aspx?
    02-Feb-10

    it is for Excel 2002 and 2003
    http://www.microsoft.com/downloads/...CD8-9305-4535-B939-3BF0A740A9B1&displaylang=e

    Frank

    Previous Posts In This Thread:

    On Tuesday, January 26, 2010 3:39 PM
    Paul wrote:

    How do you get option quotes in MS Money with new symbols
    Does anyone know how to get the new symbol option quotes into the Portfoli
    Manager within MS Money? The symbol format changed on 1/25/2010 from the ol
    format (ex.. Dell february 13 put was .dlyno) which is no longer valid.

    On Tuesday, January 26, 2010 4:47 PM
    Mark wrote:

    Go out to MSN Money and loop up the Options chain:http://moneycentral.msn.
    Go out to MSN Money and loop up the Options chain
    http://moneycentral.msn.com/investor/options/default.asp?Symbol=DEL

    Don't know whether or not those new symbols will work within Money though

    -Mark

    On Tuesday, January 26, 2010 8:03 PM
    Paul wrote:

    Mark, I tried doing that earlier and there did not seem to have enough
    Mark, I tried doing that earlier and there did not seem to have enough spac
    within Money field for the symbol. When I enter the entire symbol with th
    back slashes, it gets truncated. I assumed the updates come from th
    moneycentral source you referenced. I will keep looking
    thank
    Paul

    On Tuesday, January 26, 2010 11:13 PM
    Bob A. wrote:

    "Paul" wrote:
    "Paul" wrote:

    On Tuesday, January 26, 2010 11:21 PM
    Bob A. wrote:

    Paul - I am having the same problem and am not happy about it.
    Paul - I am having the same problem and am not happy about it. In addition t
    Mark's suggestion (looking up the option chain in MSN Money) you can also us
    the symbol lookup function when adding your new option investment within M
    Money. That will find the option chain, and displays the new symbols. Onl
    problem is, when the new symbol is saved by MS Money it does not appear t
    work. The quote server must not recognize it. It appears that the Symbo
    field in MS Money is 12 chars. long, but the new symbols are 15 chars. long
    MS Money saves something, but displays only the first 6 chars. or so
    followed by "...". it is hard to know what it actually saved behind th
    scenes. I suspect MS Money needs a "fix" in order to get it to work with th
    new option symbol format. Has anyone else found a solution

    "Paul" wrote:

    On Wednesday, January 27, 2010 10:31 AM
    Paul wrote:

    Bob A.
    Bob A., I came to the same conclusion that the symbol field in MS Money i
    only 12 characters long and gets truncated. You can enter 15 characters the
    you get a beep but when you go back to look at what you entered it onl
    displays 12. I agree that MS Money needs to get this fixed to work aroun
    this problem. I do not see any alternative

    Pau

    "Bob A." wrote:

    On Wednesday, January 27, 2010 11:01 AM
    teabag wrote:

    Do you KNOW that the MS servers carry the option price that interests you?
    Do you KNOW that the MS servers carry the option price that interests you

    Given that MS will discontinue price downloads after 2011-01-31 I think i
    is highly unlikely that they will create patches to increase the symbo
    field length from 12 to 15 (or more) characters for obsolescent versions o
    Money and it is beyond belief that they will create patches for obsolet
    versions

    An alternative is to enter option prices manually

    teabag

    On Wednesday, January 27, 2010 3:32 PM
    Paul wrote:

    Teabag, I believe your right, we will have to update the prices manually.
    Teabag, I believe your right, we will have to update the prices manually
    MSFT will most likely not create a patch to extend the symbol field lengt
    although it does appear to be a simple change

    Pau

    "teabag" wrote:

    On Wednesday, January 27, 2010 5:39 PM
    MikeLV wrote:

    Do I understand this correctly?
    Do I understand this correctly? That after Jan 31, 2011 MS Money will n
    longer get any stock quotes updated? Tracking portfolio value is one of the
    main reasons I use MS Money.

    "teabag" wrote:

    On Wednesday, January 27, 2010 9:57 PM
    Bob A. wrote:

    Agreed teabag.
    Agreed teabag. Yes - I do know that the MS servers carry the options prices,
    and as I had mentioned you can look up the options chains (and prices) when
    adding a new option investment from within MS Money. I guess I am just
    expressing my frustration with the fact that MS Money is slowly becoming less
    and less useful to track investments, and as you mentioned that will be
    capped off by the discontinuation of price downloads in 2011. For now it
    appears that manually entering option prices as I have started doing is the
    only recourse. Very sad. Money is an excellent product for the most part.

    "teabag" wrote:

    On Tuesday, February 02, 2010 11:31 AM
    gcraig wrote:

    OK, glad I found this thread before struggling too long.
    OK, glad I found this thread before struggling too long. Ran into all this
    and does not seem to be a work around. Curiously an older call option I have
    outstanding which has the old format symbol continues to update. Tried to
    recreate the older format for a new call I bought yesterday but it will not take.

    Here is something that works outside of Money. If you have Excel you can
    download the Excel 2003 add in "MS Money Stock Quote for Excel" (I think I
    got it from MSFT web site). It takes the new format and updates correctly.
    Not perfect but at least gets an automated way of doing it.

    "Paul" wrote:

    On Tuesday, February 02, 2010 3:49 PM
    FrankV wrote:

    it is for Excel 2002 and 2003:http://www.microsoft.com/downloads/details.aspx?
    it is for Excel 2002 and 2003:
    http://www.microsoft.com/downloads/...D8-9305-4535-B939-3BF0A740A9B1&displaylang=en

    Frank

    On Tuesday, February 02, 2010 8:31 PM
    gcraig wrote:

    I installed in Excel 2007 and it works fine."FrankV" wrote:
    I installed in Excel 2007 and it works fine.

    "FrankV" wrote:

    On Friday, February 05, 2010 1:08 PM
    gcraig wrote:

    OK, weirdness, today my call options started pricing correctly.
    OK, weirdness, today my call options started pricing correctly. The
    following format for calls starting pricing correctly today in money:

    WGE1221A12.5

    On Wednesday, February 10, 2010 11:29 AM
    Jim Hawley wrote:

    Haven't got it to work - an example please?
    Hi
    Have been struggling trying to get my spreadsheets updated to show options pricing using the new symbology. Have been completely frustrated.
    I think if I saw one example that actually worked it would become instantly clear. You say you got it to work. Can you post the actual excel stockquotes formula that will return a value. Here is an example of one of my old forumula...
    =MSNStockQuote("."&$B7,"Bid","US")
    In these equations, cell B7 would contain the old symbol, for example CATEM or somesuch.
    If you could post an example, any example, that actually returns a value I could figure out what I am doing wrong.
    Thanks

    On Wednesday, February 17, 2010 8:38 PM
    ameridan wrote:

    I stumbled on information that indicates that Money should accomodate the
    I stumbled on information that indicates that Money should accomodate the new
    21-digit symbology for options and felt I had to share it here. If in fact
    it works, the next step will be to get the OFX scripts to obtain the data
    from Yahoo! along with stock quotes so that we will be able to import into
    Money after Microsoft pulls the plug.

    Anyways, check out the link to a slide show from Schwab on how to change the
    option symbol. They do not seem to think there is a 12 digit max...

    http://microsoftmoneyoffline.wordpr...options-symbology-microsoft-money-compatible/

    "Paul" wrote:

    On Wednesday, March 31, 2010 11:19 AM
    Jim Hawley wrote:

    Second request
    In February you stated that the new symbols would work in Excel using the MSNstockquotes addin. I asked for an example so I could see why I was not getting it to work. No reply. Asking again - can you give one example that works for you. I would need the symbol and the formula that refers to that symbol and returns a (any) value.
    Thanks


    Submitted via EggHeadCafe - Software Developer Portal of Choice
    Crypto Obfuscator for .NET - Product Review
    http://www.eggheadcafe.com/tutorial...f8-f5fd987fafb1/crypto-obfuscator-for-ne.aspx
     
    Jack, Apr 30, 2010
    #18
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    7
    Views:
    688
  2. SHos
    Replies:
    0
    Views:
    969
  3. Howard
    Replies:
    1
    Views:
    253
    Cal Learner-- MVP
    Nov 16, 2003
  4. Howard
    Replies:
    0
    Views:
    278
    Howard
    Nov 16, 2003
  5. Jonathan Kamens
    Replies:
    2
    Views:
    476
    Jonathan Kamens
    Jun 20, 2011
Loading...

Share This Page