GN100 wrote:
Itsallaguess wrote:
Thanks for the prompt reply but I can't get those to work.
I really don't know what to try them in as they don't fit into the new Beta HYPTUS.
I appreciate that you guys have got more than enough work on your hands at the moment, so let's leave it for now. Maybe it could be incorporated later in to the HYPTUS when everything has settled down.
Hi GN100,
If you download
eventide's '
GETDATA' add-in for Excel from here -
https://www.lemonfool.co.uk/viewtopic.p ... 190#p93095
You can then use the add-in to retrieve any quote you like, including the above two currency levels.
For the two currency levels above, you'd just enter the following into two cells on a spreadsheet -
=getdata("GBPEUR=X")
=getdata("GBPUSD=X")
Doing so initially, with the add-in activated, will show the cells containing the following temporary text -
::queued::
If you then right-click your mouse, the add-in should have given you an additional context-menu option that says this -
TLF Refresh
If you select that option, the add-in will retrieve the appropriate quote data, and fill in the cells with the relevant information as explained at the bottom of
eventide's post on the linked thread above.
Leaving out the second '
field' selection option, as we've done with the above two examples, will simply retrieve the '
last price', which may or may not be suitable for your needs.
The following options are also available for the second '
field' options if required (
from the above linked post) -
Notes on Field Selection (case insensitive) in the function
1, "nm", "name": RETURNS SECURITY NAME
2, "b", "bid": RETURNS BID PRICE
3, "a", "ask", "offer": RETURNS ASK PRICE
4, "l", "last": RETURNS LAST PRICE
5, "c", "chg", "change": RETURNS CHANGE
6, "prvcls", "close", "previousclose": RETURNS PREVIOUS CLOSE
7, "daylow", "dl": RETURNS LOW OF DAY
8, "dayhigh", "dh": RETURNS HIGH OF DAY
9, "52wk_low", "52wl": RETURNS 52 WEEK CLOSING LOW
10, "52wk_high", "52wh" RETURNS 52 WEEK CLOSING HIGH
11, "delay", "exchangedelay": RETURNS EXCHANGE DELAY IN MINUTES
12, "ccy", "currency": RETURNS CCY OF QUOTES (GBP, GBp, USD etc)
13, "type", "quotetype": RETURNS SECURITY TYPE (STOCK, CURRENCY, INDEX, FUTURE ETC)
So, for instance, if we wanted to get the '
bid' price for
Vodafone, we'd use the following in a cell on your spreadsheet with the downloaded '
Getdata' add-in -
=getdata("VOD.L", "b")
which currently returns the figure "
212.5" after a '
TLF Refresh' process has been carried out.
Hope the above helps you, and also anyone else that would like to use the fantastic, and very versatile '
getdata' add-in from the above link in their own spreadsheets.
It can be used completely separately from the HYPTUSS tool, so please give it a go and see if it helps.
It can handle a huge amount of tickers, in many different cells on your spreadsheet, and is lightning fast when retrieving the price data, so anyone wanting to carry out this type of price-retrieval will do well to give the above a go and familiarise themselves with the fairly simple process.
Cheers,
Itsallaguess