MSN Stock Quotes Excel Plugin Broken
Apr 14, 2006
I have been using MSNStockQuotes on a few computers without any problems for months.
Now (in the last day or so) , when I press "update Quotes" on any of the computers, I get a "Failed to get requested Data" message. I can often "trick" it into getting the quotes by deleting a bunch of the quotes, then choosing Edit-Undo, which then fetches the quotes properly, but even that fails some of the time (same displayed message).
This happens even with older copies of my spreadsheet that used to work perfectly.
Are others having problems with MSNStockQuotes Excel Plugin?
View 13 Replies
ADVERTISEMENT
Aug 7, 2012
What is the easiest way to have a cell update with real time stock quotes for a particular stock?
View 4 Replies
View Related
May 4, 2009
I inted to invert stock quotes from newest to oldest but I can't cope with it.
How to invert for example numbers like 2, 10, 3, 15, 1 into the form of 1, 15, 3, 10, 2 ?
View 9 Replies
View Related
Jul 5, 2014
I would like to create an Excel worksheet with links to external real-time sources for stock quotes so that I can evaluate information based on real-time stock quotes.
View 1 Replies
View Related
Feb 11, 2013
Attempting to match acct #s on source sheet with account numbers on Template but the numbers on the source are = to the cell value while the numbers on the template are equal to finding the source cell value in the template. Let me explain with code.
Set Source value:
Code:
Set FirstIO = zfir.Range("e8")
Set Template value:
Code:
Set CheckIO = Range("Accounts").Find(IO, LookIn:=xlValues)
When I get here:
Code:
If FirstIO = CheckIO.Value Then
I get a mismatch because
FirstIO = 3333333 and CheckIO = "3333333"
How do I make these 2 values Match?
View 2 Replies
View Related
Jan 13, 2014
I've created a spreadsheet it is for tracking attendance etc broken down into percentages.
What I'm looking to do is if someone doesn't attend this doesn't get added to the attendance total.
I've attached a screen shot so you can see what I mean.
excel.PNG‎
View 7 Replies
View Related
Jun 8, 2010
I have Excel 2007.
Undo / Redo - they do NOT work properly after a save. Before a save, its great - I can undo / redo many many changes.
After a save, I can only undo 2 changes, but the worst thing is it ONLY REDOES ONE of them.
I work by saving very regularly, then I go and look at something on the sheet, and then use Undo / Redo to get back to where I was last updating the sheet and see what I had just been working on, especially if its a few minutes in between.
However, when I do that now, it undoes my last change, but the redo has been lost. So I do:
change, save, undo, redo
and it just doesn't do the redo. The redo button is greyed out.
If I do:
change, change, save, undo, undo, redo, redo
the first redo works, and the second fails as the redo has been lost.
It seems pretty basic that undo / redo should be symmetrical but they aren't, at least now.
I would rather just not have undo after save at all than this broken version.
Why are they putting so much stuff in Excel but they can't even get one of the most basic parts of spreadsheets correct - such as undo / redo, and the ability to open independent spreadsheets without having to change things in the registry (which I have had to do so I can work on two spreadsheets in a semi-sane fashion, undo being shared across your sheets otherwise). MS needs a back to basics...
View 5 Replies
View Related
Dec 31, 2012
I have everything else like it is supposed to be, but in one cell a word is broken. I have tried everything and gone back through the tutorials. Excel 2007.
View 6 Replies
View Related
Nov 21, 2006
I'm trying to set up a macro to be assigned to a button to copy the text in a cell into an application which uses similar text capabilities to Notepad.
The simple macro of:
Range("D5").Select
Selection.Copy
... results in the text of the cell being copied to the clipboard with quotation marks before and after the text. I can manually enter the cell, select the text, the copy it... but this process can not be recorded in a macro - I can edit the cell and copy the text but when leaving the cell it gives the error "unable to record".
Is there any way I can copy the text to the clipboard without getting these quotes?
View 9 Replies
View Related
Aug 17, 2006
When I opened up the excel file, it prompted me to plugin password. There is no read-only option too. how can i open it up, i tried download some password
protector software to crack it, it is only limited demo which mean can open that file partially not full indeed
View 3 Replies
View Related
Jan 8, 2014
I have created a stock sheet on Sheet1, i have say 100 items and each item has a min and max stock order. Once the item hits a min low, the last cell (O) will display an order needs to be placed.
I was wondering if there way a way that on sheet2, it can calculate all the data on sheet1 and if there is stock that needs to be ordered, it will appear on sheet2?
This way i can just print sheet2 and send it to the supplier without having the entire 100 items displayed -if it does not need to be ordered?
View 7 Replies
View Related
Dec 1, 2013
I have a macro that imports text file and puts a comma after each number (alphanumeric also). I have tried to change it to put single quote around the number and comm afterwards.
Text file listing
123
456
789
When I run my marco I get the following
123, 456, 789
which is what I want...
Now I want the same text to have single quotes around the data example:
'123', '456', '789'
All that I have tried to adjust keeps missing single quote at the front end and also missing the single quote at the rear end example: 123', '456', '789
Here is the vba I'm running
Sub GetserialNumbers()
Dim FileNum As Long, PathAndFileName As String, TextFromFile As String
Const Delimiter As String = ", "
[Code].....
Whe I run this I have to select the text file to get. I keep it in my documents as a quick access. I'm using MS VBA 6.5 Excel 2007 Windows 7 Enterprise.
View 2 Replies
View Related
Dec 21, 2011
I'm using Excel 2010.
A formula I am using is outputting "0" instead of the expected value. Upon evaluating the formula I realized that this was because some of the values - years, in this case - had quotes around them while others did not. Please see the image below for the screenshot of the evaluation.
These values - the years - are being evaluated in the following formula.
Code:
=SUM(
IF(inventory!$F$3:$R$3=$A3,
IF(inventory!$B$4:$B$56=$G$1,
IF(inventory!$D$4:$D$56=$G$2,
inventory!$F$4:$R$56))))
This formula references the following sheet (an excerpt from that sheet). You can also see the formulas found in the cells causing the problem.
*ABC5212/20/20102010Adjustments53*20112011543/17/20112011Carwen Printers559/9/20112011Adjustments569/9/20112011Copeland Printing
Spreadsheet FormulasCellFormulaB52=IF(A52="",C52,YEAR(A52))B53=IF(A53="",C53,YEAR(A53))
B54=IF(A54="",C54,YEAR(A54))B55=IF(A55="",C55,YEAR(A55))B56=IF(A56="",C56,YEAR(A56))
I suspect that the problem is being caused by the output of the formula in these cells. If I simply type in "2011" instead of using the formula in B52:B56, then the first formula in the code section above does not have a problem.
How I can reconcile this?
View 2 Replies
View Related
May 25, 2008
I am fairly new to VBA / Excel programming. I have been trying to write a report out of excel from our company DB (SQL2005). The database is run by our frontend accounting application - so i cant mess with it at all, must only run queries.
I need to pull the last 24 months of stock sales data(by stock code or category) out of our DB into excel by counting transactions on Customer Invoices / credits. Into a table as follows..
Stock Code--Month1-Month2-Month3
ABC1----------43------33------19
ABC2-----------2------10------25
I have managed to make a script that fullfills this need but it takes about 15 minutes to run(Due to having to loop many times per item/ per month)....
I was just wondering if anyone had any tips / advice on different ways to do this..??? Ive had a quick look at Pivottables but havent gone very far in, maybe they are the answer, but this amateur does not know.
View 10 Replies
View Related
Nov 13, 2003
rows 1 and 2 are used for my parameters.
row 1 being used for descriptions: Ticker Symbol, Start Date, End Date, and pulling in the close price and volume for each ticker symbol with the selected date range. row 2 being used for entering the parameter info.
row 2 Would read (as an example)
MSFT, 1/1/2002, 1/1/2003, close price, volume.
For each ticker in column A, add a separate wksheet named the ticker symbol and pull in the corresponding info.
So the final result for MSFT, would be an added wksheet named MSFT, with the colums headers being the close and volume, and the rows being the date parameters set in row 2.
all using yahoo finance.
View 9 Replies
View Related
Mar 16, 2014
Below are the weekly closing prices for a stock market index. I'm looking to use conditional formatting to highlight in green "buy" signals and in red "sell" signals.
Buy Signal: If the index rises 4% above any previous low point.
Sell Signal: If the index falls 4% from any previous high point.
DateAdj Close
3/10/201472.16
3/3/201473.55
2/24/201472.83
2/18/201471.92
2/10/201471.43
[code].....
In the above example a Buy Signal is generated on 1/13/2014 because the market closes 4% above the low of 68.24 on 12/9/2013.
[URL]
View 4 Replies
View Related
Jul 15, 2013
setting up a stock ordering system in Excel. I have been sent a spreadsheet with about 400 items I've ordered before and about 15 columns of descriptions which include the name, category of item, manufacturer, cost, number etc.
I would like to set up a simple Excel spreadsheet which staff can use when they want to order some stock, which will automatically fill in the adjacent cells with the product category and unit cost, once the name has been typed into the first cell. Once I add the SUM formula I can therefore have an immediate total of how much each staff member is spending on stock that week, without having to look at the invoice I get back from the supplier.
I know Excel has a predictive text style feature (autocomplete?) but I don't know how to get it to automatically fill several cells in a row with data that is linked to the first cell.
View 14 Replies
View Related
Feb 25, 2011
I am using the the stock chart and I would like there to be a horizontal line across the chart with a y-axis of the opening price. In the end I want this to be in VBA but how to do this manually I should be able to put it in loop of data that will produce many charts with a horizontal line starting at the day opening.
I have tried to add a new series to the chart but I'm using the Candle stick stock chart and the new series comes out as a vertical not horizontal line. I read about using a secondary horizontal axis but all the tutorials I find are in Excel 2003 and they donlt line up well with Excel 2007.
I found this link on charts with horizontal lines but again they are in 2003 and I'm using a candle stick stock chart not a scatter chart. [URL]
View 6 Replies
View Related
Apr 15, 2014
I have Stock market daily data for last 30 yrs. for my cycle analysis a macro which would insert date which is missing
View 2 Replies
View Related
Aug 1, 2014
Currently I am using MS office 2000 premium. I would like to implement real-time stock prices (i.e. ticker MSFT) from the Nasdaq website (NASDAQ Stock Market - Stock Quotes - Stock Exchange News - NASDAQ.com) into a single cell, so that this cell shows the current stock price only.
By a click on the hyperlink symbol in the excel sheet I entered the following information... Microsoft Corporation (MSFT) Real-Time Stock Quote - NASDAQ.com and clicked the OK button.
Instead of receiving the real-time stock price information directly into the single cell, a new window opens with the Nasdaq website and all kinds of information that is not needed.
View 2 Replies
View Related
Jan 14, 2014
I need to plot various data on top of stock charts.
This data could be irregular in date: it could be weekly, or simply random.
To plot this data by itself requires a Scatter Chart.
From what I know so far, you CANNOT DO THIS.
However, I suspect this could be done if I build a Stock Chart from scratch using a Scatter Chart.
Error bars can be used to make the tails, however, I don't know how they built the body bar which has the characteristics of a bar (border, and interior.)
But since I don't really need those two characteristics, I just need a wider error bar line that is provided in the chart edit window. I'm guess through a macro, there are wider line widths assignable.
View 5 Replies
View Related
Mar 4, 2008
I've got an excel file with LOTS of links... it's a sort of 'dashboard' that draws in data from all the individual data files in the company.
Recently, when I open the file it's telling me "this file contains one or more links that cannot be updates".
So... as I usually would, I use my 'find links' add in to find anything with a #REF in it... nothing.
Go into edit links and manually update each link... and they all update with no issue.
I just cannot find anything that's broken!
View 9 Replies
View Related
Oct 9, 2009
So my macro goes through about 30 workbooks--opens them, updates the links, saves, closes. It would work flawlessly except I have to stop and click "continue" when this message pops up for most of the workbooks:
"This workbook contains one or more links that cannot be updated....etc."
About 90% of the workbooks have bad links somewhere (I think in the insert>names...but they're not my workbooks so i can't delete all the names). Since I can't find the bad links, I would like a visual basic script that will automatically click "continue" everytime so that the macro runs its course without me having to do anything. Does anyone know how to do this?
View 4 Replies
View Related
May 10, 2013
I have inherited a large spreadsheet. When it opens I get a warning message "This workbook contains one or more links that cannot be updated". When I click "Edit Links" the dialoge tells me that it is looking for a file in a folder called "All Daily Tasks". now I know that this folder no longer exists. I have found all the cells that had formulae refering to it, and pointed them in the new, correct folder, but I still get the warning message. I have cleared all Named Ranges, so that isn't the problem. And I have done a search for "All Daily Tasks", but this has come up blank. I know I can break the link, but I want to know where the link is, in case it needs updating. How do I find the cell with the "link that cannot be updated" if the search facility can't locate it?
View 6 Replies
View Related
Jun 12, 2013
I have a file that's supposedly taking some of its values from another file. I say supposedly because when I follow the directory path, its not in there. I think I did find the file its referencing (same name, now in a subdirectory of the original reference). But I changed a value in the file being referenced and it didnt change anything in the active sheet.
I imagine the previous paragraph is a bit confusing so let me say it in another way.
I'm working on a file named A. In that it refers to a file named B, in my DocumentsFinancial directory.
In the DocumentsFinancial directory there is no file named B. However I did find a file named B in DocumentsFinancialWork.
I assume this is what A is referring to. But when I changed the relevant value in B (which does equal the value in A), the value in A didnt change.
I do remember in certain exceptions, Excel files have to be refreshed, I think when manual calculations are on. I'm not sure how to check for that, but I did go to the Data Tab and hit Refresh All.
View 5 Replies
View Related
Mar 13, 2009
Function MultLookup(Rng As Range, lookup_value As String, col_offset As Integer, Optional num_return As Integer) As Variant
Dim myArray(), cnt, cell
For Each cell In Rng
If cell.Value = lookup_value Then
cnt = cnt + 1
ReDim Preserve myArray(1 To cnt)
myArray(cnt) = cell.Offset(0, col_offset).Value
End If
Next cell
If num_return = 0 Then
For i = 1 To cnt
If i = 1 Then
MultLookup = myArray(i)
Else
MultLookup = MultLookup & ", " & myArray(i)
End If
Next i
ElseIf num_return > 0 And num_return
View 9 Replies
View Related
Aug 7, 2009
This file pulls totals from external links. The way I have it set up is that every month our log is saved to a naming scheme involving the date, then a fresh log is created for the current month. So, for each month I have "log mm-yyyy".
Now, the chart file is a thirteen month rolling chart (meaning every month it must show the thirteen most recent month's totals). I have created a macro to automatically update the links, based on an input in cell A:1 (meaning you can enter a date in the past and view the thirteen months previous). The problem is that we have only been doing the log for 10 months. So, when the macro runs to update the links, and it gets to months 11 through 13, it pops up a window for the user to manually browse for the missing(non-existent) files. There are quite a few cells that contain links to various information on these logs. I get a prompt for each cell and have to click "cancel". Once I have clicked cancel through all of the broken links, then everything works great.
My question (after all that) is, is there a way to suppress the prompt for the user to search for the missing file? Like I said, this chart is for management, and they shouldn't have to click cancel a dozen times just o look at a chart. If the file doesn't exist, then just break the link.
Obviously once the next three months are over, this problem will disappear, but in the mean time I need a solution.
View 6 Replies
View Related
Nov 22, 2009
I need to know what driver led a given lap of a given race (Col. G). Attached is my attempt. Something to consider is I need a formula that can be pasted down Column G as from track to track, from race to race the # of laps will not be the same. The number of drivers that led a given race will not be the same.
I have an array formula in cells of Column G for the # of laps in a given race (i.e. if a race was 100 laps it would go from G3-G100). I ran it down to 500 just to cover myself.
Column G: { =INDEX($E$3:$E$500, MATCH($F3,VALUE(LEFT($D$3:$D$500,FIND(" ",$D$3:$D$500)-1)),1))}
…it kinda works, but for some reason when it comes to lap 251 it gives me a #N/A error. It gives me the correct driver for lap 250 & 252 and all other laps but not lap 251. Also, a minor inconvenience is that I have to put a space after the first number & if at all possible I don’t want to have to do that.
I would love a macro where all I need to do is paste Column A, press a command button, & the macro does everything for me but that’s probably asking a lot. I know how to record a macro but don’t know anything about VB.
Column D & F have to be formatted as text. It has to be text format or when I cut Column B to Column D it changes some numbers to date (i.e. 1-2 becomes January 2nd).
Column B:
=RIGHT(A3,LEN(A3)-FIND("*",SUBSTITUTE(A3," ","*",LEN(A3)-LEN(SUBSTITUTE(A3," ","")))))
Column C:
=LEFT(A3,(LEN(A3)-LEN((RIGHT(A3,LEN(A3)-FIND("*",SUBSTITUTE(A3," ","*",LEN(A3)-LEN(SUBSTITUTE(A3," ",""))))))))-1)[/size]
View 8 Replies
View Related
Sep 26, 2006
how to create a column chart with a broken y-axis? And if this is possible, is it also possible to have 2 gaps in the y-axis. I have several countries in which i gathered information about their (expected) population sizes over time (2003 - 2011). For each country i want to make a chart in which their population size is shown over time. In order to compare these countries i want these charts all having the same y-axis scale (which expresses the population size). To be able to do this i want to put some gaps in the y-axis. I think i need 2 gaps because i can divide the countries in "low population" countries (2-3 million), "moderate population" countries (7-14 million) and "high population" countries (> 30 million). I attached a sample file to make things more clear! I hope somebody knows more how to do it!
View 2 Replies
View Related
Apr 5, 2007
I'm trying to create some graphs with broken lines from lookup formulae, essentially what is explained at http://www.ozgrid.com/Excel/broken-line.htm. My problem, however, is that my charts are rather more complicated than those outlined, having multiple series that move across the page and overlap a lot of the time. This prevents the suggestion there from being an elegant or even sufficient solution. Does anyone know of a better way of doing this that might work for my situation?
View 9 Replies
View Related
