Download and Keep Track of Stocks in Excel 2007 Prenesite in vztrajati tir od Zaloge v Excel 2007
This article was written by Ta članek je napisal MysticGeek MysticGeek , a tech blogger at the How-To Geek Blogs. , Tech blogger na How-To Geek Blogs.
Microsoft Excel is used by companies and individuals to keep track of and compute virtually anything that requires numbers. Microsoft Excel je uporabljala podjetja in posameznike, da spremljate in izračun skoraj vse, kar zahteva številke. If you are computing financial symbols, did you know there's a way to have Excel automatically update those values online? Če ste računalniški finančni simboli, ste vedeli, da je način, da Excel samodejno posodabljanje teh vrednot na spletu?
You can use smart tags in Excel to keep track of your stock quotes. (Keep in mind you do need an Internet connection for this). With this feature Excel will connect to MSN Money Central to download the information. Lahko uporabite pametne oznake v Excelu, da bi spremljali vaše borzne tečaje. (Imejte v mislih si morate internetno povezavo za to). S to funkcijo Excel bo povezal z MSN Money Central za prenos podatkov.
First we need to enable the smart cell feature by clicking the Office Button \ Excel Options \ Proofing \ AutoCorrect Options and click on the Smart Tags tab. Najprej moramo omogočiti funkcijo pametne celico s klikom na gumb Office \ Excel Options \ Proofing \ samopopravke Možnosti in kliknite na jeziček Pametne oznake. Make sure and place a check next to Financial Symbol. Click OK twice to get back to your worksheet. Prepričajte se in kraj pregled poleg finančne Bollywood. Dvakrat kliknite V redu, da se vrnete na vaš delovni list.
Now that smart tags are enabled all we need to do is enter in our favorite stock symbol using all capital letters (in this instance I am using Microsoft). Now hover the mouse over the lower left corner of the cell until the smart tag appears and click. Select Insert refreshable stock price. Zdaj, da so pametne oznake omogočil vse kar morate storiti, je vstop v naši najljubši Borzni simbol z vsemi velikimi črkami (v tem primeru rabim mikroskop). Zdaj hover miško nad levem spodnjem kotu celice, dokler se zdi pametno oznako in kliknite. Izberite Vstavi posodobljeno ceno delnic.
Now select where you would like the starting cell or you can also choose a new work sheet. Click OK. Sedaj izberite, če želite začetni celico ali se lahko odločite tudi nov delovni list. Kliknite V redu.
Excel will go retrieve the information regarding the stock from MSN Money Central. This will also include hyperlinks to additional information which will open in a separate browser. Excel bo šel pridobiti informacije glede staleža od MSN Money Central. To bo vključevalo tudi povezave do dodatnih informacij, ki se bo odprla v novem brskalniku.
Is this a feature you'd actually use? Je to funkcijo, ki ste jo dejansko uporabi?
Daily Email Updates Dnevni Email Updates
You can get our how-to articles in your inbox each day for free. Lahko dobite našo kako do člankov v vašo mapo »Prejeto vsak dan brezplačno. Just enter your name and email below: Preprosto vpišite vaše ime in e-pošto spodaj:
I'd use it if: Želel uporabite ga, če:
1. 1. I could limit the amount of information which is returned (eg to just the current stock price) I lahko omeji količino informacij, ki se vrača (npr. samo trenutne cene delnice)
2. 2. There was some way to force it to acquire a smart tag for a ticker symbol that it doesn't recognize. Bilo je nekaj tako, da prisili, da se pridobi pametno oznako za Ticker simbol, ki ga ne prepozna.
I love it. I love it. However, I had the same questions as the previous commenter, so I did some research and some experimentation. Vendar, sem imel enaka vprašanja kot prejšnji Commenter, zato sem naredil nekaj raziskav in nekaj poskusov. Here's the results. Here's rezultatov.
I created a multi-sheet workbook. Ustvaril sem več stanja delovnem zvezku. The front sheet is called holdings. Sprednji list se imenuje gospodarstva. The other sheets were created using this tool. Drugi listi so bili ustvarjeni s pomočjo tega orodja. I put in a stock then chose the smart tag as above, but selected “on a new sheet” rather than entering a cell reference. Sem dal na zalogi potem izbrali pametno oznako kot zgoraj, vendar izbran "na nov list" in ne vstopajo celico. Then I renamed that sheet with the stock symbol. Potem sem preimenovan, da list z Borzni simbol.
To insert the current price into the holdings sheet, select the price from the new sheet (Cell E4) and then click on copy. Če želite vstaviti trenutni ceni v gospodarstvih list, izberite ceno novega stanja (Cell E4) in nato na izvod. Go back to the main sheet (Holdings) rt-click in the destination cell and choose paste-special. Pojdi nazaj na glavno stanja (Holdings) rt-kliknite v ciljni celici in izberite pasta-special. Then just click OK to accept the defaults. Nato kliknite V redu, da sprejmete privzete.
For symbols that aren't automatically recognized, pick one of the sheets created with these instructions, then right click and choose “rename or copy” From the window, choose to make a copy after the last. Za simboli, ki niso samodejno prepozna, izberite enega od listov, ustvarjenih s temi navodili, nato pa desno kliknite in izberite "preimenovati ali kopija" Od okna, odloči, da bo po zadnji izvod. It will name it, for example, MSFT(2), if you were copying the MSFT worksheet. To bo ime, na primer, MSFT (2), če ste bili kopiranje MSFT delovni list. Right click and rename it to the stock you want. Desni klik in preimenovati to, da stalež želite. Then right click on the name of the stock (cell A4) and choose to edit query. Nato desni klik na ime parka (celica A4), in se odločite za urejanje poizvedbe. That will open a new dialog box. To bo odprlo novo pogovorno okno.
Click anywhere in the address and scroll all the way to the right (or just hit END) and then edit the symbol name to the one you want. Kliknite kjerkoli v naslovu in se pomaknite vse do desno (ali samo zadeti END), potem pa uredite ime, simbol za tistega, ki ga želite. Click on GO, then on import. Kliknite na GO, nato pa pri uvozu. Your new page will now reflect the stock of your choice. Vaša nova stran bo sedaj odraža stalež po vaši izbiri.
Hope this helps. Hope this helps.
Steve, Steve,
Thank you for the extra info! Zahvaljujemo se vam za dodatne info!
OK, I have a little more to add. OK, imam malo več dodati. When I tried it this morning I found that it didn't update. Ko sem se potrudil, da danes zjutraj sem ugotovila, da ni posodobitev. Here's the fix. Tukaj je pritrditi.
Instead of pasting the cell from one worksheet to another, a cell reference is required. Namesto lepljenje celic iz enega delovnega lista na drugega, je potrebno celico. (Excel calls it a “3D reference” in case you want to read more) (Excel poziva, da "3D sklicevanje" v primeru, da želite prebrati več)
Assume the main sheet is called holdings and the stock data sheet is called MSFT. Predpostavimo glavna uzda se imenuje gospodarstev in stanja zalog podatki se imenuje MSFT. In the target cell in the holdings sheet use this formula =MSFT!e4 (That's an equal sign, the stock symbol, an exclamation point and then the cell reference.) V ciljni celici v gospodarstvih stanja uporabo te formule = MSFT! E4 (To je enačaj, simbol delnice, točka klicaj in nato celico.)
That will reference cell e4 (previous close) in the holdings sheet. To bo referenčni celici e4 (prejšnji blizu) v gospodarstvih stanja. When you start up on any day, use CTL-ALT-F5 to refresh all sheets. Ko skočiti na kateri koli dan, uporaba CTL-ALT-F5 za osvežitev vseh listov. Depending on your security settings, you might need to give permission to access an external source. Glede na vaše varnostne nastavitve, boste morda morali dati dovoljenje za dostop do zunanjega vira.
If you want intraday trading, use cell d4 instead (last price, delayed 20 mins) Če želite čez dan trgovanja, namesto tega uporabite celico D4 (zadnja cena, z zamudo 20 min)
Hope this helps. Hope this helps.
Steve Steve
Moderator: please delete the 8:59 am reference and use the following instead. Moderator: Prosimo, izbrišite 8:59 reference in uporaba naslednjih namesto tega. I found two edits that might cause confusion. Našel sem dva urejanja, ki bi lahko povzročila zmedo.
Sorry for the extra work, but thanks for the underlying tip! Oprosti za dodatno delo, ampak hvala za osnovni tip!
OK, I have a little more to add. OK, imam malo več dodati. When I tried it this morning I found that it didn't update. Ko sem se potrudil, da danes zjutraj sem ugotovila, da ni posodobitev. Here's the fix. Tukaj je pritrditi.
Instead of pasting the cell from one worksheet to another, a cell reference is required. Namesto lepljenje celic iz enega delovnega lista na drugega, je potrebno celico. (Excel calls it a “3D reference” in case you want to read more) (Excel poziva, da "3D sklicevanje" v primeru, da želite prebrati več)
Assume the main sheet is called holdings and the stock data sheet is called MSFT. Predpostavimo glavna uzda se imenuje gospodarstev in stanja zalog podatki se imenuje MSFT. In the target cell in the holdings sheet use this formula =MSFT!e4 (That's an equal sign, the source sheet name, an exclamation point and then the cell reference.) V ciljni celici v gospodarstvih stanja uporabo te formule = MSFT! E4 (To je enačaj, ime lista vir, točka klicaj in nato celico.)
That will reference cell e4 (previous close) in the source sheet. To bo referenčni celici e4 (prejšnji blizu) v viru stanja. When you start up on any day, use CTL-ALT-F5 to refresh all sheets. Ko skočiti na kateri koli dan, uporaba CTL-ALT-F5 za osvežitev vseh listov. Depending on your security settings, you might need to give permission to access an external source. Glede na vaše varnostne nastavitve, boste morda morali dati dovoljenje za dostop do zunanjega vira.
If you want intraday trading, use cell d4 instead (last trade, delayed 20 mins) Če želite čez dan trgovanja, namesto tega uporabite celico D4 (zadnja trgovina, z zamudo 20 min)
Hope this helps. Hope this helps.
Steve Steve
Yes I'd use it, but how do you do this in EXCEL2002 Da bi jo uporabljam, vendar kako to naredite v EXCEL2002
it doesn't seem to work with other symbols like APPL or GOOG ! se ne zdi, da dela z drugimi simboli, kot so APPL ali GOOG! (only MSFT ??) (samo MSFT?)
I tried also currencies USDEUR but no reaction from the smart tag option! Poskušal sem tudi valute USDEUR vendar nobene reakcije od možnosti pametnih oznak!
Ludo, Kocke,
This is a great point. To je velika točka. I have also entered in various stocks that did not work. Prav tako sem začel v različnih zalog, ki niso delovale. I am not one to start claiming “conspiracy” … however … this does seem odd. Nisem eden za začetek trdijo "zaroti" ... ... vendar pa to ne zdi čudno.
The Geek and I will look into this and see if we can get a better explanation. Geek in bom videti v to in videli, če lahko dobimo boljšo razlago. Thanks for your comment! Hvala za vaš komentar!
Quote by Ludo: “it doesn't seem to work with other symbols like APPL or GOOG !” Citat z Ludo: "ne zdi, da dela z drugimi simboli, kot so APPL ali GOOG!"
Really it doesn't work with APPL, too bad Apple's symbol is AAPL (not APPL) and it does work stupid. Res ne dela z APPL, simbol Škoda Apple je AAPL (ne APPL) in deluje neumno.
Hi there – having problems getting UK prices to work, such as GB:VOD – any thoughts? Živjo - ob naloga pridobivanje UK cene za delo, kot so GB: VOD - vse misli?
I would use this A LOT if you would help me with a “how-to” for Mac Excel 2004. Jaz bi uporabila teh LOT, če bi mi lahko pomagaš z "kako-do" za Mac Excel 2004.
Can't seem to find the same tools in the Mac version of Excel… Ne morem se zdi, da bi našli istih orodij v Mac različici Excela ...
THANKS! Hvala!
can i download from yahoo finance site if possible, kindly suggest, coz i need indian stocks to be downloaded. moči jaz travnato gričevje s strani yahoo finance, če je mogoče, prisrčno kažejo, bratranac rabim indian zalog ki jih lahko prenesete.