So this is an introduction to Drush for site builders or anyone else who just really wants to know about this cool thing they keep hearing about Drush. Every time I practice this, it's worked until now. It's typical. I'm Karen Casio, better known throughout the Drupal community and pretty much anywhere on the web. You can find me at Tech Girl Geek. So you can connect with me pretty much anywhere using Tech Girl Geek. I'm going to figure out why I'm not connected here. I'll show that one more time. I'm a backend developer working at an design group in beautiful Denver, Colorado. We're an internet strategy design and development company. So we do the full gamut, working for NGOs and people doing great things all over the world, mostly nonprofits. We're also hiring, so if you're considering moving to Denver, Colorado, come see me or Lydia at our booth and drop off your resume. We're growing our team. It's a great place to work. So where does the name of my meetup come from? Do I really need it? I gave a presentation similar to this at a meetup in Denver or actually in Boulder, Colorado a few months back. Somebody raised their hand and asked me promptly, Drush, do I really have to use it? Good answer. I told that person, I'm not going to even answer that. I'm going to go through the presentation. I'm going to let you answer that by the end of this presentation. And if you still think you don't need to use it, then I didn't do my job right. This is so frustrating. We're supposed to work. Oh well, what do you do? So how many of you have heard of this Drush thing? Awesome. How many have used Drush? That's a pretty good number. Hopefully I won't bore those of you who've already used it. And so we're going to talk about why to use it and do you really need it? Absolutely really need it. I can't believe this didn't work. So sad. So basically Drush, what does it stand for? It's the Drupal shell. So it's running Drupal commands through the shell. If you go to Drush WS, you can actually find all these definitions. And of course these slides will be posted in the session recorded. So it really comes in three main parts and it's the project management section, which kind of allows you to manage your project. So it's managing your modules, what's installed, how to install it, installing things, disabling modules, enabling modules, upgrading modules. So I think we've got Drush Core, which is managing the core parts of Drupal, obviously. And then the SQL commands, where you can actually right from the command line get straight into your database, or you can actually run queries right from the command line. Yay, I got it. Finally. Yay. How do we get to Drush? Drush is a command line tool. I heard rumors somewhere that someone made a UI for it. I've never seen this. So if anyone's seen it, has anyone ever seen the UI for Drush? I think it was like two years ago there was a rumor it was actually coming, but I've never seen that. And I don't know why you'd want it. If you're on Windows, there is a good link on how to get it installed on Windows. I've never successfully ran it in Windows. I also don't run Windows often, so can't really talk to that much. macOS is terminal, if you're in Linux, obviously, you're usually on the terminal, so it should be accessible pretty easy. Installing Drush, this session is not going over installing Drush. I'm going to do a buff from one to two at Dressing Room Congress Hall, and we can go over different ways to install Drush. Bring your ideas to, if you know, but rare ways. There is no one way to install Drush. Pretty much like everything in Drupal, there's multiple ways to install Drush. But there are the recommended ways, of course. Of course, if you don't feel comfortable doing it yourself, because it's all command line stuff, you can always talk to your system administrator or somebody on your team, they'll make sure it will help you. Some of the things we're going to go over is downloading and installing and enabling modules, which is probably some of the biggest pain points, and take some of the longest times in the UI. Updating sites, not having to go through and disable everything, update. It can be a really long process. Drush can make it super quick, super easy. It backs everything up for you. Clearing cache, and if you don't know what caching is, that's holding all of your fun little things in memory. And if you know if you're building a brand new site, as things get changed, you have to clear those caches often. And it can be kind of a pain getting to the performance page, finding that button, show you how to do that in one fail swoop. And some other fun things, it's like archiving your sites. And then we'll go into, if we still have time, we'll go into a few more advanced things about creating like aliases, shortcuts on getting to certain things in Drush. But that's more advanced, and that's kind of, I'll have it in my slides so you can refer to it if we don't get to that. But I want to make sure there's time for questions if you have questions later. So site building in Drush. How many people just a poor dread going to that modules page? I know I do. Okay. If you don't already, I'm going to make sure you do by the end of this discussion. Because it can be really daunting really fast. How about updating sites? That's kind of scary. How many of you have let a couple of those little security updates slip for a while because it's going to be a real pain to have to update those modules manually? Come on, admit it. You've let those slide, see? So let's take a look at what it takes just to update a module. First of all, we're going to do it manually. And basically all we're going to do is install views. But I'm going to start with, I've already downloaded the tar file for views. Sorry, this is a little small. Most of them I've redone, but this one I didn't. So I've already got views downloaded. As you can see. So now we're going to go back to the UI. I've created a little demo page. Now we're going to bring up the modules model, modal. I can't say that word. Now we have to go through and we're going to go and find our views. So we can enable it. But we can't enable it because it's got a dependency. We need to go ahead and get C tools, which I haven't downloaded yet. So now I need to go to the project page for C tools. I need to find my C tools and I'm going to have to download the tar file. And I use a little tool called Wget. If you're not familiar with the command line, you may not know Wget, but it's basically downloading it from the command line. So I'm going to pull it down. Now I'm going to untar it. Now I'm going to go back to my module, modal. And I have to refresh the page. Now I'm going to look for C tools and look for views and enable them again. And we're going to save our configuration. And now they're enabled. Now, mind you, that's only two. You just started building this site and you know that you have ten modules you want to enable. That's going to get really tedious. You have to go through and you have to make sure the dependencies are available. So these are the steps I just went through. And of course, you see, rinse, repeat. I'm going to assume we've done it. Unload it, uncompress it, enable it, find the dependencies, rinse, repeat. And you have to keep doing this, right? And then very quickly that modules page, as we know, gets incredibly long in finding stuff. And sure, there's modules that can make it a little cleaner, but it's still, it gets daunting. So let's go ahead and see what that looks like in Drush. We're going to go ahead and download the views. And I'm going to go ahead and enable views. But I have to spell it right. I used a flag, which is the switch, the minus y, and it's telling it everything that you asked me, just go ahead and do it. So now see that it found that it needs C tools. So it went ahead and got C tools for me. And it went ahead and installed views UI. And we're going to go through the PM list here in a minute. But I want to see, did I actually enable it? Sure enough, there it is. It's enabled and C tool. So what's that? Two minutes versus 10 minutes or five minutes? Right away, you've just saved how much time? I'm showing you, you can do it the same way. Clear our screen. You can do, it's done. You can chain those together. So you could literally have a line. So you could do Drush, DL, or PM download, dash download. You could have six modules spaced by, as long as you have the name spelled right. That's the key. So you sometimes still have to go to the project page and you still have to find exactly the spelling. It's underscore if it's just one long name. But apart from that, once you've got that, you can string as many together as you want. Makes it a little faster? A lot faster. Now, let's say, whoops, what, what, sorry. Sorry. Anytime you see the dollar sign, that's me representing a prompt, in case you didn't realize that. So you can also uninstall and disable and uninstall modules the same way. Super fast. You don't have to go through that list. Disable one and it's like, oh wait, I can't disable views because, or can't disable C tools without disabling views. Or, I'm sorry, the other way around. You have to make sure all the dependencies are met. We can do this. I actually did one the other day. We moved a site live and we realized that we weren't going to run Apache Solar, so I wanted to turn off Apache Solar. I did not have access to Drush, so I had to go through the UI, which I never do. Ten minutes later, I'm still trying to find dependencies because I couldn't figure out like the screen didn't refresh or something. It took me quite a while, whereas if I had command line, it would have been one command I would have been done. So let's really quickly see what it's going to take to disable our C tools and views. Basically, I can disable them both at the same time. Again, I've given it the minus Y switch and it disables all of them. So if I disable views, it's going to disable views UI because it's a dependency. If I disable C tools, it's going to disable views because views is dependent on C tools. And then you uninstall it and then you can delete them. The PM uninstall, there is no shortcut and it doesn't do the dependencies. You have to do one at a time, which is what you see me doing here. Now, getting help for Drush. What if I forget my commands? Is there a way to get help? Well, of course. It's command line. It's something in Drupal. You think it's documented? It actually is. It's incredibly well documented. If you go to Drush.ws, that website has all kinds of great examples, great documentation. It's actually kept up to date, pretty much. So if you're looking for a good resource, there's Drush.ws. There's an IRC channel, Poundrush. But it can also do some command line stuff and get help, which we'll go ahead and do a short demonstration on that. So Drush.help is just basically going to give you every single command that's available in Drush. And there's a few of them. Many modules also have Drush components.  So here, I'm just kind of scrolling through all of them. It's going pretty quick because there's too many to go over individually. You see, there's one or two things you can do with Drush. I'm just literally hitting the tip of the iceberg in this presentation. If you think this is comprehensive or you're going to walk away and just completely know how to use Drush, it's no way. Feel free to go home and play. We're back to your hotel room. Oh, sorry. I actually meant to pause that. Oh, sorry. I guess I didn't know how to go through that faster. I'm sorry. I'm going to do a quick repeat on some of that. The second part of that is actually going through the Drush download or PM download help. I missed the prompt when it started doing that. I thought I could stop it. At the bottom of it, so anytime you do a Drush help, it gives you everything, but you can then you can do Drush help, a command where I do Drush PM download. And it gives you the switches or the flags that you can do for any command. So like PM download. I piped it to more so you can see it goes more slowly. And sorry, this is not going slowly. So right here, Drush help PM download. And I'm telling it to go to more so that it goes a little bit more slowly and showing you the different things you can do. You can set a destination. You can change the name. You can download a different version of a module. You can download the whole of Drupal, which we'll show later on. And at the end of most commands, you'll see an alias. So Drush PM dash download. You want to type it shorter. DL. So another one, Drush help cache clear. Like I said, you can clear cache. Building a new site every hour. Most of the switches have to do with what you're clearing. So cache clear and no adding nothing. It'll give you a choices. So you could clear menu cache, theme registry, or actually Drush clear, actually clear cache of Drush's own cache. And CC all does exactly the same thing. Sorry about that. So some basic things to know. Some basic commands. Drush cache clear, which we just went over. Something I use multiple times a day. Drush up. And I'll show you a little update demo here in second. Great way to update modules super quick. You can, again, update multiple modules. In my demo, I'm going to only show you one. But if you basically typing Drush up in return, it goes through and it gives you every single thing that needs, it checks every single module on your site. And you can do just security updates, just core, core and modules. I never suggest doing them all at the same time. You want to go ahead and do it in pieces so you can roll back. And Drush is really nice and does backups for you. You can actually update just the database. So if you know you've just done something and you need to check the update of the database, Drush update DB, or update DB, does the database from the command line. You don't have to go and find the right command. You don't have to log in as user one. It's all working as user one on the command line. Drush ULI or user login. If you just do Drush ULI, it's going to log you in. It gives you that one-time prompt and it gives you user one. If you want to test as user 67, you can say Drush ULI and another username that's on your site, and it's going to give you that one-time login link for that one person. So you can log in and test one of your users without having to go in and change their password.   Drush Archive Dump, or Drush ARD, does an archive of every single one of your files, the code, and the database into one big file. So now you have a backup. You don't have to sit there and worry about, oh, my God, if I break this, I'm going to have to reinstall everything. You can actually play around with your site and then you can do an archive, restore ARR and put it back to where it was before. Now I know how to do it properly. And Keynote failed me again. Curses to the person who said, this is going to save my life. So project management commands. I went over those a little bit. You've seen a little bit of that in some of my demos with the list and updates.  A PM list, lists of all modules available on your site and there's kinds of fun switches we can do with a PM list. And PM info, information about modules available on your site. So one of the switches we're going to look at is dash dash core or dash dash no dash core. So I want to see site modules, the status of a module in core or status of a module that isn't a core module. Let's see what this has got for us. Here's our little demo. Trash PM list and I'm doing it outright at first. Let's see what we can do with it. So we can find out which ones are enabled, which are not enabled. It's a module or a theme. So we're going to look at all enabled modules and themes on the site. Now let's see all enabled themes, which is just bar tick and seven right now. Yeah. Did you just uninstall it? I did uninstall it. It's not enabled. They're not enabled. Oh, you know what? I did, but they're not necessarily connected. Like I did them in different orders. So at the time that I recorded this demo, views was still enabled. Yeah, it was just out of order. Good catch, though. Yeah, had I done it in a different order, it would have shown them not there or uninstalled. So we already went through PM download, which is probably one of my favorites. And PM enable or AN enable, enable your module. Again, you don't have to do that hugely daunting module list. You can find every single module in the views UI and the views stuff or in features. And you can enable one at a time, you can enable one of them. If you enable one that has a dependency, like if you enable views UI and views has not been enabled, it'll enable views for you. So incredibly useful. So let's look at how to download the whole entire Drupal. Can you do that with Drush? Absolutely. Another great thing you can do with Drush is you can update itself. There's actually a self update of Drush. So when you see Drush is updated. Oops. Pretend that it didn't already exist. That's all it took. I just downloaded it. I'm going to go ahead and rename it to something else so that I can use it for whatever demo site I'm going to create right now or dev site or whatever else. Now I update my host file, update... Yeah, update HTTP conf and my host file, set up a database and I'm ready to start. Blank database. Five minutes, I've got a new site going. A little faster than using the UI. Just a little. So, like I said, I was going to show you how to update sites because I know that can get to be really daunting and frustrating and exhausting. And, well, daunting. Especially for the whole Drupal. The instructions say go through and disable every single one of your modules which now means if you have more than one, you have to remember which ones were enabled.  You want to put your site into maintenance mode. Which you probably should still do, but hopefully you're doing all of this. If you're actually a production site, you're doing this all through Git and so you know by now if it's going to break. You should not be doing this straight to a production site. That's my caveat. Give me my disclaimer now. So if I was going to do this manually, I'm downloading the new module, uncompressing it. I have to log in as user one, update the database, et cetera, et cetera. Or we can do it with Drush. This is just a module update that I'm doing here, but like I said, you can do security updates. You can do core updates. You can do theme updates. So I went through and I looked for updates and I needed to update DeVal. I gave it the minus y switch, so I told it go ahead and answer yes to any of my questions. And then it went ahead and it updated the database. So this is a whole, a second step that would have been a whole other step and you would have to go log in as user one, do the update, the database. It did it for me. Now I need to make sure, go ahead and test my site and make sure that it didn't break anything. And then I'll update it through Git to the production. Oops, is that supposed to say insert screencast? No, Drush does not put it in maintenance mode. Like I said, you shouldn't ever do this directly on a production site. So it should be very well tested. And then that way when you're doing it to a production site, literally you're only putting it in maintenance mode for maybe half an hour, literally just to pull your changes and update your database. It does not, but what it does do is it does update everything. So in your home directory or your site's home directory, like if you're logging in as, like even user in root, there's going to be a .drush directory. And in the .drush directory there will be update directories or backup directories and it actually backs up your modules. So you can lease, replace, return. But if it's doing a database update, that makes it a little bit more difficult to roll things back, obviously. So variables.  Anybody, nobody? Sort of? Okay. So variables, variables, sorry, are basically bits of information stored permanently in the database.  So a cron job is jobs that are run on a scheduled basis that do things like send out emails or check for updates, things like that. There's certain information about crons that you need to know and if you're writing the code you'll write code against, check if the last cron ran this today and if it didn't run today, make sure this happens at least once a day or something like this. Crons tend to get stuck and I'll give you a little hint of something to look for in crons. If you ever get that, crons already have been running and you keep getting that, we'll show you something you can do to unstick your crons. You can actually change the name of your site through variables. Some things like that. So you can use this, a vset or a vget or a vdelete, variable delete. You can actually delete your variables on the fly, on the command line. We're going to go ahead and do this demo and I'm sorry I didn't get a chance to re-record this one so you've got to look closely. So I did a drush vget inside the site, so I have to be inside the site and it's giving me every single variable that exists on my site. So I just did a vget for cron and it shows the Unix time of the last cron. If you ever see cron underscore semaphore and your site is stuck you could do a vdelete and that's what I'm just showing you what it was cron underscore semaphore and that actually takes so that's telling your system cron is still running.  So there I just deleted the last time the cron ran so it doesn't think cron ever ran. Use drush cron and it runs cron successfully and it's showing me again that the last cron is showing up again. So if you're running if you're developer or you as a developer and you have a nice code against um cron if you do a drush cron to test it now you just made sure the cron ran and now you can see if whatever that code you wrote to make the happen a cron ran so this is one way to check it. So how many of you ever run like SQL queries against your database or even play in the database at all? Okay cool make sure I'm talking somebody. So sometimes getting to MySQL can be a pain if you not in there so now you have to remember the name used for your database you have to remember the password so maybe go into your settings file because usually it's hard coded in your settings file copy and paste it out of there try to remember it can kind of get to be a little daunting or time consuming just to get into MySQL so if you get to your command line change directory cd into your site or you can do drush minus l in your url or as we're going to talk about here in a minute you can set up an alias to get you to your site so if you just do drush sql-cli or sql-c it puts you right into your database doesn't ask for the password it passes the username and password of your database gets you right into the database you're right into the right database you can actually run a sql query right from the command line so a super simple query select star from node where node ID is 123 right there you don't even have to get in your database you can do it right there I've actually dropped databases on purpose I promise from the command line created new tables, created new users it can all be done you can probably not do complicated stuff from command line just because I'd rather be in the database and really see it but you can if you want to be that trick daring you can do a drush sql dump which is going to basically dump your whole entire database right from the command line or a sql sync using your keys you can sync your database from your remote site to your local site so at prod and at dev that's syncing from prod to our development server and that's using aliases which like I said we're going to talk about that here in a minute so the drush sql connect I actually don't like that name command name but basically this basically connects to the database and you can if you have a dump that you want to import into your database that first command will actually take the dump and it imports it into your database on the command line so you can make sure you're in your site or you're using your aliases like I said drush sql sync we're pulling our database from our dev server in this case to our production or from our production to our dev server in this case and sql drop that's was dropping your database so if you want to rebuild it some more advanced commands we talked about was drush cron we've already talked about that running those scheduled jobs whenever you want not having to go and find waiting for it drush site install you can use that to install using a specific profile and php val so if you have a piece of code you want to run against your database or against your site you can do drush php val and actually take a piece of code and see if it's going to work against your stuff and actually write it into your code base so drush and aliasing like I said aliases are like shortcuts so instead of writing out this big long extensive command line trying to get to whatever you want to do this is less writing more productivity obviously drush is well that's what it is really more productive with much less typing so the shorter you can go the better so basically you can take that whole long command drush uri which is identifying what my site name is and the root side of my root and then I want to get the status of my site just to drush prog st a few more as characters the less characters the better the faster we're getting to our final product here's a quick alias demo and I'm sorry you can't do that I didn't get a chance to redo this one so this is a site and it's giving me all my aliases files it shows me where the root of my file system is now I'm not inside my I am no longer inside the directory where my site lives if I do a status it's just giving me the drush status it's giving me the status of drush but if I do my alias name prog dot local status now it's giving me the status of my site so this basically means that I don't actually have to be in my directory structure of my site to get the information so I could be anywhere and be like oh I need to update cron or clear my cache and I don't want to have to go see the sites Karen I use aliases I use aliases a lot because I have a lot of sites going on my site and I'm sure if you're here you're probably building more than one site and you probably have a few sites on your local or your devs server or wherever it is you're working so this helps not have to remember where you are on your system so this is an example of what an aliases file would look like a really basic aliases file like I said if you go to drush that has all kinds of examples really good examples for building your own aliases file and again these slides will be available for review so basically this just says that my aliases file this is for my alias prog site that's my URL of my site and that's where my files live this is great for my local site one site for this system and if you're going to come to the drush buff if you want to talk about aliases I can show you some of my aliases files and I can help you build one if we have time okay so if I want to create one for my remote this is basically the same thing again and I've given it this will access the remote server so this is actually not on my local site this actually doesn't exist I just made this for the demo but pretend I have a remote site belonging to my prog demo this is how I would get to it and then you really want to have your keys in place so that your systems can talk now if you're aliasing a group of sites and this is what I usually do I have an aliases file for each one of my sites so in this case it's a prog.aliases.dresh rc and you see that I have a location a lock file which is for my local and a dev which is for my remote site and how I would access that is at prog.lock or at prog.dev so you can actually do something against one each so I can get the status of my local site, status or my dev or I can get status of everything in my aliases file my prog.aliases file which is kind of awesome tool I think and even more advanced we can get into some bash aliasing and I'm not going to go into all this it's a little bit outside the scope but it's there in case you ever want to reference it so let me ask you do you really need to use drush? does anybody think you really don't want to use drush? how many think you really want to use drush? that's what I want to see excellent if you want to learn how to install drush I'm going to do a buff at one o'clock in dressing room congress hall I guess it's down the hall, I haven't actually found it yet and any questions? I was wondering if I could actually there's a microphone right there I want to get all of this great information on the recording so I was actually wondering if I could possibly use drush with the apc cache as well to speed it up I don't know the answer to that okay, thank you yeah that's awesome, thanks I think it controls mostly core cache I know I've done because apc is a separate piece so it's probably not but they're probably command line tools to controlling apc cache because I know when I'm controlling memcache I've always had to do it out of a separate piece so yeah sorry let's use IRC right? yeah, absolutely do you think it's a good idea to have drush installed on a production server? yes you were talking about it are there any risks involved? I don't know of any risks I usually have it installed for things like clearing cache checking on the status of things I don't recommend doing your updates obviously your downloads and updates to production that's just good practice but whenever I don't have drush every time I don't have drush I sit in my office and it was kind of funny doing the stuff that I was uninstalling last week I was like where's drush? we knew we were going to have to uninstall it but we didn't before we were pushing it to production stuff was already on production so now I had to go through and disable apache solar apache solar is not just one module it's dependencies on dependencies and yeah had I had it on the production server it would have been a three minute job trying to find the dependencies and figure out why it wasn't refreshing for clearing cache and things like that for sure and if you don't then you set up an alias file so you can get to it from your local right can you get to the microphone? it's wireless so we'll move it over as soon as he's done with his question I think it's possible to cut and pass more command together you must have one command at a time with drush I'm sorry I missed that on the console of drush I must do one command at a time or I can cut and pass some command can you so you can always do it with a semicolon so you could do drush and dl develop download develop semicolon drush enable develop minus y so yeah you can chain them just use a semicolon between it just like if you're running writing the code but if you do a semicolon between the different commands you can chain them I have done that before how is it possible to use drush to export configuration like variab and move some configuration from side to another so then you want to do a SQL sync so you could dump your database and upload the database you could sync the database from your remote to your development server because configurations are all in the database all entire database or even some variables or something I'm sorry I missed that last one all the sql all the database or even some variables some things I don't know yeah so all the variables are in the database as well um no because it's part of the database you have to do a partial database sync but you could do a vget and find out what that variable was and then you could go back to your other database and do a vset and set it to the same name so yeah you could just do it one at a time can you move past the mic over to the end of the table over there yeah thanks sorry progress too many stairs no worries quick question can you run drush with user one disabled because on production servers I usually disable user id one as a security practice so to make it less obvious security by obscurity huh there's a layer I can go into that but it is a layer so just a quick question can you run drush without user one I don't think you can because it runs as user one alright that makes sense yeah by default you can't I don't know how you there's a lot of things you couldn't do with user one disabled you cannot specify using a different user I think you said that you can if you can do the ULI to user login but when you're actually running drush I think you're running it as user one alright okay yeah I'm gonna try it out I mean you could probably still get into like the SQL commands because that's not using user one but things like doing update and things like that you have to be user one yeah that makes sense alright thanks anybody else can you please elaborate a bit more on the process of database syncing between the getting data from the production environment back to the development or stage environment and then syncing back to let's say a process of deployment using the drush as a tool so you need to set up your aliases file to see I can show you one of my aliases files actually where's my toolbar okay so what you do you want to have your aliases file to set up so they talk to each other and like basically a SQL sync actually pulls from the one database and it sticks it in the new database so it literally overwrites your database so you want to sync your files and sync your database um pull this over here for a second I can't get to the files when you ding it oh and this so the file open in front of me on this one okay so bear with me one second here I'll actually show you a real yeah I shouldn't hold on one second I'm going to pull out some database names here so this would be my aliases file sorry I'm too far this is a real aliases file yeah so that's my low it's really hard to do this sorry this is my cursor I can show you after probably makes more sense so here so here's my sync we don't well yeah I guess for when we're going from dev so this is for instance my aliases my bash aliases lost my cursor again hold on one second lose my cursor this is the bash aliases from syncing one site to the other site so actually are syncing it a SQL sync don't pull cache for my dev server for my production server to my dev server or dev to my local actually in this case hi and it's depending on the aliases if you run it like this it will make a huge copy of the the live one down to the development but it will overwrite the logs on the development server and it will also overwrite all the settings it won't just copy how do you just copy the content without the logs and without overwriting the settings we've been building in the development environment you want to just set up just copy the files the our sync copies the files but I want to have the what happens in live services people do change content node content so I just want to pull the node content to the development environment which I've been setting up with new modules new settings, new god knows what else yeah you can tell SQL sync to skimp certain tables like system tables and things like that dash dash data only let's see so we can do help SQL dump we can do data only dumps data without any of the schema if I can only resize this hold on a second I can't get my cursor I'm losing my cursor hold on one second let's see if we can there we go so let's see if it does dash help SQL no it doesn't look like it so yeah you can use the tables key which will actually give you certain certain things not to skip like there's certain caches like sometimes you don't want to you do not want to bring over the cache because tables because they're so huge right so you can tell it it's a little bit more stuff you have to put into your config files but you can tell it which you can actually create a database on the fly you can tell which tables not to skip and things like that so you can do that if you have any questions so please do take time to fill out the evaluation I'm really interested in what you think how I did up here because well because I did this presentation but I also would like to do it again and I want to make sure that if there's places I need to improve that I do so because I think it's kind of an important discussion I like I said I'm going to have the bop from one to two and you're welcome to join me and go over how to brush and that's our our have a fantastic Drupalcon and I will see you around


