Re: [GNC] Online quotes for a mutual fund

2022-09-01 Thread Geoff 

Hi Ruaraidh

I think you are out of luck with Gilts.  I have checked the web sites of 
Morningstar, Financial Times, Alphavantage, and Yahoo Finance; and none 
of them seem to be able to provide price data for Gilts securities.


I note that you can obtain price data directly from the LSX:-
https://www.londonstockexchange.com/stock/TR29/united-kingdom/company-page
However none of the Finance Quote modules currently use the LSX as a 
data source.



Regards

Geoff
=

On 24/08/2022 6:59 pm, Ruaraidh Sackville Hamilton wrote:
Finding the right source and symbol seems a challenge! For several years 
I've been successfully getting quotes through fq using the single source 
"Alphavantage, US" for single UK equities, and the multiple-source "U.K. 
funds" for UK funds. However, I can't find anything that works for UK 
Treasury gilts (e.g. ISIN GB00BJMHB534, symbol TR29), even though they 
appear on the LSE and FT websites. I've tried all sources listed in the 
GC help system that seem reasonably possible. Some examples:


C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump alphavantage TR29.L
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds GB00BJMHB534
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump mstaruk GB00BJMHB534

all generate the error code
** This stock quote cannot be used by GnuCash!

Does anyone have any experience with this?

Regards,

Ruaraidh

On Mon, 17 May 2021 at 01:55, Geoff > wrote:


Hi Jacob

It looks like the Financial Times' Funds service will provide prices:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds SE0005993078
      symbol: SE0005993078         <=== required
        date: 05/12/2021           <=== recommended
    currency: DKK                  <=== required
        last: 237.96               <=\
         nav: 237.96               <=== one of these
       price: 237.96               <=/
    timezone:                      <=== optional



Regards

Geoff
=

On 17/05/2021 7:35 am, Jacob Larsen wrote:
 > Hi
 >
 > I am trying to get online quotes for a few mutual funds I am
tracking,
 > but I am having no luck, mostly because they don't really have any
 > symbols, only ISINs. Anyone have any ideas on how I proceed on
this one?
 >
 > They are not available on Yahoo, but I found them on a few others
 > without succeeding gnc-fq-dump with any of them, this is one of them:
 >
 >
https://markets.ft.com/data/funds/tearsheet/historical?s=SE0005993078:DKK

 >
 >
https://www.morningstar.se/se/funds/snapshot/snapshot.aspx?id=F0TH8X

 >
 > https://www.investing.com/funds/nordnet-superfonden-danmark

 >
 >
 > /Jacob
 >
 > ___
 > gnucash-user mailing list
 > gnucash-user@gnucash.org 
 > To update your subscription preferences or to unsubscribe:
 > https://lists.gnucash.org/mailman/listinfo/gnucash-user

 > If you are using Nabble or Gmane, please see
 > https://wiki.gnucash.org/wiki/Mailing_Lists
 for more information.
 > -
 > Please remember to CC this list on all your replies.
 > You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Online quotes for a mutual fund

2022-08-24 Thread Ruaraidh Sackville Hamilton 
Finding the right source and symbol seems a challenge! For several years
I've been successfully getting quotes through fq using the single source
"Alphavantage, US" for single UK equities, and the multiple-source "U.K.
funds" for UK funds. However, I can't find anything that works for UK
Treasury gilts (e.g. ISIN GB00BJMHB534, symbol TR29), even though they
appear on the LSE and FT websites. I've tried all sources listed in the GC
help system that seem reasonably possible. Some examples:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump alphavantage TR29.L
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds GB00BJMHB534
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump mstaruk GB00BJMHB534

all generate the error code
** This stock quote cannot be used by GnuCash!

Does anyone have any experience with this?

Regards,

Ruaraidh

On Mon, 17 May 2021 at 01:55, Geoff  wrote:

