Re: Download daily data from webpage and plot them into graphs
Can access not be used as my office computer does not have access.
We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
Re: Download daily data from webpage and plot them into graphs
Can access not be used as my office computer does not have access.
Re: Download daily data from webpage and plot them into graphs
Hi
It is actually 3rd July 2005. Different Date format.
Oh ... never used access before plus SQL - Does anyone have any sample of how this will work ?
Re: Download daily data from webpage and plot them into graphs
Thanks. BUt I do not know how to plot the graph of each Unit Trust and to input their daily data?
Re: Download daily data from webpage and plot them into graphs
Anyone can help here?
Hi Guys,
Have not been in here for a long time.
Need some help.
I have a webpage where I want to download the daily data from,
http://www.dbs.com/ratesonline/shut.html
and I want it to be inputted into Excel so that I can call up its graph
X Axis - Date
Y Axis - Price
base on the name of the Unit Trust.
How can I do it? Can the data be downloaded using "Import External Data" function?
How can it be inputted as a daily data?
How can it be plotted as a graph?
Thank you guys in advance.
Re: Vlookup fails on a column when the numbers are the same
But the columns are already formatted to Number but it still does not work - Please assist.
Hi
Can anyone help?
I did a vlookup as per the excel sheet.
In the Original column, the vLookup fails to reflect the data range but in the retype column the vlookup succeeds as can be seen in the excel spreadsheet attached.
Please assist.
If I do a F2 and Enter on the Original column, the vlookup works. Am I missing something here?
Hi
I have a problem.
There may be 3 things in a cell
AU$1.00
GBP1.00
$1.00
The prices may change but the currency is the same...
How can I do a IF function or any other functions that will output a number say
1 if its AU$
2 GBP
3 $
How can I do it?
Re: Setup a cell that can only have 8 characters
Oops sorry I got what you meant ;p
By the way, if I want to copy data validation to ALL cells - Can it be done with a copy and paste special?
Re: Setup a cell that can only have 8 characters
Thanks for that but can it be done on the actual cell so that a error prompt will come up when a user tries to type in 9 chars?
Hi
How can I set a cell so that if a user inputs 7 char or 9 char - it will be an error - only if 8 char are input, then it will allow it to go through
Re: Share Outlook email between 2 computers network by a router
Anyone can help please
hi
I have a problem. I would like to share my outlook emails between 2 computers so that more than 1 user can access my email account using Outlook and actually answer the emails.
however, I want those emails that has been answered to have the Replied Tag and also the sent message be saved in both computers.
How can I do it?
Thanks and any suggestions would be appreciated on how to share outlook AND Outlook express between 2 computers connected by a router.
Hi
Is there a way to check when a cell is Last updated?
A Macro to do it where a date is added so that I know when I last updated a certain CELL?
I would prefer it does not appear in the cell itself.
Any help?
Re: Formulae to show Hyperlink?
Hi thanks for the reply.
However, I want to SHOW the Hyperlink embedded in the cell in ANOTHER cell.
Is there a formulae for it?
Hi
Is there a formulae to show the Hyperlink from a column of links in excel
Say Yahoo - then a formulae will show http://www.yahoo.com
Please help