is a presentation of TFNN trade what you see with Larry Pezzavento all now toll-free at 1-877-927-6648 or internationally at<PHONE_NUMBER> now Larry Pezzavento okay folks I'm gonna do things a little differently on this show today Stan Harley will be our guest at the break talking to us about some cycle work that he's looking at but the main thing I wanted to do is I put this chart up which is the red line is my AI neural network it's a simple neural network I was introduced to it many years ago by Dennis Regan who passed away two years after I met him but during those two years Jim 20 men and Jimmy Elder worked with him very very what do you call it intensely to try to find something that was you know give us an idea what the markets were doing this was the type of thing that he would send out now this is when we had thermal faxes and what he did was he got in touch with Jim Steve Shapiro some somehow and Steve came he lived at the down at the beach I lived up on the top of the hill there in Pismo and he would come up just about every day he brought this fax and he said look this is what the market supposed to do today it was a pretty much like that just like this and and it worked and so I had a phone number there I called Dennis and that's about two hours after the trade was going on and this is when we were trading big handles in other words one point in the S&P was worth 500 not 50 points like it is now I had four of them and on I made a couple thousand bucks I was pretty happy so I called him up may say that was a pretty good call I said thank you thanks for letting me know that and what and he said you stupid SOP he said you ain't got brains enough to be a trader don't even use the F word I don't even bother me and he hangs up and I said I need this like I need whatever you know 12 fingers on my right hand whatever it happened to be I said this I'm here I'm done with this a couple days go by and I got another fax this time it came to me instead of Steve and it was the same type of prediction this one is for the British pound it also worked pretty good but I didn't call back 20 mine and talk to 20 but and I talked about this and we'd work with people like this in the past very difficult okay so basically we've got Peter from Park City Utah on the line Pedro how are you doing my friend I am good Larry her you how's that how's that soybean crop up there in the mountains of Utah yeah it's Idaho you're in Idaho aren't you yeah you're in Idaho no you Park City Park Park City is usually that's right that's where the Olympics were snow on the ground it's crazy yeah that's I heard that when they melt oh my god nine hundred inches it out of this year nine hundred has it ever been that high before no no wow even in Park City's they're breaking six hundred a day so now these are all way all-time records wow boys that when that stuff melts the soybean it went up today tap the fifteen hundred and failed again pulled right back to the 382 yes the next try up do you think it breaks it yes sir I think I'm very bullish the grains Peter I'm just waiting to buy them again they've been pretty good to me I missed a little piece of the sun of the action we've got that last piece so today's low is important because it like you mentioned it was a 382 and I think it's got a real chance now I might have to buy a breakout and I'm doing some work on buying breakouts what I've got to be able to do though is I've got to communicate it to the people to look if this breakout doesn't work this is what you have to do in other words most people don't like to do the work Peter so I'm gonna have to do it form and say look this is what's gonna happen if it doesn't happen this way it's wrong get out of dodge but right you wouldn't believe how many people don't get out of dodge they keep breaking no I'm thinking the same thing I'm like okay yeah I missed the 1480 I'm like all right yeah and usually usually leave such thing over you know they're truly no flat tops I mean if it's gonna go it's gonna go yeah sometimes takes two or three shots at it yeah now we've got for sure you up there and this will be the third if we go up there again I'm like hmm well that's what I'm waiting for tomorrow the next day we're being you know we've got Wednesday Thursday coming in hopefully by Friday we'll have a pretty good idea but that was a perfect a fact I've got it here I'll bring it up here it was a perfect ABCD last night said ah I can't sell this I can't sell anything so I I was watching it it was about when I got up about 3 30 this morning it just made that perfect ABCD right up there and it came right down to the 382 and I actually bought it there Peter just for a day trade and I got out of it just a little while ago but that's what I'm watching I think if we can do that then you know we'll be in good shape I got another one for you since I got you on the horn the Euro yes it teased me and I got out of it too quick this morning I had had to deal with the kids so I took took my couple tick profit and just like it well and then of course it rolled within the next you know 15 20 minutes but I was curious what your thoughts are you know the Euro do we correct from here pretty good I think I think significantly I'll post a chart here this is the long-term chart it's as perfect as can be and it's went right up to the 61% retracement it's backed off has it like you say it only moved out about four or five hundred dollars but you know it hasn't busted out to the upside if it gets above that one 1050 level then you know you can't stand in front of it right now this is a very very significant top in my opinion and the fact that it was it was able to break 240 points off of that spot and all we've been able to do so far is rally back to 3a2 so exactly that's what I that's exactly what I did I shorted it was it in the future is it 10 10 and like 11 something like that one time right now so that's I think in the right show and we get above 111 and you know get out of dodge as they say and let it go by itself because right now it's acting okay so we'll we'll see if it's going to continue doing that but that's what the start the charge look like so far no great now it's kind of what I'm thinking but hold my breath at the moment but I like to do one day I mean I'm only going to do like three hours which is a walk in the park but I've got some friends coming in just to court they like the gamble so I think they're coming into gamble and then we're going to go out to dinner so I get to see friends I haven't seen in a while which is fun and money show people treat treat me pretty good so I'll be all right one of these days I'm going to come up to see up there in Park City and likewise I'm going to make it either to center Vegas you're always will always welcome down here Peter for sure okay now all right sounds good Larry thank you so much for calling in folks okay folks we're going to be looking at here in the next moment or two we've got to take a little break here but I wanted to mention about the soybeans one more time because let me get that up here to bring that chart up because you know what I'm going to do here we got a break coming up here real quickly so I'm going to take a few seconds if you have any questions it's<PHONE_NUMBER> and I'll be happy to answer them for you I stand Harley will be our guest at the half hour break and which will be a lot of fun and I'm hoping we're going to have Mike Moore as our guest here on when we're going to have that well very soon here okay ah good currencies commodities and bond markets are as important as ever right now with how they're driving the volatility in equity markets across the globe which is why it's a great time to try out teddy keg stats tiger forex report teddy keg stat breaks down the forex markets every Monday using his 30 plus years of experience as a trading veteran of futures forex stocks and options teddy releases his weekly tiger forex report every Monday morning with coverage of all the major currency pairs including the dollar index the euro dollar pound dollar dollar Swiss dollar yen as well as many more and he also has weekly coverage of the crude oil market and the 30-year t-bonds as they both influence forex markets tremendously when you sign up for the tiger forex report you also gain instant access to teddy 60 minute webinar archive he just hosted forex strategies and fundamentals what is behind the tiger forex report for all the details and to start your 30 day tiger forex report subscription today visit the front page of tfnn.com tfnn educating investors tfnn has just launched their new trading room the tiger's den hosted at discord tfnn has been educating traders for more than 20 years with live programming hosted by a variety of professional traders during market hours and now they are expanding their reach with the tiger's den available to all tigers and tiger's for just one dollar for the year there's no cash or added costs when you join our community of traders in the tiger's den you can look over the shoulders of Tom O'Brien and the other tfnn hosts while they analyze charts during their live tiger TV programs and join an interactive trading community with hundreds of members exchanging ideas interact with other tigers and tigers is as they share trading ideas news analysis and discuss the market action all trading day even at night and on the weekends the tigers den at discord is accessible on mobile or tablets as well so it's always at your reach to sign up today and become a part of this educational community of traders just visit the front page of tfnn.com are you looking for a way to consistently add winning trades to your portfolio Tom O'Brien is here to help Tom O'Brien has been successfully trading markets for over 30 years a frequent contributor to TD Ameritrade Network and CNBC Tom O'Brien founded tfnn over 20 years ago to help educate investors just like you Tom's daily market newsletter market insights is published every morning when the markets open to give you the competitive informational edge you need to succeed these newsletters are packed full of Tom's advanced technical analysis and are geared to deliver comprehensive strategies for a successful portfolio get Tom O'Brien's newsletter market insights today and try all of our products and newsletters 30 days risk-free with our money back guarantee at tfnn.com tfnn educating investors at 1-877-927-6648 internationally at<PHONE_NUMBER> okay we're back folks and I do believe with a little bit of luck and some prayers we have Tim boss financial cycles weekly on the horn in the house is that true Tim on the phone I did with a man said tried the toll-free number and it worked it's amazing shut the front door and raise their end Tim before we talk about this solar eclipse that we have coming up could you mind telling the folks because everybody's been asking about how you're doing and what you went through I mean it was you we almost lost you a couple times didn't we oh well yes but I'm still kicking here that's a good thing no I contracted a rare disease called gillian beret syndrome and I actually had that 21 years ago it's a neurological disease disease that paralyzes you from head to toe and they told me 21 years ago that I could I was lucky to have survived and would not have to deal with it again but low and behold managed to get it a second time and been out of commission for a few months because of that right now I'm recovering slowly and I'm working with some physical therapists and getting my body back getting some some basic motion down and my head is still working my brain is spitting out all kinds of weird stuff so glad we can get some kind of connection made here today but that's really good and anytime you're ready to get back to your full-time status here of every two weeks we were sure loved to have you we've got something really big really big right now with this eclipse isn't it something special we've got a really unusual week ahead of us here or in the middle of it right now and coming up after tomorrow on Thursday we do have a solar eclipse and then on Friday the following day the 21st we have mercury going retrograde so that'll be an effect through the middle of May but the combination of these two intensifies things incredibly here the solar eclipse itself will not be visible in the US if you're in Indonesia or Western Australia you might be able to get a glimpse of it there but it's a very very powerful phenomenon nevertheless and we're expecting some interesting market results I tell you what I did was put together a little cheat sheet and if you want to jot this down you can get a free copy of it I'm sorry I don't have a slide to share with you with the address but it is if you go online to bit.ly bit.ly slash s e c s two three four and that's all caps there the second half of it s e c s for solar eclipse cheat sheet and that's two three four after that all one word so bit.ly slash s e c s two three four that'll give you a link to download our PDF file absolutely free which is kind of a quick cheat sheet so some of the facts you need to know about the solar eclipse and how you might want to work with it and your your trading as well so glad to share that but we have a question for one of our listeners and that is on an eclipse like this you know it's due to be coming in Thursday like most things as astrological they have an orb usually a day or two on either side does this have the same type of sequence actually it has even more important sequence so we get solar eclipses like this and the effects are all very often far beyond the date of the eclipse itself we do want to pay attention to this we do expect to see a market reaction kicking in especially with the combination with market retrograde so we're looking for some price consolidation kicking in toward the end of the week here with that eclipse point that will occur at 29 degrees of aries and that's going to remain sensitive in the zodiac so as things line up with that even during the next couple of months here we can see activations of that eclipse point and it will still play out in the markets so it's a little bit more complicated than meets the eye but we certainly want to pay attention right around the date of the eclipse a couple of days before a couple of days after and then it can pop up and impact things at various intervals even after that wow this is great listen the main thing is Bubba we want you to get better okay because you've helped a lot of people and boy they really were concerned about you you know well many people many people the people that contacted me and and we had a go fund me campaign still got the hospital bills coming in but yeah we you know there's a lot to deal with at lots of levels there and the big challenge for me of course was I was paralyzed unable to communicate I couldn't manage computer keyboard or anything else but went on so little by little I'm getting back to normal or whatever the heck that looks like well we'll see but we'll plan for some regular time together here I think within another week or so we can take a look at that I certainly hope so a lot of people gave me some several thousands of dollars to give to you but unfortunately the horse that I bet on in the fifth race at aqueduct didn't come in so maybe so give me some more maybe the next race to the year to walk out for that one all right buddy listen thank you and we're going to have you when you're ready just give me the jingle okay because we love that get something on the calendar here real soon so thanks everybody for your good wishes your prayers and it really meant a lot and it takes all all the minds working together to make this stuff happen so I'm very very grateful for the big outpouring that that came about through that and and again be sure to connect with that cheat sheet that's a bit about ly slash s e c s solar eclipse cheat sheet two three four and that will get you the link to download it thank you my friend listen you be safe and hopefully you'll see some sometime in 2023 we'll get down there and say hi to you uh we love that so it's been a long time since we've broken bread you know that's for sure it's always a lot of fun the bread is going to fail so come on down okay we'll talk soon my friend thanks everybody bye bye Simbo's financial cycles weekly folks we've got another break coming up here then we have stan harley i have to share with you something that just happened those of you that like 3a2 and we certainly do by the way folks we did get some nice donations for tim during this time and i was certainly happy to send that on but anyway this is the crude oil you notice here this little 3a2 well that was a 3a2 off the back here high that we made here seven days ago bang right on the money folks and it's already broken roughly six hundred dollars from that point so those like 3a2 and we certainly do you got to keep an eye on those because they don't lose often but when they do you're out of them in a hurry and if you stay in them in a while and they work they make some pretty serious money so let's keep our powder dry and wait and see how these things line up we're going to have the break here and in one minute and then from that time we're going to have stan harley back on the line but i wanted to share one other kent duncan story he ran kent duncan record kent done records in hollywood for many years and god he had so many golden platinum albums but we were in his office in hollywood one day and i was sitting at the desk with him and in walked mike mick jagger believe it or not is rolling stones and kent had a young girl working for him and i'll have to tell that story at another time which is probably good because i probably shouldn't for repeat it we'll be right back if you want to take advantage of this sector now is the time to subscribe to my gold report the gold report is a comprehensive look at the metal sector as well as the markets that move gold which is the currency and bond markets new subscribers get a 30-day money back guarantee so you have nothing to lose every monday morning i publish the gold report with coverage of gold silver bonds the xu hui gdx as well as more than 30 different mining equities to see for yourself the types of profitable trades that are recommended within the gold report sign up now by visiting tfnn.com don't miss out on the next great gold trade sign up today sharpening your skills as an investor is like getting better at playing a musical instrument you have to practice sure but you also need excellent instruction from experts at tfnn you'll get advice and guidance from the authority in technical market analysis and it's not just dry tedious text either tfnn airs live financial content streamed live on tfnn.com and tfnn's youtube channel with tiger tv live every market day from 8 30 a.m to 4 p.m eastern for free each host is an experienced trader and gives their take on the market while taking calls and questions live from around the world from the moment the market opens until the closing bell sounds tiger tv has eight different shows with expert hosts to help you make the right moves with your money watch online at tfnn.com or on tfnn's youtube channel and become the investor you were born to be tfnn educating investors are you looking for a way to consistently add winning trades your portfolio tom o'brien is here to help tom o'brien has been successfully trading markets for over 30 years a frequent contributor to tv america network and cnbc tom o'brien founded tfnn over 20 years ago to help educate investors just like you tom's daily market newsletter market insights is published every morning when the markets open to give you the competitive informational edge you need to succeed these newsletters are packed full of tom's advanced technical analysis and are geared to deliver comprehensive strategies for a successful portfolio get tom o'brien's newsletter market insights today and try all of our products and newsletters 30 days risk-free with our money back guarantee at tfnn.com tfnn educating investors this segment is brought to you by think or swim for more information just click the think or swim banner on the front page of tfnn.com okay we're back folks and i believe we have stan harley on the line harley stock market letter is that correct we do indeed larry ah what a lucky day twice in one day this is what we call a lucky day anyway um do you have a chance to post those charts that we were talking about on this previous show absolutely let me show you what i am looking at right now okay here is a uh chart of the s and p 500 going back several years and this is just kind of a recap larry this uh this reflects what i found is the dominant intermediate cycle in the stock market it spans 34 weeks eight months at cycle it contracts and expands like all cycles but nominally over the long haul we tend to see important pivotal turns about every 34 weeks eight months if you uh if you take the the last occurrence in the pattern which was the low we saw on october 13th of last year you had 34 weeks eight months you get mid-june just two months from now okay so well before you get a low obviously you have to have a high so that's what we're stocking right now um this next chart is uh something i just printed off a few moments ago this is a recurring pattern uh related to the one i've shown with you in some of our past discussions this is a chart of the dow and each of these purple lines are separated by 40 trading days plus or minus a couple and uh like clockwork for the last several years um at 40 trading day intervals plus or minus a couple left or right we've seen important pivotal turns it could be a high it could be a low the next one is due ideally drum roll today so if if if if history is any guide that would suggest we're right in the heart of the envelope for the next 40-day cyclical turn and of course since we're going up that would suggest that we would be making a high right in here and uh the next one uh is due ideally in mid-june which is exactly where i'm looking for a low wow it's really good stay and have a question the fact that the vix index i saw in Bloomberg today made a uh reading that showing that the people have been less bearish than at any time in the last two years is that do you look at those types of things i do i i i do um the volatility index is a component in the options pricing model there are a number of them the most commonly used one of course is black souls and one of the components in that complex calculation is the implied volatility of the stock market um and so through an iterative process one can compute what the implied volatility is because we know what the price is we know the time of exploration we know the strike price so we do the calculations over and over hot and back and forth back and forth and so it's possible to derive the volatility component within black souls model that's what we call vix vix simply put that expresses the expectation among the investment community as to what we think the volatility in the stock market for the ensuing 12 months is likely to be generally speaking because the stock market uh not all markets but the stock market tends to make spike bottoms and rounded tops so volatility tends to spike uh at troughs in the stock market now the opposite of course is true volatility tends to reach a low point at market highs and uh it's lower now than it has been since uh january the fourth 2022 which is the date in which the s and p made its all-time high there's a they said that on bloomberg they were showing that a chart and i said looked really interesting so that's okay that's what i wanted to know i was not aware of that but that that's something that i track and shown in my own report but absolutely it's not a precise timing tool to the day but it does put us in zone for the expectation to expect some kind of pivotal reversal reversal now a little bit more backdrop on the vix typically spike highs and i say typically in italics uh i find don't tend to correspond with the exact low of the move they tend to be a momentum low then there's some kind of rally and then a lower price low that sees a lower low in vix but nevertheless um you know we have a pretty pretty decent auxiliary tool to help us in timing the stock market okay yeah that's certainly i like that 39 day cycle though gee that's a that's been around for some people have to use that in their timing don't they i mean that's you know well yet i have talked about this for not just years but decades yes i know it's been the dominant cycle in the stock market for a long time now at some point in that some point usually comes when stan harley comes on larry show and starts talking about it the cycle the cycle gods are up there and they're gonna make stan harley look foolish they're gonna pull the knobs turn the cranks i know this never happens to you but it does have to be never they're gonna make this thing stop working yeah i i've been there been there and done that too many times yeah that's for sure anyway you want to tell us a little bit about this right translation and left translation that you're looking at absolutely so we're watching for this thing to stop working today um but on to newer and better things let's talk about translation another favorite topping of mine we typically see right and trap left translation sometimes center translation simply put uh in within the context of any kind of a cycle and i'm showing the trading cycles here on the s&p index we tend to see the crest occur to the right of the midpoint in a rising market environment that's called right translation i've abbreviated that done the abbreviation there rt conversely in a declining environment the crest or the high point the high price tends to occur to the left of the midpoint that's called left translation characteristic of a declining market environment the s&p in the last trading cycle uh exhibited right translation by one trading day the other four components among what i call the big five the big five dow industrials dow transports the nasdaq comp the new york comp and the nasdaq i track all five of those and only one among the five made right translation and the prior trading cycle the other components either exhibited center or left that tells me we're on borrowed time here and this thing is running out of juice on the upside here it is to the present time and i'm theorizing we're going to see two more lows between now and mid june one in late may and the other one in mid june so if we were top out right in here um we would among the other indices uh and the s&p the weight of the evidence would be tipped again towards left translation if that were to occur interestingly the dow did not go higher today compared to two days ago but the s&p did go a little bit higher so there's some divergence can't make a lot of that for just two trading days but i look at little things like that yeah you do that's what that's what you're famous for and you're good at it well thank you um it's a work in progress for all of us um and you can never get enough data that's what i say i'm more data is better the more the better of course then you suffer from paralysis paralysis of analysis too so it's a great sort eventually got to make a decision yeah indeed okay we'll pick this up after you bet we'll be right back with stan harley folks sharpening your skills as an investor is like getting better at playing a musical instrument you have to practice sure but you also need excellent instruction from experts at tfnn you'll get advice and guidance from the authority and technical market analysis and it's not just dry tedious text either tfnn airs live financial content streamed live on tfnn.com and tfnn's youtube channel with tiger tv live every market day from 8 30 a.m to 4 p.m eastern for free each host is an experienced trader and gives their take on the market while taking calls and questions live from around the world from the moment the market opens until the closing bell sounds tiger tv has eight different shows with expert hosts to help you make the right moves with your money watch online at tfnn.com or on tfnn's youtube channel and become the investor you were born to be tfnn educating investors everything in the universe is governed by the fibonacci sequence this mathematical principle is responsible for everything from the most aesthetically pleasing artwork to patterns in the stock market to stay on top of stock patterns you can take advantage of sign up for the fibonacci 24 7 newsletter at tfnn.com when you subscribe you'll get a weekly report from veteran day trader larry pesavento on stocks you need to pay attention to and you can trust larry's analysis after all he's got 45 years experience as a day trader larry will also provide daily charts videos and data on the key markets that he's tracking expect notifications from larry on market movement you need to act on at any time first-time subscribers also get a 30-day money back guarantee if you're not satisfied let us know and you'll get a full refund within 30 days of signing up subscribe to the fibonacci 24 7 newsletter today tfnn.com educating investors are china a shares hot or not if you trade china a shares now may be time to take a closer look trade chAU or chAD directions daily csi 300 china a share bull and bear etfs china a shares in either direction visit direction investments.com today an investor should consider the investment objectives risks charges and expenses of the direction shares carefully before investing the prospectus and summary prospectus contain this and other information about direction shares to obtain a prospectus or summary prospectus please contact direction shares at<PHONE_NUMBER> the prospectus or summary prospectus should be read carefully before investing an investment in the funds is subject to risk including the possible loss of principle the funds are designed to be utilized only by sophisticated investors such as traders and active investors distributor four-side fund services LLC this program is brought to you by vista gold traded on the nyse american and tsx under the symbol vgz folks speaking with stan harley the harley stock market letter please continue young man absolutely larry here is a a chart of the scp 500 that i spoke to briefly about an hour ago when you and i run the year this is a chart that goes back to the middle of 2021 but the important takeaway from here that i found is counting forward from the all-time high in the s&p by the lucas number series which is something as you know i i i put a great deal of emphasis on has has coincided with uh with all of the all most of the pivotal terms we've seen since then uh in in terms of lucas numbers um the lucas numbers uh 18 29 76 123 199 322 and so i know them from memory because they use them all the time um uh take note of the uh april 21st high of last year that was approximately 76 trading days from the uh from the all-time high in the s&p two times 76 is 152 and that coincided with the august high of last year within two trading days 199 lucas uh was the low we saw in october within four trading days um fast forward to today if you add 322 which is the very next sequence in the lucas number series 322 in terms of trading days when added to the january fourth high equals april 18th today so the wow the uh the analysis would suggest that today plus or minus four trading days is very plausibly going to see a pivotal turn and because the market has been going up i would uh i would posture that it's going to be a market high and then from a high that is occurring sometime between now and the next zero to four trading days i think we'll head south into that mid-june time period for the next 34 week cycle bottom that i'm anticipating okay that makes pretty good sense now you had one other chart i think that was it larith okay all right just good folks uh there's some contact information on on me well i can say unequivocally that if you're wrong this time we once been a pleasure knowing you but you will not be invited back again nothing like the elixir pressure huh chief hey stan thanks for joining us buddy i i really do appreciate it and you know you have to take everything tongue-in-cheek which we've been doing for the last 40 some what five six decades for me four decades for you so keep the faith we'll have you on again really soon okay and thanks for doing the second show today is very very important absolutely larry my pleasure you bet stan harley folks to the harley stock market letter and we'll get on here to another chart here in just a moment that we'll be able to chat about hold on bear with me here's folks and we'll get another one up here to look at well the number that we were looking at back here the market is backed off only slightly from that prediction that i had made a little bit earlier uh but that my the pro the ai program uh made it and it was it hasn't made a higher high let's put it that way hasn't gone anywhere but that's pretty much it the main thing is that the s&p has spent only two points above the 382 retracement of this move today uh that was at 41 78 and a quarter and it's been up to 41 81 i believe so and it's a tiny bit below that right now so that's telling you the market is a tad weaker the nasdaq is also a little bit weaker and i'll certainly be changing checking with these bank stocks to see how they did tomorrow because i want to be able to to see what they're going to be doing now tomorrow's guest will be jeff huge of alpha insights and on friday we're going to have uh mike more of more analytics on so that'll be uh be really a lot of fun to do uh i have a couple of ideas for this fall i might be doing a two-day seminar here in tucson arizona with uh with hold on something the old cash registers can give me a break here to see what's ringing oh we're getting a little bit of weakness in this dog market shut the front door and raise the ramp color me happy boys and girls color me happy bring out the old oh it's breaking pretty good that's what we like to see if you're short anyway and i am and you know folks let me let me someone asked a question about that 382 in the s&p just give me one second and i'll i'll get it up here it actually went to the 50 percent so hold on one second and we will take a quick look at it it only takes a minute and it did go to the 50 percent i didn't realize that the last i didn't get to the 81 level but i didn't realize that was the 50 level and of course uh they don't always work but when they do and when they do it makes it look pretty good but anyway that's where we were and i think this is a pretty significant top in here uh for many many reasons and of course nan added some others with that 39 day cycle that vix index is uh at an all-time low level from two years ago so no year and a half ago so i think it's important that we paid really close attention to what's happening here you know with these uh but these markets we've got an hour to go and it's always a lot of fun as we go through these things i wanted to i wanted to mention i'm getting ready to go to las vegas and i have now i have i don't have any of the clothes that i had Drexel because i couldn't get in couldn't get into those clothes but i have to tell you the story when i first went to work with Drexel in august of 76 they sent me to new york for two weeks of training because i had to get past the um broker's exam which took about 20 minutes back in those days you put your name address and phone number if you got two out of three you got a license but a lot different now over the year i had six licenses but the first thing i did when i got to Drexel they put me up at the plaza hotel right at central park boy i wasn't used to that kind of opulence folks the very first day the secretary picked me up and took me to a haberdashery store in uh manhattan that handled hickey freeman suits they were like a thousand dollars apiece back in those days they bought me five suits different colors stripes 12 custom made shirts ties shoes and slacks and and three blazers i mean i don't know how much money they spent on me but and i and i said why did you spend this much money on me before i even made a dime and he says well we know you're going to do okay so i had all these clothes all those years they were meant to keep of course and i did but a lot of memories behind that folks i mean it was really exciting the very first night that i went to dinner uh in in with the guys from uh Drexel in new york we were eating at the La Paragoy and what does that mean i can't remember it's not yet La Paragoy is a french restaurant and as we went in the uh the very first table was Marge Everett who owned the uh new york Mets and the next table over was Jacqueline Onassis and Jacqueline and and Aristotle Onassis were there at their restaurant and i had my first taste of escargot and i eat them every time i mean i was a little country boy from indiana we used to eat those things with garlic and everybody thought we were crazy but when you go to new york there were ten dollars uh for just six of them but anyway guys say i've been so lucky boys and girls and you're you're part of my luck i mean i get to do this every single day and have a lot of fun and i thank you all for joining me and stuff i know some of you guys that's hey tomorrow's another day live every day in an attitude of gratitude and thank god bless if you're looking for potential trading setups in the stock market then rocket equities and options report is a newsletter you should try tomyo brian delivers options and equity trades when the markets present them using a combination of fundamentals and technicals sign up for rocket equities and options report today with a 30 day money back guarantee so you have nothing to risk for all the details and to start your subscription today visit the front page of tfnn.com tfnn educating investors you might think that if you want to be successful at trading in the stock market you're going to need a crystal ball after all it's impossible to predict the future right like any endeavor in life before you decide it's impossible get some advice from the experts you might find that it's not so impossible after all for daily market overviews that give you direction on the key indices selective stocks and commodities subscribe to the opening call newsletter at tfnn.com the opening call newsletter is written by basal chapman creator of the trading methodology known as the chapman wave the chapman wave up down sequence gives you an edge in identifying price turns finding the peaks and valleys and stock prices get the opening call newsletter by basal chapman in your inbox every day first time subscribers also get a 30 day money back guarantee if you're not satisfied let us know and you'll get a full refund within 30 days of signing up tfnn.com educating investors everything in the universe is governed by the Fibonacci sequence this mathematical principle is responsible for everything from the most aesthetically pleasing artwork to patterns in the stock market to stay on top of stock patterns you can take advantage of sign up for the Fibonacci 24 7 newsletter at tfnn.com when you subscribe you'll get a weekly report from veteran day trader larry pesavento on stocks you need to pay attention to and you can trust larry's analysis after all he's got 45 years experience as a day trader larry will also provide daily charts videos and data on the key markets that he's tracking expect notifications from larry on market movement you need to act on at any time first time subscribers also get a 30 day money back guarantee if you're not satisfied let us know and you'll get a full refund within 30 days of signing up subscribe to the Fibonacci 24 7 newsletter today tfnn.com educating investors tfnn has launched the tiger's den hosted at discord tfnn has been educating traders for more than 20 years with live programming hosted by a variety of professional traders during market hours the tiger's den available to all tigers and tigeresses for just one dollar for the year there's no catch or anecd costs when you join our community of traders sign up today and become a part of this educational community of traders just visit the front page of tfnn.com catch tom will brian professional trader and educator founder of tfnn also a special guest on cnbc tom will bisect and dissect the markets the tom will brian show next on tfnn okay we're back folks and we have the stocks are still down on the day and we've got the uh currencies are up on the day that means the us dollars under retreat a little bit and then also we have the uh hold on one second i want to double check something and that is the fact that the uh what was the other one natural gas is still acting pretty strongly gold and silver are still strongly up on the day gold at 2016 and silver at uh 25 and change boy folks is one thing i would never do and that is i wouldn't sell silver up in here because there's just that chart looks like it did in 1978 when silver broke out of eight dollars an ounce on its way to 54 dollars an ounce and i wrote that puppy up a long way i was a very happy camper back and i'm happy all the time what are you talking about anyway that's pretty much it i've got a other stories about my days at Drexel that i'll share with you over the weeks and because i'm not going to do an uh an autobiography it's just too much effort and uh i will be able to tell some stories and stuff that uh that i can remember the good thing about what i do do is i try to tell the truth because my grandma said if you tell the truth at 10 you don't have to remember what she said it to so that's what i have it's my dr pepper uh well view of life so it's all the same thing at 10 that you do it too and you're going to be okay because what there's you just can't tell one lie folks one lie leads to two lies and uh sometimes you have to do it to keep people from being hurt but that's neither a story that i don't want to get into it okay how much time we have got to build time is really going fast yet we only got about a few seconds left tomorrow our guests will be jeff huge on friday our guests will be mike more of more analytics try to do something nice for your um friends and relatives if you can or strangers whatever it is because you can't take it with you folks be like bob hope make sure that your lacks check bounces so live every day in an attitude of gratitude and may god bless