> Hi Jacob
>
> It looks like the Financial Times' Funds service will provide prices:
>
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds SE0005993078
>  symbol: SE0005993078 <=== required
>date: 05/12/2021   <=== recommended
>currency: DKK  <=== required
>last: 237.96   <=\
> nav: 237.96   <=== one of these
>   price: 237.96   <=/
>timezone:  <=== optional
>
>
>
> Regards
>
> Geoff
> =
>
> On 17/05/2021 7:35 am, Jacob Larsen wrote:
> > Hi
> >
> > I am trying to get online quotes for a few mutual funds I am tracking,
> > but I am having no luck, mostly because they don't really have any
> > symbols, only ISINs. Anyone have any ideas on how I proceed on this one?
> >
> > They are not available on Yahoo, but I found them on a few others
> > without succeeding gnc-fq-dump with any of them, this is one of them:
> >
> >
> https://markets.ft.com/data/funds/tearsheet/historical?s=SE0005993078:DKK
> >
> > https://www.morningstar.se/se/funds/snapshot/snapshot.aspx?id=F0TH8X
> >
> > https://www.investing.com/funds/nordnet-superfonden-danmark
> >
> >
> > /Jacob
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Online quotes for a mutual fund

2021-05-17 Thread jacob 

On 2021-05-17 21:29, ja...@larsen.net wrote:
This suggests that the issue is with my setup and not the sources as 
such.


Some more googling finally found me this one: 
http://gnucash.1415818.n4.nabble.com/GNC-Finance-Quote-sort-of-works-almost-td4724226.html


So it turns out that I need to install the unreleased master branch of 
Finance::Quote for this to work, since ftfunds have changed URL, and is 
broken in the latest v1.49 version. I cloned 
https://github.com/finance-quote/finance-quote.git, then copied 
lib/Finance/* to /usr/local/share/perl/5.26.1/Finance/ where my 
Finance::Quote is installed. I then additionally installed these from 
cpan: Web::Scraper, Spreadsheet::XLSX, HTML::TokeParser::Simple.


And now I am able to use the online quotes for all these funds. Thanks.

/Jacob
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Online quotes for a mutual fund

2021-05-17 Thread jacob 

On 2021-05-17 02:53, Geoff wrote:

It looks like the Financial Times' Funds service will provide prices:


Thanks for checking this. I get this for the same command, but verbose:

$ gnc-fq-dump -v ftfunds SE0005993078
Finance::Quote fields Gnucash uses:
symbol: SE0005993078 <=== required
  date: ** missing **<=== recommended
  currency: ** missing **<=== required
  last: **missing**  <=\
   nav: **missing**  <=== one of these
 price: **missing**  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock SE0005993078

stock   field  value
-   -  -
SE0005993078   errormsg: Error - failed to find a price
SE0005993078   last: **missing**
SE0005993078   name: *** UNKNOWN ***
SE0005993078nav: **missing**
SE0005993078  price: **missing**
SE0005993078 source: 
http://funds.ft.com/UK/Tearsheet/Summary?s=SE0005993078

SE0005993078success: 0
SE0005993078 symbol: SE0005993078


This suggests that the issue is with my setup and not the sources as 
such. Would you mind helping me out and send the verbose output from a 
working system?


I have run "sudo gnc-fq-update" before this, and it has ensured than I 
am running Finance::Quote v1.49. It did warn about my perl version being 
v5.26.1, which is the version from Ubuntu 18.04.


I am also running Gnucash 4.5 which I have compiled from sources. So I 
could use a couple of pointers for debugging this.


/Jacob
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Online quotes for a mutual fund

2021-05-16 Thread Geoff 

Hi Jacob

It looks like the Financial Times' Funds service will provide prices:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump ftfunds SE0005993078
symbol: SE0005993078 <=== required
  date: 05/12/2021   <=== recommended
  currency: DKK  <=== required
  last: 237.96   <=\
   nav: 237.96   <=== one of these
 price: 237.96   <=/
  timezone:  <=== optional



Regards

Geoff
=

On 17/05/2021 7:35 am, Jacob Larsen wrote:

Hi

I am trying to get online quotes for a few mutual funds I am tracking, 
but I am having no luck, mostly because they don't really have any 
symbols, only ISINs. Anyone have any ideas on how I proceed on this one?


They are not available on Yahoo, but I found them on a few others 
without succeeding gnc-fq-dump with any of them, this is one of them:


https://markets.ft.com/data/funds/tearsheet/historical?s=SE0005993078:DKK

https://www.morningstar.se/se/funds/snapshot/snapshot.aspx?id=F0TH8X

https://www.investing.com/funds/nordnet-superfonden-danmark


/Jacob

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.