The signal oil program The whistler at whistle is your signal for the signal oil program The whistler am the whistler and I know many things for I walk by night I know many strange tales hidden in the hearts of men and women who have stepped into the shadows Yes, I know the nameless terrors of which they dare not speak Yes friends, it's time for the signal oil program the whistler Rated by independent research the most popular West Coast program in radio history and Signal gasoline is tops to tops in quality It takes extra quality, you know to give you extra mileage and signal is the famous go farther gasoline So look for the signal circle sign in yellow and black that identifies friendly dealer owned signal stations from Canada to Mexico And now the whistler strange story The body off Billingsgate It was a grim scene there on the dock at Billingsgate with the early morning Fox whirling eerily around the three figures bending over the shapeless mass on the plank The Scotland Yard inspector the sergeant with his notebook and Peterson the nervous little fisherman Stammering answers to the inspector's methodical question Oh, thank I say the man's been dead about 12 hours. You've got that sergeant. Yes Mr. Peterson you say you would moored your boat out down the river. That's right inspector About two hours ago it was then as I was coming in in the small boat here I spotted the body in the water. I see nearly right ran into it. I did Any idea who he is inspector looks like an American blow on the head sergeant blunt instrument put that down Let's have a look in his pockets No on the air How do you suppose a poor bloke come to this gangster affair probably most of the gangsters seem to end up this way? What is it inspector a check for five thousand pounds on the buckney's bank Signed by our Wilfred Greenwood Stay here and look after things will you sergeant? Yes medical examinal be up shortly I'm going over to have a talk with the manager of that bank.  Yes, it was obvious that the man had died as the result of a blow from a blunt instrument But there was something more important than that Something the inspector was to find out later at Barclays Bank Something which indicated that the most important cause of the man's death was a normally harmless instrument Just an ordinary fountain pen It had been more than a month before and a fog like this one that Victor Milton Groped cautiously toward the glowing yellow rectangle of an outdoor telephone booth in the murky darkness. Yes listening Yes operator, I want to put through a trunk call to London, please. That's right. How is it along with you? No, hurry John Victor cancel the call hang up What the deuce Vic? I didn't know you were in Leeds. I thought you thought I was in London. I know Who are you calling? Oh?  You're wrong Vic. I've nothing to do with two weeks since you joined the organization Two weeks since the other mob has been knocking off our trucks Funny coincidence isn't it? No no no wait a minute because I can explain you can begin by telling me who you were calling in London I told you just a friend quit stalling. I got a train to catch Who was it John?  I won't tell you big I'll kill you Give me back Yeah, that's better Vic don't do it No, and that's how it began Victor with a young man named John Greenwood Dead at your feet at a public telephone booth in Leeds You bend down quickly take his wallet and gun and hurry off into the night It's three blocks to the railroad station in the trains due in five minutes You stop for a moment on a bridge over a canal near the station Rappie and the gun and wallet and then hurry up onto the station platform Thanks, thanks a million. Oh, you're not tuffy a toppy I must sound awfully silly. It's a family nickname for my brother I thought you were toppy you see he was never on time for a train in his life I'm sorry to disappoint you. Oh, it's not bad at all If you'd be good enough to sit down, I shouldn't wonder if I could start reading my paper Oh, I'm so sorry. I didn't realize we were in your life. Yeah, sure. Sure. Go ahead. We'll sit down over here. Thank you Well, who's your boy Colonel Blimp You hear you That's funny, isn't it? You never know who you run into in a file Colonel Blimp or or what an angel from the first cloud You're American always come straight to the point, don't you how did you know I was an American? Oh The way you talk now wait a minute. I've only been here for two weeks, but I've been working hard I say bowler instead of dirty petrol instead of gas You're as bad as toppy. He wants to sound like an American and can't pull it off either I do wish he'd got here. You're not worried. Are you? No, but he promised to ride to London with me to see father. It's my first trip to town in almost a year You see I've been at school in Leeds and oh dear. I must sound like an awful chatterbox Oh, not at all. What's your brother doing in Leeds? He's just taken on a new job commercial traveller pain hardware that sort of thing He's young of course and a little irresponsible, but he'll settle down No danger of puppies turning into a spiv Spiv yes, you see a spiv is a Well, it's a new word in our vocabulary, sir an unfortunate addition I might add. Oh, how do you mean colonel?  Oh wonderful. I'll see you home. Oh, I I couldn't oh not another word now After all I have to do something useful now and then what do you think I am a spiv? You really shouldn't have gone to all this trouble my dear young lady It's after midnight the fogs as bad here as it was in Leeds. It'll be 10 Bob. Okay. Here you are driver Careful in the book now. It's a better. Hi, sir. I'm certainly grateful to you. It's the first time. I've been here You see father just moved in last week. Oh, I see Thank you father still up. I'll be insulted if he isn't he knows I'm coming Hillary It's so good to have you home my dear and toffee. Oh, I'm afraid I'm happy mr. Train father I thought I'd better see your daughter home, sir. It's a little late for her to be out along Well, uh, thank you young man.  Oh the telephone make yourself at home. Will you Hillary? I'm sure the young man can do the spotter brandy when I see here. It's pretty late. Perhaps.  Don't be too harsh with him father Do you prefer brandy or whiskey? You know I don't even know your name All this way and we haven't even been introduced. I'm sorry. My name is Milton Victor well, how do you do mr. Milton? I'm Hillary. How do you do? Yes? I'm listening officer. What is it father? What's the matter? I see Identification from the coat. Yes. Yes. Yes. I'll catch the first train north. Thank you. Thank you very much. Goodbye Father what's happened? Puppy That was the police up in Leeds. He's not in another scrape not anymore He's dead Hillary. What his body was found in the fog by a telephone booth Been robbed. I'm awfully sorry. I guess you two want to be alone. Yes Thank you for seeing Hillary home. Mr. Milton if there's anything I can do off it kind of you mr. Milton Our name is Greenwood Greenwood Wilfred Greenwood. My son was John John Greenwood John Greenwood you always call him tutty Rob But why would anyone rob him? He never had anything. He never I uh, I think it was something else Hillary And I'm going to find out who killed him if it's the last thing I do With the prologue of the body off Billingsgate the signal oil company is bringing you another strange story by the Whistler But now I'd like to ask one of the ladies here in the studio a question Did you serve iced tea for supper iced tea of course not in this weather We prefer a hot drink precisely and just as you choose a different diet in cool weather Remember your car needs a different cold weather diet to if you want to keep performance up and wear down Just what do you mean by a cold weather diet for a car? Well first of all the transmission and differential should be drained and refilled with a correct winter grade of signal gear lubricant If your front wheel bearings and speedometer cable haven't been repacked for 5,000 miles now is a good time to tend to that And of course for a sweeter running motor the old oil should be drained and replaced with a correct winter grade of signal premium motor oil That amazing new type oil that actually keeps motors six times cleaner and reduces cylinder wear one third one more Question what is the correct winter grade of oil that differs according to the make of car its age and the climate But your signal dealer can tell you exactly because he has an official factory chart Which shows just what lubricant the manufacturer recommends for each part on your particular car This is just another extra in signal dealers complete line of services and product to help your car run better Look better and last longer Now back to the whistler It's a terrible shock Isn't it Victor the knowledge that the man you killed in Leeds was the brother of the girl you met riding up to London John Greenwood Hillary's brother and it's hard for you to believe that her brother could be like that That he could be the son of an obviously influential and respectable citizen like Wilfred Greenwood But that's the way it is Victor a thing that might happen once in a million times has happened to you It unnerves you doesn't it but not enough to destroy your role as innocent strangers They haven't the slightest reason to suspect Victor and you decide that their friendship might be valuable You send flowers and condolences to John Greenwood's funeral then wait a few days before Telephoning Hillary. Oh Hello, Mr. Milton. Thank you so much for the flowers. Oh, I'm sorry. I couldn't do more to help But I realized that at such a time I Read about some flowers this morning in the Times. Oh, yes, the carnations are blooming in Hyde Park Say, I'll bet you haven't been out in the fresh air for a week You haven't You know, I think a stroll through the park or perhaps some voting would be just a thing for you That's to go Restful out here, Mr. Milton. I do feel relaxed now. That was the general idea But it's your expense aren't you tired of rowing? Oh, not at all and I can use the exercise I don't believe it. So if you're anything like father too involved in business, you're all the same. Oh, no No, I don't overdo it father does lately anyway Tell the truth, Mr. Milton. I'm worried about him. Oh Taken top is John this so hard. I really didn't expect him to be this way John always got into scrapes and father's been so very proper. There were times when they had real differences Father's so hurt by it. Haven't Haven't the police any idea who shot your brother? No But father won't give up. I Wish I could help some way you've done a lot already. Mr. Milton make it Victor. Will you all right then Victor? That's better much better Yes, Victor. It's going well and as you continue to see Hillary during the days that follow You begin to feel more secure Knowing the friendship of influential people like the Greenwoods makes everything solid the sweet of the Carlton the office in Oxford Street Your pose is the enterprising young American businessman Yes, Hillary will solve some problems, but not all of them. What's wrong Ernie? What's holding us up money? They got two of our trucks again last night on the Great North Road Suiting materials tweeds Worcester's close to 4,000 pounds. Oh, I'd like to know who's tipping them off I could be anyone they've got a man on every corner. There's no getting away from them. We need money, huh? Yeah quick All right, Ernie All right, I'll get it. Who do you know over here?  It's sweet of you to say that What are we waiting for Hillary? I I don't know Vic It's the first cloud on the left and we're sitting right on it together I Never want to let you get away Would you? Would you think it's strange if I proposed right here on the dance floor? You shouldn't what will father he won't object and what if he does I I don't know Oh, we've wasted too much time already Hillary. Let's let's do it. Let's elope when right now darling We can oh yes, we can I've already got the special license. Well Hillary Hillary, please please we can talk about it on the way On the way. Yes darling after all you can't expect me to be married without my hat and coat Well go ahead Mrs. Milton ring the bell. I feel so nervous now that we're back thick I I don't know how to say father Why so jittery? He's all prepared you wired him dear. I know but here here our ring Come on chin up darling. I don't know why I'm acting like this Hello father. Well Hillary you did get back and you Victor married to my daughter. That's right, sir Well, what are we standing here for come in you, too?  Well, so with a curl like Hillary. Oh, it's all right My boy, I'm pleased. You must know that by now The quality of the champagne certainly says something mr. Greenwood. Good.  Oh now father? We really didn't expect you never mind now dear Haven't any family heirlooms to pass along but my bank account can certainly stand a substantial present to both of you Where are my glasses Hillary mr. Greenwood? Hillary's right. Oh, yeah here here. I can't see without them Vicki you make out the check But sir I go on go on now. You may as well do it darling. He always gets his way. Well All right What's the date darling our wedding day? How can you forget? October 11. Oh sure. Oh, I'm all mixed up today, darling October 11th 1947 Oh, let me see October is the 10th month, isn't it? That's right 10 11 47 Who shall I make it out to mr. Greenwood? Call me dad, won't you and make it terrible to yourself? Of course, you'll be the man of the house. I hope On my glasses yet Hillary Order of Victor Milton five thousand miles Thousand pounds you sound like you don't believe me early. I'll feel better when I see it skip it You better keep your eyes on the road They hijack us again tonight with through How much farther to lead ten miles the boys are meeting us at the warehouse in the Crikey, what's the matter? Look up ahead It's a roadblock gun it up. I can't give her the gas. I said the loads too heavy will tip over Who is it? You know them it's them again the same ones. I know that Laurie are there.  No Vic. We ain't got a chance What's the idea where are we keep moving mate?  All right. Hold it here mate Come in where do you find him? He jumped off the truck when we held it up. All right, mate You can take off that blindfold Yeah, I'll do it fine thing shoving a guy around like What For a moment you can't believe it can you Victor let your standing face-to-face with your new father-in-law? Wilfred Greenwood pitch it can't be that there must be some mistake He's up now mistake. He was on the truck. He said it was his I see all right Go back to the truck, but I'll take care of him. Give us an hour alone right now So pop you're in this racket too, huh? You're the guy that's been hijacking my trucks. It was you Vic you killed John I don't know what you're talking about. I've had men working on my son's murder ever since he was killed And I told them to bring me the man who did it no matter who he was They brought you Victor and they don't make mistakes as simple as that Huh, of course, mr. Greenwood now that I'm your son-in-law Hillary is better off rid of you Wait a minute. Wait a minute. You can't shoot me without you didn't wait for it when it was John No, Vic. I'm you're doing nothing. Oh, let me go. Give me that gun Give it to me That's better mr. Greenwood. What are you going to do? I haven't much choice. Oh, you won't get away with it Vic my men will be back here in an hour. I can get lost in England in less than an hour You'll never stop running. I'll be alive Greenwood and with enough money to run a long ways Thanks to you watch your check for five thousand pounds Vic.  Good morning. Good morning. I'd like to cash this check. Very well, sir Mr. Greenwood's check pay to the order of victim Milton five thousand pounds. Yes. I'm His son-in-law of course. All right, mr. Milton if you'll wait just a moment. I'm sure we can honor it for you The whistler will return in just a moment with a strange ending to tonight's story Meantime since tomorrow is Thanksgiving Day I want to say for signal oil company and the almost 2,000 signal dealers who serve the seven Pacific Coast states from Canada to Mexico We hope that your Thanksgiving cornucopia will be filled to overflowing Not only with good food, but also with good health and good cheer Certainly all of us can be thankful from the bottom of our hearts that we are living in America the land of abundance and freedom for all We have the signal oil family like to feel that in our 17 years of serving the West We have played a part in furthering the way of life that is America Because signal dealers own their own business They are carrying on the tradition of the independent businessman who has played such an important role in building America and Signal oil company by supplying signal service stations with constantly finer products Has helped each signal dealer keep abreast of that ever-present healthy competition, which is the key to America's continuing progress Competition which helps all of us here in America enjoy the highest in the world standard of living And now back to the whistler Yes, the man discovered by the fisherman at Billingsgate died from a blow by a blunt instrument According to the records at Scotland Yard But in a strange way the real cause of his death was the stroke of a fountain pen on the scrap of paper If another man had held a pen the victim might never have died But the fatal pen marks could never be erased or changed They were still there on that check for 5,000 pound found in the dead man's pocket signed by Wilfred Greenwood Even 12 hours in the cold water of the Thames River hadn't blurred a line The Scotland Yard inspector waited quietly as the cashier at Barclays Bank examined the check carefully I say the check is wet inspector It's yes the man is made out to this Victor Milton was found dead at Billingsgate dark a few hours ago I see a suicide inspector hardly games to affair I'd say revenge for something the bloke had done You've seen that check before. Yes only yesterday. Mr. Milton was in trying to cash it inspector We had to refuse him of course. Why is that? I feel quite badly. He acted so strangely almost desperate Yes, he was it seems he'd written the check himself for mr. Greenwood to sign, but he post dated it I explained that the check couldn't clear for another month. He post dated it. Yes, it was dated 10 11 47 You see he was obviously an American and they write a date differently than we do They put the month first and the day next well here in England Of course, we put the day first and the month second then this check hero is just reversed He meant to indicate October the 11th, but actually in writing 10 11 he made it November 10th Just a difference in trust that's right, but I had to tell him we couldn't honor the check until a month from now Strange fellow, you know He seems so anxious to have the money But when I suggested he have mr. Greenwood write him another check. He didn't say a word Just looked at me and walked out Let that whistle be your signal for the signal oil program the whistler each Wednesday night at this same time Brought to you by the signal oil company marketers of signal gasoline and motor oil and fine-quality automotive accessories Signal has asked me to remind you to get the most driving pleasure drive at sensible speed Be courteous and obey traffic regulations It may save a life Possibly your own featured in tonight's story were walley mayor and Alma Lawton Whistler was produced by George W. Allen with story by Leslie edge Lee music by Wilbur hatch And was transmitted to our troops overseas by the armed forces radio service Next Wednesday for a full hour of mystery over most of these stations tune in a half hour earlier Enjoy the saint as well as the whistler This is Marvin Miller speaking This is cbs the columbia broadcasting system